We used TSM to back up a 100+ gig Windows database to TSM/390 in less than two hours. The -50 is probably because TSM is rejecting the attempt to start two simultaneous sessions.
Talk to your TSM guys. We made our own TSM management class and opened 4 sessions. The TSM class was routed straight to mainframe tapes so we were mounting four tapes at the same time. Skipping DASD on 390 was a TSM support preference. Also, use more buffers on your backup command, all you can. Increasing the TCP Window size (ideally 250-350K) may yield you a performance boost as well. It is a dsm.opt option as well as an IP stack option. Good luck, Kelly Kilhoffer Senior DBA Country Insurance and Financial Services -----Original Message----- From: Farah Shire [mailto:[EMAIL PROTECTED] Sent: Monday, September 29, 2003 9:56 AM To: [EMAIL PROTECTED] Subject: [DB2EUG] Error on backup to TSM Hello; I have a database that's around 50 Gig. I use this command to run my backup. db2 -v backup database proddb online use adsm without prompting . It takes 5 hours to complete.... I spoke to TSM people and asked if there's a way they can help us to complete this backup at less then 5 hours. Normally it used to take 2 hours. They are looking into it. So, in my end, I try to change the backup commands to see if I can improve the backup process... I did something like this: backup database proddb online use adsm open 2 sessions with 4 buffers without prompting. After a while I'm getting this error: SQL2025N An I/O error "-50" occurred on media "TSM". "-50" accourding to API Return code it means: -050 E DSM_RC_TCPIP_FAILURE Explanation: An attempt to connect to the server using TCP/IP communications failed. This error can occur if the LAN connection went down or if your system administrator canceled a backup operation. System Action: Session rejected. Processing stopped. User Response: Retry the operation, or wait until the server comes back up and retry the operation. If the problem continues, see your system administrator for further help. But If i don't say "open 2 sessions with 4 buffers" it will run but takes 5 hours. Any help. Thank you. Farah Shire Database Administration - IBM Global Services [EMAIL PROTECTED] (704) 594-8241 or T/L 794-8241 Pager 1-800-759-8352 PIN 1875048# (NONE OF US IS GOOD AS ALL OF US!!!) - ::: When replying to the list, please use 'Reply-All' and make sure ::: a copy goes to the list ([EMAIL PROTECTED]). *** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] *** For more information, check http://www.db2eug.uni.cc - ::: When replying to the list, please use 'Reply-All' and make sure ::: a copy goes to the list ([EMAIL PROTECTED]). *** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] *** For more information, check http://www.db2eug.uni.cc
