Farah
Some guidelines to follow are:
1) buffersize should be a multiple of the largest extent size +1
2) The number of buffers should be at least two times the number of
sessions you have
3) The parallelism should be at least equal to the # of session but less
than the number of tablespaces being backed up
Right now your bottleneck is the single tape drive. Have you considered
writing to a disk storage pool and then have it migrated off to tape?
For you scenario I would use parallelism 2, # buffers 4 and either 1025 or
2049 buffersize.
Hope this helps.
_____________________________________________
Dale M. McInnis IBM Toronto Lab
Senior Technical Manager,
DB2 / LUW Backup, Data Protection and Recovery
Email: [EMAIL PROTECTED]
Phone: (905) 413-2397, Fax: (905) 413-4849, T/L: 969-2397
Farah Shire
<[EMAIL PROTECTED]
> To
Dale McInnis/Toronto/[EMAIL PROTECTED]
09/29/2003 01:14 cc
PM [EMAIL PROTECTED],
[EMAIL PROTECTED]
Subject
Re: [DB2EUG] Error on backup to TSM
Dale;
it goes directly to a tape. According to TSM person, they said multi
backups are going on at the same time, is there a way I can increase the
over all backup performance or speed up. Or a way I can Priorities my
backup?
Thank you.
P.S: Since it goes to a tape and they said the physical tape heads is one,
I can't open more sessions. That's why I was getting -50
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!!!)
Dale McInnis
<[EMAIL PROTECTED] To: Farah
Shire/Charlotte/[EMAIL PROTECTED]
com> cc:
[EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: Re: [DB2EUG] Error
on backup to TSM
09/29/2003 11:26
AM
Are you backing up directly to a tape or a disk storage pool?
If you are going to a tape pool do not start more sessions than you have
physical tape heads.
Check the TSM Server's activity log to see why the -50 was returned to the
client, I suspect that the idletimeout parm came into affect and terminated
the session. I would recommend that you increase the COMMTIMEOUT and
IDLETIMEOUT values to something like 6000
_____________________________________________
Dale M. McInnis IBM Toronto Lab
Senior Technical Manager,
DB2 / LUW Backup, Data Protection and Recovery
Email: [EMAIL PROTECTED]
Phone: (905) 413-2397, Fax: (905) 413-4849, T/L: 969-2397
Farah Shire
<[EMAIL PROTECTED]
> To
Sent by: [EMAIL PROTECTED]
[EMAIL PROTECTED] cc
ash.org
Subject
[DB2EUG] Error on backup to TSM
09/29/2003 10:55
AM
Please respond to
Farah Shire
<[EMAIL PROTECTED]
>
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
