ADSM-L

Re: SQL 2000 backup problem with 3.1 TSM server

2002-10-29 07:24:45
Subject: Re: SQL 2000 backup problem with 3.1 TSM server
From: "Loon, E.J. van - SPLXM" <Eric-van.Loon AT KLM DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Tue, 29 Oct 2002 13:24:14 +0100
Hi Tomáš!
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: Tomáš 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.
**********************************************************************