IMPORT NODE issues...........
Hi, We are currently attempting to import a node that spans over 43 tapes. It has failed may times due to, the backup over ruling the import priority and grabbing a tape drive. Thus killing the import node. We don't wish to turn off logging from "roll forward" Any other ideas so the "import node" can consume only 2 tape drives and all other processes only take up the other tape drives ?? Thanks, Adrian This message and any attachment is confidential and may be privileged or otherwise protected from disclosure. If you have received it by mistake please let us know by reply and then delete it from your system; you should not copy the message or disclose its contents to anyone. == <>
Re: IMPORT NODE issues...........
Why not setup a new Device Class for this import and limit the number of tape drives it can use? Regards, Michael Swinhoe Storage Management Group Zurich Financial Services E-mail: mailto:[EMAIL PROTECTED] Adrian Hicks <[EMAIL PROTECTED]To: [EMAIL PROTECTED] GROUP.COM> cc: Sent by: "ADSM: Dist StorSubject: IMPORT NODE issues... Manager" <[EMAIL PROTECTED]> 25/09/2003 07:54 Please respond to "ADSM: Dist Stor Manager" Hi, We are currently attempting to import a node that spans over 43 tapes. It has failed may times due to, the backup over ruling the import priority and grabbing a tape drive. Thus killing the import node. We don't wish to turn off logging from "roll forward" Any other ideas so the "import node" can consume only 2 tape drives and all other processes only take up the other tape drives ?? Thanks, Adrian This message and any attachment is confidential and may be privileged or otherwise protected from disclosure. If you have received it by mistake please let us know by reply and then delete it from your system; you should not copy the message or disclose its contents to anyone. == ___ The information contained in this message is confidential and may be legally privileged. If you are not the intended recipient, please do not read, copy or otherwise use it and do not disclose it to anyone else. Please notify the sender of the delivery error and then delete the message from your system. Any views or opinions expressed in this email are those of the author only. Communications will be monitored regularly to improve our service and for security and regulatory purposes. Thank you for your assistance. ___
Re: Backuset processing question
Richard, The answer to your question is no. If you were looking to restore a single file, then you might need to rad through a lot of tape, but if you are restoring a whole filespace then you shpuld see data being restored straightaway. I found it a lot easier to deal with backupsets taken at filespace level, in fact I can't remember now if I ever got them to work trying them as a complete client. Netware is finicky for syntax, say you are trying to restore client1 data: filespace to client2 then the following syntax will work. NB. don't forget that final backslash load dsmc rest backupset -repl=n -su=y backupsetname client1\data: client2\\data:\ Hope this helps. Richard Rhodes <[EMAIL PROTECTED]> on 09/24/2003 09:28:04 PM Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] cc:(bcc: John Naylor/HAV/SSE) Subject: Backuset processing question Yesterday I asked about a long Netware restore. In playing around, we are tring to perform a restore of the backupset that we created. The backup set looks like: 4 tapes (IBM 3590) Size: 240gb Files: 938,617 Backup from: NW5.1 SP3 Restore to: NW5.1 SP3 TSM client v5.1 When we start the backupset restore, it looks like the TSM server is trying to read through all the tapes. It mounted the first tape and appeared to read it for over an hour. It then mounted the second tape . . . . and is still doing something with it after 30 min. The Netware admin doesn't see any activity on the system we are restoring to. Very weird. Q) Does a backupset restore read through the entire backupset before actually sending any data? Thanks Rick (Isn't Netware such Fun . . . . ) - The information contained in this message is intended only for the personal and confidential use of the recipient(s) named above. If the reader of this message is not the intended recipient or an agent responsible for delivering it to the intended recipient, you are hereby notified that you have received this document in error and that any review, dissemination, distribution, or copying of this message is strictly prohibited. If you have received this communication in error, please notify us immediately, and delete the original message. ** The information in this E-Mail is confidential and may be legally privileged. It may not represent the views of Scottish and Southern Energy plc. It is intended solely for the addressees. Access to this E-Mail by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. Any unauthorised recipient should advise the sender immediately of the error in transmission. Scottish Hydro-Electric, Southern Electric, SWALEC and S+S are trading names of the Scottish and Southern Energy Group. **
Supported Device ADIC FastStor 2
Hallo TSMers, is the autoloader ADIC FastStor 2 with LTO (not LTO2) supported with TSM Device Driver 4.2.2.0? I searched the IBM Website, but there is only information about devices supported with TSM V. 5.1.x! Mit freundlichen Grüßen Sascha Bräuning DB/DC C/S-Systeme/Überwachungsverfahren FE/KA Sparkassen Informatik GmbH & Co.KG Wilhelm-Pfitzer-Straße 1 70736 Fellbach Telefon: 0711/5722-2144 Telefax: 0711/5722-2147 Notes: Sascha Bräuning/6322/FE/SI/[EMAIL PROTECTED] E-Mail: [EMAIL PROTECTED]
Re: Scalar DLC
We are using this same configuration. In the past, we partitioned a Scalar 10K with the Scalar DLC into 2 virtual libraries. We run TSM in both environments running on AIX. We have had some problems that was attributed to the Scalar DLC, but I believe we would have had those same problems regardless of what backup software and OS we are running. Those problems seem to have been resolved. We have re-partitioned the library recently via the Scalar DLC and ran into some issues that multiple reboots of each system seems to have fixed. -Original Message- From: Levinson, Donald A. [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 24, 2003 2:48 PM To: [EMAIL PROTECTED] Subject: Scalar DLC Is anyone on this list using the ADIC Scalar DLC to partition their Scalar library into multiple virtual libraries? I would like to find out other people experience with this unit and how well it works with TSM on AIX. thanks. This transmittal may contain confidential information intended solely for the addressee. If you are not the intended recipient, you are hereby notified that you have received this transmittal in error; any review, dissemination, distribution or copying of this transmittal is strictly prohibited. If you have received this communication in error, please notify us immediately by reply or by telephone (collect at 907-564-1000) and ask to speak with the message sender. In addition, please immediately delete this message and all attachments. Thank you.
Journal
Hi all, We want to start with Journal-Based Backup on some of our W2K-Servers (3.5 Million Files). TSM-Client : V 5.1.5.1 The TSMJournaleService is installed and now we get a lot of messages in the Application Event Log of that Client : Error : 4099 - Unable to journal object 'D:\...' : Access Error 32 SYSTEM has all rights on those files and directories. Has anybody had this problem and can help ? Chr. Pilgram Boehringer Ingelheim Pharma GmbH & Co.KG
Journal
>>> The TSMJournaleService is installed and now we get a lot of messages in the >>> Application Event Log of that Client : Error : 4099 - Unable to journal >>> object 'D:\...' : Access Error 32 >>> SYSTEM has all rights on those files and directories. This return code indicates the journal service is unable open the drive for monitoring because it is locked by another process (rc 32 is a sharing violation). The drive is opened for "list access" which is about the lowest level access that can be requted so I'm not sure why this would happen. What level of the journal service are you running ? Pete Tanenhaus Tivoli Storage Solutions Software Development email: [EMAIL PROTECTED] tieline: 320.8778, external: 607.754.4213 "Those who refuse to challenge authority are condemned to conform to it" -- Forwarded by Pete Tanenhaus/San Jose/IBM on 09/25/2003 09:20 AM --- Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> Sent by:"ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] cc: Subject:Journal Hi all, We want to start with Journal-Based Backup on some of our W2K-Servers (3.5 Million Files). TSM-Client : V 5.1.5.1 The TSMJournaleService is installed and now we get a lot of messages in the Application Event Log of that Client : Error : 4099 - Unable to journal object 'D:\...' : Access Error 32 SYSTEM has all rights on those files and directories. Has anybody had this problem and can help ? Chr. Pilgram Boehringer Ingelheim Pharma GmbH & Co.KG
Re: Oracle Recovery failed
The log from the first backup is a little baffling because Oracle is claiming that it cannot find the archive log but Data Protection for Oracle is not complaining. Compare it to the second log where DP for Oracle is actually giving an error that the archive log requested by Oracle cannot be found on the TSM Server. The information that you have given me thus far does not tell me much. However, in this RAC environment are you backing up your data all from the same node in the cluster? If not are you duplicating the DP for Oracle nodename to all DP for Oracle nodes so that all the backups are cataloged to the TSM Server under the same node? The most common problem seen in RAC environments are the fact that backups are done from different nodes from within the environment but each node is using slightly different TSM/TDP options so that during the restore to a particular node not all of the backup information can be retrieved. These are just some thoughts that I have. If none of this helps I highly suggest that you use our support channels to resolve this problem; they are knowledgable in this area. -- Date:Wed, 24 Sep 2003 18:55:06 +0200 From:Nalevajko Tomas <[EMAIL PROTECTED]> Subject: Oracle Recovery failed Hello guys, I encounter problems in oracle recovery and I'd like to ask for some suggestion what to check or change. We have implemented TDP for Oracle. There is Oracle RAC. Backup entire database succeed. Problems are if we try to make recovery. Restore process goes ok, all dbf files are restored. There are failure in recovery when restoring/recovering archive log files. this is portion of log file from first try: Starting recover at 23-SEP-03 starting media recovery channel node2: starting archive log restore to default destination channel node1: starting archive log restore to default destination channel node2: restoring archive log archive log thread=2 sequence=344 channel node1: restoring archive log archive log thread=1 sequence=798 channel node1: restored backup piece 1 piece handle=fjf20obo_1_1 tag=TAG20030922T233624 params=NULL channel node1: restore complete unable to find archive log archive log thread=1 sequence=798 released channel: node1 released channel: node2 RMAN-00571: === RMAN-00569: === ERROR MESSAGE STACK FOLLOWS === RMAN-00571: === RMAN-03002: failure of recover command at 09/23/2003 09:08:20 RMAN-06055: could not find log sequence 798 thread 1 RMAN> **end-of-file** and something like this in another try: channel node1: starting archive log restore to default destination channel node2: starting archive log restore to default destination channel node1: restoring archive log archive log thread=1 sequence=800 channel node2: restoring archive log archive log thread=1 sequence=801 channel node1: restored backup piece 1 piece handle=frf21o42_1_1 tag=TAG20030923T083826 params=NULL channel node1: restore complete released channel: node1 released channel: node2 RMAN-00571: === RMAN-00569: === ERROR MESSAGE STACK FOLLOWS === RMAN-00571: === RMAN-03002: failure of recover command at 09/23/2003 12:09:25 ORA-19507: failed to retrieve sequential file, handle="fvf21p7c_1_1", parms="" ORA-27029: skgfrtrv: sbtrestore returned error ORA-19511: Error received from media manager layer, error text: ANS1302E (RC2)No objects on server match query RMAN> **end-of-file** There is also non clustered databse on one node. We did not see any problems with this database. Several tries was made. Finally, it recovered successfuly but during another restore/recovery after database backup it behaves same as before. Any ideas or suggestions? Thanks. -- Nalevajko Tomas e-mail: [EMAIL PROTECTED] homepage: www.dcs.fmph.uniba.sk/~nalevajk -- Regards, Neil Rasmussen Software Development TDP for Oracle [EMAIL PROTECTED]
Re: Backupset processing question
Hey Richard, From my finite experience of restores from Backupsets and with Novell/NetWare, (I just did one (500 Gigs worth) in August), I found out that if you have 7 tapes and the information is on tape 1, it puts the information out (restores) when it gets to tape 1, but has to read through the other 6 tapes to finish the restore no matter if all the data is on tape 1. Thank You, Bill Rosette Data Center/IS/Papa Johns International WWJD Richard Rhodes <[EMAIL PROTECTED]To: [EMAIL PROTECTED] GYCORP.COM> cc: Sent by: "ADSM: Subject: Backuset processing question Dist Stor Manager" <[EMAIL PROTECTED] EDU> 09/24/2003 04:28 PM Please respond to "ADSM: Dist Stor Manager" Yesterday I asked about a long Netware restore. In playing around, we are tring to perform a restore of the backupset that we created. The backup set looks like: 4 tapes (IBM 3590) Size: 240gb Files: 938,617 Backup from: NW5.1 SP3 Restore to: NW5.1 SP3 TSM client v5.1 When we start the backupset restore, it looks like the TSM server is trying to read through all the tapes. It mounted the first tape and appeared to read it for over an hour. It then mounted the second tape . . . . and is still doing something with it after 30 min. The Netware admin doesn't see any activity on the system we are restoring to. Very weird. Q) Does a backupset restore read through the entire backupset before actually sending any data? Thanks Rick (Isn't Netware such Fun . . . . ) - The information contained in this message is intended only for the personal and confidential use of the recipient(s) named above. If the reader of this message is not the intended recipient or an agent responsible for delivering it to the intended recipient, you are hereby notified that you have received this document in error and that any review, dissemination, distribution, or copying of this message is strictly prohibited. If you have received this communication in error, please notify us immediately, and delete the original message.
POSTSCHEDULECMD failed, but event was successful
TSM Client 5.1.6.7 on Windows2000 SP4 TSM Server 5.1.7.1 on AIX 4.3.3 I have coded a PRE and POSTSCHEDULCMD that stops some Oracle services, backups up and then restarts the services. My POSTSCHEDULECMD keeps track of the highest return code and then EXIT %MAXCC%. Testing with this today, my POSTSCHEDULECMD did and EXIT 2, and you see that in the DSMSCHED.LOG file. The problem is that the event itself didn't Fail. Executing Operating System command or script: c:\progra~1\tivoli\tsm\scripts\orastart.cmd 09/24/2003 22:17:10 Finished command. Return code is: 2 09/24/2003 22:17:10 ANS1903W The POSTCHEDULECMD command failed. 09/24/2003 22:17:10 Scheduled event '@166' completed successfully. 09/24/2003 22:17:10 Sending results for scheduled event '@166'. 09/24/2003 22:17:10 Results sent to server for scheduled event '@166'. According to the TSM Client doc: For Windows NT, 2000, XP systems: If the postschedulecmd command does not complete with return code 0, the client will report that the scheduled event completed with return code 8 (unless the scheduled operation encounters a more severe error yielding a higher return code). Why didn't my schedule event finish with Fail?? Anyone seen this behavior? Bill Boyer "Some days you are the bug, some days you are the windshield." - ??
Re: POSTSCHEDULECMD failed, but event was successful
Hi, Seen something like it and started to use pre- and postnschedulecmd for a client because of it. At this client it looked like it took to long to stop and start the services (non oracle). Regard, Karel -Oorspronkelijk bericht- Van: Bill Boyer [mailto:[EMAIL PROTECTED] Verzonden: donderdag 25 september 2003 16:33 Aan: [EMAIL PROTECTED] Onderwerp: POSTSCHEDULECMD failed, but event was successful TSM Client 5.1.6.7 on Windows2000 SP4 TSM Server 5.1.7.1 on AIX 4.3.3 I have coded a PRE and POSTSCHEDULCMD that stops some Oracle services, backups up and then restarts the services. My POSTSCHEDULECMD keeps track of the highest return code and then EXIT %MAXCC%. Testing with this today, my POSTSCHEDULECMD did and EXIT 2, and you see that in the DSMSCHED.LOG file. The problem is that the event itself didn't Fail. Executing Operating System command or script: c:\progra~1\tivoli\tsm\scripts\orastart.cmd 09/24/2003 22:17:10 Finished command. Return code is: 2 09/24/2003 22:17:10 ANS1903W The POSTCHEDULECMD command failed. 09/24/2003 22:17:10 Scheduled event '@166' completed successfully. 09/24/2003 22:17:10 Sending results for scheduled event '@166'. 09/24/2003 22:17:10 Results sent to server for scheduled event '@166'. According to the TSM Client doc: For Windows NT, 2000, XP systems: If the postschedulecmd command does not complete with return code 0, the client will report that the scheduled event completed with return code 8 (unless the scheduled operation encounters a more severe error yielding a higher return code). Why didn't my schedule event finish with Fail?? Anyone seen this behavior? Bill Boyer "Some days you are the bug, some days you are the windshield." - ??
Re: Oracle Recovery failed
There is not a lot information on rman log. It is much better to use sbtio.log like an alternative information source about what is happening. Which is the sbtio.log message ? Por favor, responda a "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> Enviado por:"ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> Destinatarios:[EMAIL PROTECTED] CC: Asunto:Re: Oracle Recovery failed The log from the first backup is a little baffling because Oracle is claiming that it cannot find the archive log but Data Protection for Oracle is not complaining. Compare it to the second log where DP for Oracle is actually giving an error that the archive log requested by Oracle cannot be found on the TSM Server. The information that you have given me thus far does not tell me much. However, in this RAC environment are you backing up your data all from the same node in the cluster? If not are you duplicating the DP for Oracle nodename to all DP for Oracle nodes so that all the backups are cataloged to the TSM Server under the same node? The most common problem seen in RAC environments are the fact that backups are done from different nodes from within the environment but each node is using slightly different TSM/TDP options so that during the restore to a particular node not all of the backup information can be retrieved. These are just some thoughts that I have. If none of this helps I highly suggest that you use our support channels to resolve this problem; they are knowledgable in this area. -- Date:Wed, 24 Sep 2003 18:55:06 +0200 From:Nalevajko Tomas <[EMAIL PROTECTED]> Subject: Oracle Recovery failed Hello guys, I encounter problems in oracle recovery and I'd like to ask for some suggestion what to check or change. We have implemented TDP for Oracle. There is Oracle RAC. Backup entire database succeed. Problems are if we try to make recovery. Restore process goes ok, all dbf files are restored. There are failure in recovery when restoring/recovering archive log files. this is portion of log file from first try: Starting recover at 23-SEP-03 starting media recovery channel node2: starting archive log restore to default destination channel node1: starting archive log restore to default destination channel node2: restoring archive log archive log thread=2 sequence=344 channel node1: restoring archive log archive log thread=1 sequence=798 channel node1: restored backup piece 1 piece handle=fjf20obo_1_1 tag=TAG20030922T233624 params=NULL channel node1: restore complete unable to find archive log archive log thread=1 sequence=798 released channel: node1 released channel: node2 RMAN-00571: === RMAN-00569: === ERROR MESSAGE STACK FOLLOWS === RMAN-00571: === RMAN-03002: failure of recover command at 09/23/2003 09:08:20 RMAN-06055: could not find log sequence 798 thread 1 RMAN> **end-of-file** and something like this in another try: channel node1: starting archive log restore to default destination channel node2: starting archive log restore to default destination channel node1: restoring archive log archive log thread=1 sequence=800 channel node2: restoring archive log archive log thread=1 sequence=801 channel node1: restored backup piece 1 piece handle=frf21o42_1_1 tag=TAG20030923T083826 params=NULL channel node1: restore complete released channel: node1 released channel: node2 RMAN-00571: === RMAN-00569: === ERROR MESSAGE STACK FOLLOWS === RMAN-00571: === RMAN-03002: failure of recover command at 09/23/2003 12:09:25 ORA-19507: failed to retrieve sequential file, handle="fvf21p7c_1_1", parms="" ORA-27029: skgfrtrv: sbtrestore returned error ORA-19511: Error received from media manager layer, error text: ANS1302E (RC2)No objects on server match query RMAN> **end-of-file** There is also non clustered databse on one node. We did not see any problems with this database. Several tries was made. Finally, it recovered successfuly but during another restore/recovery after database backup it behaves same as before. Any ideas or suggestions? Thanks. -- Nalevajko Tomas e-mail: [EMAIL PROTECTED] homepage: www.dcs.fmph.uniba.sk/~nalevajk -- Regards, Neil Rasmussen Software Development TDP for Oracle [EMAIL PROTECTED]
Re: Supported Device ADIC FastStor 2
Hello Sascha, ADIC Scalar 2 is not supported in the 4.2 release. Regards, Hunny Kershaw Sascha Braeuning <[EMAIL PROTECTED]To: [EMAIL PROTECTED] ORMATIK.DE> cc: Sent by: "ADSM: Dist Stor Subject: Supported Device ADIC FastStor 2 Manager" <[EMAIL PROTECTED]> 09/25/2003 05:13 AM Please respond to "ADSM: Dist Stor Manager" Hallo TSMers, is the autoloader ADIC FastStor 2 with LTO (not LTO2) supported with TSM Device Driver 4.2.2.0? I searched the IBM Website, but there is only information about devices supported with TSM V. 5.1.x! Mit freundlichen Grüßen Sascha Bräuning DB/DC C/S-Systeme/Überwachungsverfahren FE/KA Sparkassen Informatik GmbH & Co.KG Wilhelm-Pfitzer-Straße 1 70736 Fellbach Telefon: 0711/5722-2144 Telefax: 0711/5722-2147 Notes: Sascha Bräuning/6322/FE/SI/[EMAIL PROTECTED] E-Mail: [EMAIL PROTECTED]
ADSM Command
Group, I have a slew of tapes I'm trying to validate. Is anyone aware of a command to validate whether a tape is bad or not. Currently I have to wait until TSM tries to write to the tape before I know the status. Any help would be greatly appreciated. BTW, I've searched all references I have to no avail. Thanks again Don Owings Product Operations Manager CSG Systems Inc.
Re: ADSM Command
Try " AUDIT VOLUME ". See the help of this command before use it. Por favor, responda a "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> Enviado por:"ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> Destinatarios:[EMAIL PROTECTED] CC: Asunto:ADSM Command Group, I have a slew of tapes I'm trying to validate. Is anyone aware of a command to validate whether a tape is bad or not. Currently I have to wait until TSM tries to write to the tape before I know the status. Any help would be greatly appreciated. BTW, I've searched all references I have to no avail. Thanks again Don Owings Product Operations Manager CSG Systems Inc.
ANS0113E message
A co-worker just upgraded the TSM client software on a Windows NT system from 3.7.0.0 to 5.1.5.0. When he attempts to start the GUI client he gets a dialog box with the title "Backup/Archive Client" and the text "ANS0113E NLInit: Message repository 'dscameng.txt' has an invalid control record." The messages manual did not prove particularly helpful; the first ANS message listed is ANS0201E.
Re: ANS0113E message
Hi, Try to copy the dsmameng.txt from the TSM client install dirs. Sometimes it is not updated and the one that is used is from the old TSM client. Regard, Karel -Oorspronkelijk bericht- Van: Thomas Denier [mailto:[EMAIL PROTECTED] Verzonden: donderdag 25 september 2003 18:03 Aan: [EMAIL PROTECTED] Onderwerp: ANS0113E message A co-worker just upgraded the TSM client software on a Windows NT system from 3.7.0.0 to 5.1.5.0. When he attempts to start the GUI client he gets a dialog box with the title "Backup/Archive Client" and the text "ANS0113E NLInit: Message repository 'dscameng.txt' has an invalid control record." The messages manual did not prove particularly helpful; the first ANS message listed is ANS0201E.
Netware 6 & TSM 5.2 Client
Hi all! I have a customer who has just implemented Netware 6.0 and the TSM 5.2 client. Everything seems to be ok apart from the fact that there are SAN volumes which are assigned to the Netware 6 server (filespace called DATA01:) which are not recognised by the TSM client. the SYS: volume is being picked up no problem. Even if I try and perform an INC DATA01:\ it comes back telling me that the filespace is invalid. Anyone have the same problem? All the Netware 5 servers with the TSM 5.1 client are ok - then again, I dont have any SAN attached volumes on these servers. regards, Rowan O'Donoghue Technical Services Manager Unitech Systems Bracken Business Park Bracken Road Sandyford Industrial Estate Dublin 18. Tel: + 353 - 1 - 2942300 Fax: + 353 - 1 - 2942319 www.unitech-ie.com
Can I create a Node Archive from a full-increment (full backup) in my backup diskpool? <
I did not receive an answer for this the first time I sent it 2 days ago . Has anyone had experience in this with making a node archive from the first full-backup in a primary diskpool? Ken Sedlacek AIX/TSM/UNIX Administrator [EMAIL PROTECTED] IBM Certified Specialist: RS/6000 AIX v4.3 Support IBM Certified Specialist: RS/6000 SP & PSSP 3 Tivoli Certified Consultant - Tivoli Storage Manager v4.1 __ TSM 5.1.6.3 W2K server TSM client 5.1.5.15 We have a remote NT4 server client that we have take a spare W2K TSM server to physically to make the first backup, as we are not sure its WAN connection bandwidth is sufficient for this first backup.. I have made its first Backup (which is a full backup) into a diskpool. I have also configured the client for compression and subfile backup. My question is: When we get this spare TSM server back to HQ, can I now make an archive of the client from the backup in the diskpool? If so, what steps are needed? TIA. Ken Sedlacek AIX/TSM/UNIX Administrator [EMAIL PROTECTED] IBM Certified Specialist: RS/6000 AIX v4.3 Support IBM Certified Specialist: RS/6000 SP & PSSP 3 Tivoli Certified Consultant - Tivoli Storage Manager v4.1
SQL Restore Fails
I am attempting to restore a 90 gig SQL database to a test server ( not the original location). The Restore will start and I will have disk activity but then it will stop and generate a TCPIP connection failure, 09/25/2003 11:30:03 Request : RESTORE 09/25/2003 11:30:03 Database Input List : - 09/25/2003 11:30:03 Object Input List : - 09/25/2003 11:30:03 Group Input List : - 09/25/2003 11:30:03 File Input List : - 09/25/2003 11:30:03 Log or Set Input List : - 09/25/2003 11:30:03 Into Input List : - 09/25/2003 11:30:03 Undo File : - 09/25/2003 11:30:03 Relocate Input List : - 09/25/2003 11:30:03 To Input List : - 09/25/2003 11:30:03 Include Inactive Files? : Yes 09/25/2003 11:30:03 Number of Buffers : 3 09/25/2003 11:30:03 Buffer Size : 1024 09/25/2003 11:30:03 Number of SQL Buffers : 0 09/25/2003 11:30:03 SQL Buffer Size : 1024 09/25/2003 11:30:03 Number of Stripes specified : 1 09/25/2003 11:30:03 Wait for Tape Mounts? : Yes 09/25/2003 11:30:03 DateTime : - 09/25/2003 11:30:03 MarkName : - 09/25/2003 11:30:03 After : - 09/25/2003 11:30:03 Recovery : Yes 09/25/2003 11:30:03 Replace : Yes 09/25/2003 11:30:03 Restricted User Only? : Yes 09/25/2003 11:30:03 Partial? : - 09/25/2003 11:30:03 TSM Options File : C:\Program Files\Tivoli\TSM\TDPSql\dsm.opt 09/25/2003 11:30:03 TSM Nodename Override : - 09/25/2003 11:30:03 Fromsqlserver : HQSAPPRO 09/25/2003 11:30:03 Sqlserver : MACSAPTST 09/25/2003 11:30:03 09/25/2003 12:46:22 ACO5436E A failure occurred on stripe number (0), rc = 418 09/25/2003 12:46:22 ANS1017E (RC-50) Session rejected: TCP/IP connection failure 09/25/2003 12:46:23 Restore of PRO failed. 09/25/2003 12:46:23 ANS1017E (RC-50) Session rejected: TCP/IP connection failure 09/25/2003 12:46:23 Total database backups inspected: 1 09/25/2003 12:46:23 Total database backups requested for restore: 1 09/25/2003 12:46:23 Total database backups restored:0 09/25/2003 12:46:23 Total database skipped: 0 09/25/2003 12:46:23 Throughput rate:0.67 Kb/Sec 09/25/2003 12:46:23 Total bytes transferred:3,145,728 09/25/2003 12:46:23 Elapsed processing time:4,580.04 Secs 09/25/2003 12:46:23 ACO0151E Errors occurred while processing the request. Does anyone have any ideas , what is causing this? I am using the latest SQLTDP 5.1.5.15, I have upgraded the B/A client to the latest 5.2 version, hope this is not causing the problem. I have increased the TSM server's commtimeout to 1800 ( 30 minutes) and it does not change a thing. Thanks for your help John Stephens www.Storserver.com
Re: SQL Restore Fails
John, Yes. I know what the problem is. The answer can be found in the IBM Knowledge Base.Go here: http://www-3.ibm.com/software/sysmgmt/products/support/IBMTivoliStorageManagerforDatabases.html and search for "ANS1017E". It will come up with 1 hit.. reference# 1114216. In a nutshell... you need to increase the COMMTIMEOUT value on your TSM Server to allow the SQL Server time to preformat the database. Thanks, Del > I am attempting to restore a 90 gig SQL database to a test server ( not the original location). > The Restore will start and I will have disk activity but then it will stop and generate a TCPIP connection > failure, > > 09/25/2003 11:30:03 > 09/25/2003 12:46:22 ACO5436E A failure occurred on stripe number (0), rc = 418 > 09/25/2003 12:46:22 ANS1017E (RC-50) Session rejected: TCP/IP connection failure > 09/25/2003 12:46:23 Restore of PRO failed. > 09/25/2003 12:46:23 ANS1017E (RC-50) Session rejected: TCP/IP connection failure > 09/25/2003 12:46:23 Total database backups inspected: 1 > 09/25/2003 12:46:23 Total database backups requested for restore: 1 > 09/25/2003 12:46:23 Total database backups restored:0 > 09/25/2003 12:46:23 Total database skipped: 0 > 09/25/2003 12:46:23 Throughput rate:0.67 Kb/Sec > 09/25/2003 12:46:23 Total bytes transferred: 3,145,728 > 09/25/2003 12:46:23 Elapsed processing time: 4,580.04 Secs > 09/25/2003 12:46:23 ACO0151E Errors occurred while processing the request. > > Does anyone have any ideas , what is causing this? I am using the latest SQLTDP 5.1.5.15, I have upgraded > the B/A client to the latest 5.2 version, hope this is not causing the problem. > I have increased the TSM server's commtimeout to 1800 ( 30 minutes) and it does not change a thing. Thanks for your help
Re: Netware 6 & TSM 5.2 Client
Here you go. A search on nss volumes on search.adsm.org will turn this
up rather quickly.
Novell's TID 10065605 and patch NW6SMS1A.EXE are needed. In particular,
you need the following entry in the smsrun.bas file: nlmArray =
Array("SMDR", "TSA600 /cluster=off", "TSAPROXY")in order for TSM to
recognize the clustered volumes.
Rowan O'Donoghue wrote:
>
> Hi all!
>
> I have a customer who has just implemented Netware 6.0 and the TSM 5.2
> client. Everything seems to be ok apart from the fact that there are SAN
> volumes which are assigned to the Netware 6 server (filespace called
> DATA01:) which are not recognised by the TSM client. the SYS: volume is
> being picked up no problem. Even if I try and perform an INC DATA01:\ it
> comes back telling me that the filespace is invalid.
>
> Anyone have the same problem?
>
> All the Netware 5 servers with the TSM 5.1 client are ok - then again, I
> dont have any SAN attached volumes on these servers.
>
> regards,
>
> Rowan O'Donoghue
> Technical Services Manager
> Unitech Systems
> Bracken Business Park
> Bracken Road
> Sandyford Industrial Estate
> Dublin 18.
>
> Tel: + 353 - 1 - 2942300
> Fax: + 353 - 1 - 2942319
> www.unitech-ie.com
--
Jim Kirkman
AIS - Systems
UNC-Chapel Hill
966-5884
SV: Can I create a Node Archive from a full-increment (full backup) in my backup diskpool? <
Hi Ken, You can't make an Archive from a diskpool. Archive are made over the NET. But you can export the Node data from your spare TSM Server to the TSM Server at your HQ. If you want to save data for "Achive" but don't want to make it over the NET you can make a backupset. - Michael -Oprindelig meddelelse- Fra: Ken Sedlacek [mailto:[EMAIL PROTECTED] Sendt: 25. september 2003 20:16 Til: [EMAIL PROTECTED] Emne: Can I create a Node Archive from a full-increment (full backup) in my backup diskpool? <
Re: Can I create a Node Archive from a full-increment (full back up) in my backup diskpool? <
You can make a "backupset". See generate backupset. You can only create an archive from a client so you could restore the data somewhere then archive it. -Original Message- From: Ken Sedlacek [mailto:[EMAIL PROTECTED] Sent: September 25, 2003 1:16 PM To: [EMAIL PROTECTED] Subject: Can I create a Node Archive from a full-increment (full backup) in my backup diskpool? <
Question on GUI display selective backup
Enviro: W2K 5.1.6.3 server W2K 5.1.5.15 client Question: When I do a selective backup via the GUI, where does the activity log for the selective backup go? I am looking at ..\program files\tivoli\tsm\baclient\dsmsched.log , but this is for a scheduled backup? Right?? so, where does the activity log for a selective backup go?? ?? Ken Sedlacek AIX/TSM/UNIX Administrator [EMAIL PROTECTED] IBM Certified Specialist: RS/6000 AIX v4.3 Support IBM Certified Specialist: RS/6000 SP & PSSP 3 Tivoli Certified Consultant - Tivoli Storage Manager v4.1
Re: Can I create a Node Archive from a full-increment (full back up) in my backup diskpool? <
yes, that makes sense. tks for all the answers. Ken Sedlacek AIX/TSM/UNIX Administrator [EMAIL PROTECTED] IBM Certified Specialist: RS/6000 AIX v4.3 Support IBM Certified Specialist: RS/6000 SP & PSSP 3 Tivoli Certified Consultant - Tivoli Storage Manager v4.1 "Rushforth, Tim" <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> 09/25/2003 03:09 PM Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> To [EMAIL PROTECTED] cc Subject Re: Can I create a Node Archive from a full-increment (full back up) in my backup diskpool?
Question on GUI display selective backup: << info I fogot in origional message <
Enviro: W2K 5.1.6.3 server W2K 5.1.5.15 client I am doing subfile backups on this client. Question: When I do a selective backup via the GUI, where does the activity log for the selective backup go? I am looking at ..\program files\tivoli\tsm\baclient\dsmsched.log , but this is for a scheduled backup? Right?? so, where does the activity log for a selective backup go?? ?? Ken Sedlacek AIX/TSM/UNIX Administrator [EMAIL PROTECTED] IBM Certified Specialist: RS/6000 AIX v4.3 Support IBM Certified Specialist: RS/6000 SP & PSSP 3 Tivoli Certified Consultant - Tivoli Storage Manager v4.1
R: POSTSCHEDULECMD failed, but event was successful
Hi Bill, I saw the same behavior on schedules of type=command. I launched a backup script and even if the script exits with a return code of 8 (exit 8) the event is showed as COMPLETED instead of FAILED. The current versions are: TSM Server 5.1.6.0 on AIX 4.3.3 TSM Client 5.1 on AIX 4.3.3 I think that with the version 4 of TSM the event used to be considered FAILED when the launched command exited with a return code of 8. Regards, Mike Angels -Messaggio originale- Da: Bill Boyer [SMTP:[EMAIL PROTECTED] Inviato:giovedi 25 settembre 2003 16.33 A: [EMAIL PROTECTED] Oggetto:POSTSCHEDULECMD failed, but event was successful TSM Client 5.1.6.7 on Windows2000 SP4 TSM Server 5.1.7.1 on AIX 4.3.3 I have coded a PRE and POSTSCHEDULCMD that stops some Oracle services, backups up and then restarts the services. My POSTSCHEDULECMD keeps track of the highest return code and then EXIT %MAXCC%. Testing with this today, my POSTSCHEDULECMD did and EXIT 2, and you see that in the DSMSCHED.LOG file. The problem is that the event itself didn't Fail. Executing Operating System command or script: c:\progra~1\tivoli\tsm\scripts\orastart.cmd 09/24/2003 22:17:10 Finished command. Return code is: 2 09/24/2003 22:17:10 ANS1903W The POSTCHEDULECMD command failed. 09/24/2003 22:17:10 Scheduled event '@166' completed successfully. 09/24/2003 22:17:10 Sending results for scheduled event '@166'. 09/24/2003 22:17:10 Results sent to server for scheduled event '@166'. According to the TSM Client doc: For Windows NT, 2000, XP systems: If the postschedulecmd command does not complete with return code 0, the client will report that the scheduled event completed with return code 8 (unless the scheduled operation encounters a more severe error yielding a higher return code). Why didn't my schedule event finish with Fail?? Anyone seen this behavior? Bill Boyer "Some days you are the bug, some days you are the windshield." - ??
can't see new volume in the volume Inventory list
I just added new scratch tapes to the 3583 library using the following command "checkin libvolume ltolib search=yes status=scratch checklabel=barcode". Tapes checkin went OK with no error but I can't seem to see the new volume in the volume inventory list. Then I try to define one of the volume to offsite_tapepool and still didn't show up in the volume inventory list however it showed up when I used q vol command with the volume status empty rather than scratch or private. Can someone please explain to me why is this happening or give me direction how to fix this. I have read the TSM Administrator's Guide book on this topic but couldn't find any solutions for my problems. Please Help here is the inventory list: Library Name Volume Name Status OwnerLast UseHome Element --- -- -- - LTOLIB 636AENL1 Private Data4,096 LTOLIB 640AENL1 Private Data4,101 LTOLIB 641AENL1 Private Data4,103 LTOLIB 643AENL1 Private Data4,099 LTOLIB 644AENL1 Private Data4,097 LTOLIB 646AENL1 Private Data4,104 LTOLIB 647AENL1 Scratch 4,105 LTOLIB 648AENL1 Scratch 4,102 LTOLIB 649AENL1 Private Data4,107 LTOLIB 650AENL1 Scratch 4,108 LTOLIB 651AENL1 Private Data4,109 LTOLIB 653AENL1 Private Data4,111 LTOLIB CLEANV1 Cleaner 4,098 Here is query volume out put : Volume Name Storage Device EstimatedPct Volume Pool NameClass Name Capacity Util Status (MB) --- -- - - 636AENL1 OFFSITE_TA- LTOCLASS215,573.3 98.9 Filling PEPOOL 640AENL1 ONSITE_POOL LTOCLASS239,003.9 44.0 Full 641AENL1 ONSITE_POOL LTOCLASS229,519.4 40.7 Full 642AENL1 OFFSITE_TA- LTOCLASS257,904.5 59.6 Full PEPOOL 643AENL1 ONSITE_POOL LTOCLASS204,800.0 30.2 Filling 644AENL1 ONSITE_POOL LTOCLASS224,730.6 14.1 Full 645AENL1 OFFSITE_TA- LTOCLASS344,941.30.0 Full PEPOOL 646AENL1 ONSITE_POOL LTOCLASS223,572.0 13.7 Full 649AENL1 ONSITE_POOL LTOCLASS471,261.5 49.4 Full 651AENL1 ONSITE_POOL LTOCLASS201,789.7 13.2 Full 652AENL1 OFFSITE_TA- LTOCLASS293,477.8 90.3 Full PEPOOL 653AENL1 ONSITE_POOL LTOCLASS215,212.0 95.2 Filling 654AENL1 OFFSITE_TA- LTOCLASS300,773.5 87.4 Full PEPOOL 655AENL1 OFFSITE_TA- LTOCLASS 0.00.0 Empty PEPOOL Thank you Desalegne Regional Occupational Health [EMAIL PROTECTED]
Re: R: POSTSCHEDULECMD failed, but event was successful
You are probably seeing APAR IC35203. This is fixed in client version 5.1.6.0 and up. Regards, Andy Andy Raibeck IBM Software Group Tivoli Storage Manager Client Development Internal Notes e-mail: Andrew Raibeck/Tucson/[EMAIL PROTECTED] Internet e-mail: [EMAIL PROTECTED] The only dumb question is the one that goes unasked. The command line is your friend. "Good enough" is the enemy of excellence. Mike Angels <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> 09/25/2003 14:57 Please respond to "ADSM: Dist Stor Manager" To: [EMAIL PROTECTED] cc: Subject:R: POSTSCHEDULECMD failed, but event was successful Hi Bill, I saw the same behavior on schedules of type=command. I launched a backup script and even if the script exits with a return code of 8 (exit 8) the event is showed as COMPLETED instead of FAILED. The current versions are: TSM Server 5.1.6.0 on AIX 4.3.3 TSM Client 5.1 on AIX 4.3.3 I think that with the version 4 of TSM the event used to be considered FAILED when the launched command exited with a return code of 8. Regards, Mike Angels -Messaggio originale- Da: Bill Boyer [SMTP:[EMAIL PROTECTED] Inviato:giovedi 25 settembre 2003 16.33 A: [EMAIL PROTECTED] Oggetto:POSTSCHEDULECMD failed, but event was successful TSM Client 5.1.6.7 on Windows2000 SP4 TSM Server 5.1.7.1 on AIX 4.3.3 I have coded a PRE and POSTSCHEDULCMD that stops some Oracle services, backups up and then restarts the services. My POSTSCHEDULECMD keeps track of the highest return code and then EXIT %MAXCC%. Testing with this today, my POSTSCHEDULECMD did and EXIT 2, and you see that in the DSMSCHED.LOG file. The problem is that the event itself didn't Fail. Executing Operating System command or script: c:\progra~1\tivoli\tsm\scripts\orastart.cmd 09/24/2003 22:17:10 Finished command. Return code is: 2 09/24/2003 22:17:10 ANS1903W The POSTCHEDULECMD command failed. 09/24/2003 22:17:10 Scheduled event '@166' completed successfully. 09/24/2003 22:17:10 Sending results for scheduled event '@166'. 09/24/2003 22:17:10 Results sent to server for scheduled event '@166'. According to the TSM Client doc: For Windows NT, 2000, XP systems: If the postschedulecmd command does not complete with return code 0, the client will report that the scheduled event completed with return code 8 (unless the scheduled operation encounters a more severe error yielding a higher return code). Why didn't my schedule event finish with Fail?? Anyone seen this behavior? Bill Boyer "Some days you are the bug, some days you are the windshield." - ??
Re: POSTSCHEDULECMD failed, but event was successful
The doc you quoted explains the answer. The event is reported as completed (i.e. not failed) with return code 8. If you do a QUERY EVENT with FORMAT=DETAILED, I would expect you to see a status of Complete and a result code of 8. Regards, Andy Andy Raibeck IBM Software Group Tivoli Storage Manager Client Development Internal Notes e-mail: Andrew Raibeck/Tucson/[EMAIL PROTECTED] Internet e-mail: [EMAIL PROTECTED] The only dumb question is the one that goes unasked. The command line is your friend. "Good enough" is the enemy of excellence. Bill Boyer <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> 09/25/2003 07:33 Please respond to "ADSM: Dist Stor Manager" To: [EMAIL PROTECTED] cc: Subject:POSTSCHEDULECMD failed, but event was successful TSM Client 5.1.6.7 on Windows2000 SP4 TSM Server 5.1.7.1 on AIX 4.3.3 I have coded a PRE and POSTSCHEDULCMD that stops some Oracle services, backups up and then restarts the services. My POSTSCHEDULECMD keeps track of the highest return code and then EXIT %MAXCC%. Testing with this today, my POSTSCHEDULECMD did and EXIT 2, and you see that in the DSMSCHED.LOG file. The problem is that the event itself didn't Fail. Executing Operating System command or script: c:\progra~1\tivoli\tsm\scripts\orastart.cmd 09/24/2003 22:17:10 Finished command. Return code is: 2 09/24/2003 22:17:10 ANS1903W The POSTCHEDULECMD command failed. 09/24/2003 22:17:10 Scheduled event '@166' completed successfully. 09/24/2003 22:17:10 Sending results for scheduled event '@166'. 09/24/2003 22:17:10 Results sent to server for scheduled event '@166'. According to the TSM Client doc: For Windows NT, 2000, XP systems: If the postschedulecmd command does not complete with return code 0, the client will report that the scheduled event completed with return code 8 (unless the scheduled operation encounters a more severe error yielding a higher return code). Why didn't my schedule event finish with Fail?? Anyone seen this behavior? Bill Boyer "Some days you are the bug, some days you are the windshield." - ??
