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
