I'm not an expert with TSM but have used it here for 3 years.
We have a 130 Gig DB that compresses down to about a 60 Gig backup.
It takes about 2 hours to backup or restore the 60 Gig files.
1. We use the PARALLELISM 8 parm. This allows more than 1 tablespace
to be backed up at a time.
2. Our TSM has enough space on disk to handle our 60 Gig backup. When
the backup runs, it writes the DB2 backup to disk, then TSM writes it
to
tape at later time. I wonder if you have enough disk space to hold the
backup and it's trying to write to tape while you wait??
3. We also use the WITHOUT ROLLING FORWARD command. You may
or may not want to use this based on using the ONLINE backup.
4. What kind of activity do you have against the DB while the ONLINE
backup is performing? Can you do an OFFLINE?
Doug Kestner, DBA
Dept Human Services
State of Illinois
>>> Farah Shire <[EMAIL PROTECTED]> 09/29/03 09:55AM >>>
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
