Re: SQL 2000 backup problem with 3.1 TSM server

Thanks Eric, but:

1. page you are referred is not available already (??)
2. can you tell me where is TDP SQL 2.1.1 code available? I was looking for
it on ftp://service.boulder.ibm.com but there is only 1.1.2 and 2.2.1 (and
5.1.5) releases. I had never seen any installation medium of this release.
Are you sure, that 2.1.1 release exists?

Many thanks
Tom

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU]On Behalf Of
Loon, E.J. van - SPLXM
Sent: Tuesday, October 29, 2002 1:24 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: SQL 2000 backup problem with 3.1 TSM server


Hi Toma9!
You have two options:
1) Install the Tivoli Storage Manager Server for 0S/400 PASE as soon as it
is available (I don't see it on the FTP server yet, but it should be
available according to the Tivoli page
http://www.tivoli.com/products/resources/storage-mgr/enhancements-v5.1.5.htm
l
2) Use the TDP for SQL Server 2.1.1.0 client. I don't know for sure, but the
3.7 server prereq is not listed for this release.
Kindest regards,
Eric van Loon
KLM Royal Dutch Airlines


-----Original Message-----
From: Toma9 Hrouda [mailto:throuda AT HTD DOT CZ]
Sent: Tuesday, October 29, 2002 13:06
To: ADSM-L AT VM.MARIST DOT EDU
Subject: SQL 2000 backup problem with 3.1 TSM server


Hi all,

I need to resolve problem with backup of SQL 2000 server. Customer has TSM
server on AS/400 release level 4.1 (this is in fact service level 3.1.2.80)
and TDP for SQL v2.2 and get next messages in tdpsql.log:

10/25/2002 15:06:13 ACO0302E A failure occured on stripe number (0), rc =
418
10/25/2002 15:06:13 ANS1358S (RC58)   Session rejected: Downlevel server
code version
10/25/2002 15:06:14 ACO5452E Unable to delete temporary object:
(PRGBW01\data\0001) (\testbackup) (\full.2002102515060900000CE8)
10/25/2002 15:06:14 ANS1358S (RC58)   Session rejected: Downlevel server
code version
10/25/2002 15:06:14 Backup of testbackup failed.
10/25/2002 15:06:14 ANS1358S (RC58)   Session rejected: Downlevel server
code version

There is in TDP SQL Inst&User Guide noted, that client needs TSM server v
3.7.4 and higher (page 4), and I think that's failure reason. Is any
solution possible (except of file backup of stopped SQL database), if there
isn't TSM server on AS/400 higher than 3.1 level? Did anybody try to backup
SQL 2000 server with TDP for SQL v1.1 - is it possible or not?

Thanks

Thomas Hrouda
Storage Specialist
HTD s.r.o. Praha
throuda AT htd DOT cz
tel. +420 (2) 6791 3157
fax. +420 (2) 6791 3162


**********************************************************************
For information, services and offers, please visit our web site:
http://www.klm.com. This e-mail and any attachment may contain confidential
and privileged material intended for the addressee only. If you are not the
addressee, you are notified that no part of the e-mail or any attachment may
be disclosed, copied or distributed, and that any other action related to
this e-mail or attachment is strictly prohibited, and may be unlawful. If
you have received this e-mail by error, please notify the sender immediately
by return e-mail, and delete this message. Koninklijke Luchtvaart
Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be
liable for the incorrect or incomplete transmission of this e-mail or any
attachments, nor responsible for any delay in receipt.
**********************************************************************