Hi........e-mail from IBM Matt Powell TSM L2 Support I have AIX support, TSM development and TSM ATS Performance teams looking at this problem. The TSM teams are also responsible for DB2.
The only change to your system was the OS upgrade. The TSM ATS Performance team has had other customers report this same problem and they resolved it by down leveling AIX to level 6.1.6.x. I'm currently working with Mike Long (AIX support) to get to the bottom of this. We have tested TSM with AIX 7.1 and it also was shower for the DB backup performance. I have provided this information to Mike Long. You can test a higher AIX patch level other then AIX 7.1 and if you get good DB backup speeds, please let us know. Best regards, Matt Powell TSM L2 Support _____________________________________________ From: Lamb, Charles P. Sent: Thursday, March 01, 2012 9:52 AM To: '[email protected]' Cc: Hartman, Thomas J. Subject: Slow TSM DB Backup Hi......... We are experiencing slow TSM DB backup process on both of our TSM systems using AIX V6.1.7.x, TSM V6.2.3.100, Atape v12.4.1.0. The issues began immediately after we upgraded from AIX v5.3.12.3 to AIX v6.1.7.x. We have created a performance PMR#53387,379,000 with TSM support. With 100GB data in a DB2 database, we are seeing 30 to 60sec waits between .1/.2GB database transfers to IBM LTO4 tape drives via TSM q se screen. It is taking a very long time to complete a TSM DB backup. Before the AIX upgrade, the full DB backup took about 10 minutes; now we are seeing backups of hours in length. Anybody having these types of issues??
