Re: DB2 high speed SP switch backups dead slow.

** High Priority **

 thanks a lot for quick responce.

we have
AIX:4.3.3.0
PSSP version:3.1.1.0
OS kernel:64bit in all SP nodes 
TSM Tapedrives:IBM 3590 Tape Drive and Medium Changer.

I have set css0 spoolsize,rpoolsize to 16777216 in both client and server.
TSM server type:S80, 7017
SP switch css0 type:SP Switch Communications Adapter (Type 6-F)
TSM software level:5.1.5.0 in both client and server.
all out nodes are hoocked to SHARK disk storage.those SSA drives.

dsm.sys parametrs at client.
    
        tcpnodelay      yes
        compression     yes
        LARGECOMMBUFFERS NO
 TCPwindow     2048
        TCPbuffsize   256 
        TCPNodelay    yes 
PASSWORDACCESS     generate
   resourceutilization  8

thanks and regards
muthyam



>>> "Miles Purdy" <PURDYM AT fipd.gc DOT ca> 09/10/03 03:47PM >>>
That seems terribly slow. 430 GB in 14 hours is only 8.7 MB/s aggregate 
throughput. Over four streams that's only 2 MB/s/stream. It has been my 
experience that the source hdisks are usually the bottleneck.

There are only two tunables for the switch adapter, rpoolsize and spoolsize.
These can be changed, for example:
chdev -l css0 -a spoolsize=14680064
chdev -l css0 -a rpoolsize=16777216

A couple of things that come to mind:
 - are you mixing machines with 32 and 64 bit kernels on the same SP Switch?
 - what version of AIX are you running? What version of PSSP? What tape drives 
do you have?
 - what are your vmtune settings?
 - where is the bottleneck?
   - is the switch performing well?
   - check the source disks
   - check the VMM




>>> MREDDY AT JOY DOT COM 10-Sep-03 2:18:05 PM >>>
** High Priority **

Hi TSMers,
I hope someone got experiance on same before .

This is problem about db2(7.1) backups on high speed switch to TSM .Present we 
are taking 430Gb of data to tsm which is taking 14 hrs to finish.recently I 
have changed couple of paramters on 'css' and 'no' to improve performance based 
on IBM docs.Still my backups takes same time.
no doubt I missed some parts on TSM/AIX/db2  to lubricate.
Please can any one dump some ideas to fix this this and how long its taking in 
ur environment same setup.
We are using four session on db2(7.1) and copying to tape pools directly.


please send ur back times with same environments.

please send me some tips to make my backups fast.

please write if wants information.

thanks and regards
muthyam







++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
This electronic mail transmission contains information from Joy Mining Machinery
which is confidential, and is intended only for the use of the proper addressee.
If you are not the intended recipient, please notify us immediately at the 
return
address on this transmission, or by telephone at (724) 779-4500, and delete
this message and any attachments from your system.  Unauthorized use, copying,
disclosing, distributing, or taking any action in reliance on the contents of
this transmission is strictly prohibited and may be unlawful.
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
<<privacy>>