APAR status
Closed as program error.
Error description
It is possible for performance to decrease after upgrading to Tivoli Storage Manager Server 6.3. This is caused by the server enabling the DB2 INTRA_PARALLEL configuration parameter in this new version. Tivoli Storage Manager Versions Affected: 6.3 Customer/L2 Diagnostics: Notable performance decrease after upgrading to 6.3. If they are not at the 6.3 level, this APAR does not apply. Initial Impact: Medium Additional Keywords: Perf, performance, decline, decrease
Local fix
These updates can be done while the server is running and take effect immediately: db2 attach to <TSM server instance> db2 update dbm cfg using MAX_QUERYDEGREE 1 db2 update db cfg for TSMDB1 using DFT_DEGREE 1 db2 terminate - To verify the update did change the updated parameters the following commands can be run. db2 attach to <TSM server instance> db2 get dbm cfg show detail db2 connect to TSMBD1 db2 get db cfg for TSMDB1 show detail After a fixing level is installed with this APAR, use the following instructions to set INTRA_PARALLEL to NO. Note that this should be done with the server halted. If not, the value won't be used until the server is halted and subsequently started. db2 attach to <TSM server instance> db2 update dbm cfg using INTRA_PARALLEL NO db2 terminate
Problem summary
**************************************************************** * USERS AFFECTED: All Tivoli Storage Manager server users. * **************************************************************** * PROBLEM DESCRIPTION: See error description. * **************************************************************** * RECOMMENDATION: Apply fixing level when available. This * * problem is currently projected to be fixed * * in level 6.3.2. * * Note that this is subject to change at the * * discretion of IBM. * **************************************************************** *
Problem conclusion
This problem was fixed. Affected platforms: AIX, HP-UX, Solaris, Linux and Windows.
Temporary fix
Comments
APAR Information
APAR number
IC82940
Reported component name
TSM SERVER
Reported component ID
5698ISMSV
Reported release
63W
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2012-04-27
Closed date
2012-05-14
Last modified date
2012-05-16
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
TSM SERVER
Fixed component ID
5698ISMSV
Applicable component levels
R63A PSY
UP
R63H PSY
UP
R63L PSY
UP
R63S PSY
UP
R63W PSY
UP
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSGSG7","label":"Tivoli Storage Manager"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"63W","Edition":"","Line of Business":{"code":"LOB26","label":"Storage"}}]
Document Information
Modified date:
16 May 2012