ADSM-L

Re: DB2 high speed SP switch backups dead slow.

2003-09-10 16:48:47
Subject: Re: DB2 high speed SP switch backups dead slow.
From: Dave Canan <ddcanan AT ATTGLOBAL DOT NET>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Wed, 10 Sep 2003 13:48:54 -0700
Also, please reply with the following information:

        dsm.sys contents
        TSM software levels.
        Which type of switch? Is it the one that is 150MB/sec?
        What is your TSM server machine type?

At 02:47 PM 9/10/2003 -0500, you wrote:
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>>

Dave Canan
TSM Performance
IBM Advanced Technical Support
ddcanan AT us.ibm DOT com