ADSM-L

Re: DB2 high speed SP switch backups dead slow.

2003-09-11 14:35:58
Subject: Re: DB2 high speed SP switch backups dead slow.
From: Gianluca Mariani1 <gianluca_mariani AT IT.IBM DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Thu, 11 Sep 2003 20:35:22 +0200
try:

on TSM
compression    no
TCPwindow     128 or 256
TCPbuffsize   32

on aix try to enable tcp_nodelayack. this is APAR IY31983.


Cordiali saluti
Gianluca Mariani
Tivoli TSM Global Response Team, Roma
Via Sciangai 53, Roma
 phones : +39(0)659664598
                   +393351270554 (mobile)
gianluca_mariani AT it.ibm DOT com
----------------------------------------------------------------------------------------------------

The Hitch Hiker's Guide to the Galaxy says  of the Sirius Cybernetics
Corporation product that "it is very easy to be blinded to the essential
uselessness of  them by the sense of achievement you get from getting them
to work at all. In other words ? and this is the rock solid principle  on
which the  whole  of the Corporation's Galaxy-wide success is founded
-their fundamental design flaws are  completely  hidden  by  their
superficial design flaws"...


                                                                                
                                                       
                      Muthyam Reddy                                             
                                                       
                      <MREDDY AT JOY DOT COM>         To:       ADSM-L AT 
VM.MARIST DOT EDU                                                          
                      Sent by: "ADSM:          cc:                              
                                                       
                      Dist Stor                Subject:  Re: DB2 high speed SP 
switch backups dead slow.                               
                      Manager"                                                  
                                                       
                      <[email protected]                                         
                                                       
                      .EDU>                                                     
                                                       
                                                                                
                                                       
                                                                                
                                                       
                      11/09/2003 17:13                                          
                                                       
                      Please respond to                                         
                                                       
                      "ADSM: Dist Stor                                          
                                                       
                      Manager"                                                  
                                                       
                                                                                
                                                       




** 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>>