Hi all,
Re: DB2 EE (v6.1.0.31) on AIX 4.3.3 (and TSM 4.1.2)
Any suggestions on how to speed up our DB2 backups using TSM?
We are able to achieve throughput of 70 Mb/sec backing up a single
node DB2 database on AIX to 4 tapes directly. They are in a robot
which has 2 x 40Mb/sec scsi adapters.
However, when we revert the DB2 backup to 'USE ADSM OPEN 4 SESSIONS'
(our normal mode of operation) instead of the 4 tape devices directly,
we can only get about 40 Mb/sec.
The machine has 3 CPUs. We have TSM configured to use tcp/ip as IBM
support suggested (even though the tape drives are on this machine)
(and it is faster for us than shared memory).
Enclosed below> Topas snapshot of typical activity during the backup
(it is there twice, the first time with a shorter line length which
will hopefully not get mangled by the line wrappers).
1. Kernel mode, I understand, means it is running code in the OS
(such as file opens, etc).
2. On the 'local adapter' 40,000 Kb in and out, and 31,000 packets in
and out means an average packet size of about 1300 bytes.
3. dsmserv is the main TSM task. There is one dsmtca process for each
backup session.
(truncated)
Topas Monitor for host: production
Tue Jul 24 14:33:48 2001 Interval: 2
Kernel 64.8 |################## |
User 29.0 |######## |
Wait 3.5 |# |
Idle 2.6 |# |
Interf KBPS I-Pack O-Pack KB-In KB-Out
lo0 81792 31104 31081 40904 40887
en0 13.5 7.0 10.0 0.3 13.2
Disk Busy% KBPS TPS KB-Read KB-Writ
hdisk3 62.5 14480 120.5 14480 0
hdisk5 60.0 14436 118.0 14436 0
hdisk4 17.0 5056.0 40.0 5056.0 0.0
hdisk2 17.0 5440.1 44.0 5440.1 0.0
hdisk0 0.0 0.0 0.0 0.0 0.0
dsmserv (34404)122.4% PgSp:27.1mb root
dsmtca (51866) 31.0% PgSp: 0.7mb dbinstp
dsmtca (60026) 29.0% PgSp: 0.7mb dbinstp
dsmtca (32702) 27.0% PgSp: 0.7mb dbinstp
dsmtca (38800) 25.5% PgSp: 0.7mb dbinstp
(full copy)
Topas Monitor for host: production EVENTS/QUEUES
FILE/TTY
Tue Jul 24 14:33:48 2001 Interval: 2 Cswitch 8018
Readch 80380424
Syscall 9178
Writech40354816
Kernel 64.8 |################## | Reads 3706 Rawin
0
User 29.0 |######## | Writes 1232
Ttyout 275
Wait 3.5 |# | Forks 0 Igets
0
Idle 2.6 |# | Execs 0 Namei
0
Runqueue 6.0
Dirblk 0
Interf KBPS I-Pack O-Pack KB-In KB-Out Waitqueue 2.0
lo0 81792 31104 31081 40904 40887
en0 13.5 7.0 10.0 0.3 13.2 PAGING
MEMORY
Faults 0
Real,MB 2047
Disk Busy% KBPS TPS KB-Read KB-Writ Steals 0 %
Comp 63.4
hdisk3 62.5 14480 120.5 14480 0 PgspIn 0 %
Noncomp 37.5
hdisk5 60.0 14436 118.0 14436 0 PgspOut 0 %
Client 0.5
hdisk4 17.0 5056.0 40.0 5056.0 0.0 PageIn 0
hdisk2 17.0 5440.1 44.0 5440.1 0.0 PageOut 0
PAGING SPACE
hdisk0 0.0 0.0 0.0 0.0 0.0 Sios 0
Size,MB 4032
%
Used 13.3
dsmserv (34404)122.4% PgSp:27.1mb root %
Free 86.6
dsmtca (51866) 31.0% PgSp: 0.7mb dbinstp
dsmtca (60026) 29.0% PgSp: 0.7mb dbinstp
dsmtca (32702) 27.0% PgSp: 0.7mb dbinstp Press "h" for help
screen.
dsmtca (38800) 25.5% PgSp: 0.7mb dbinstp Press "q" to quit
program.
Thanks and Regards,
Bruce
=====
To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
