APAR status
Closed as program error.
Error description
The Tivoli Storage Manager Server does not currently take into consideration the number of empty leaf pages and/or deleted record ids when determining if reorg is required for a table index. This can affect the performance of the TSM Server as the amount of time required to scan the table indexes is increased as a result of the deleted/empty records. Platforms affected: All TSM 6.x Servers Customer/L2 Diagnostics: The following DB2 'reorgchk' command can be issued to determine if a reorg of the table indexes is required: db2 reorgchk current statistics on table all Affected users will see from this output that the reorg of a table index is required due to the results for formula F7 (deleted record ids) and/or formula F8 (empty leaf pages) being outside of the specified boundaries. Additional Keywords: reorganization reorgck db2reorgchk indices
Local fix
Contact support for assistance in performing required reorg/runstats operations against the affected table index.
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 levels 6.2.5 and 6.3.3. 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. If the output of Formula 7 or Formula 8 is true when the DB2 REORGCHK command is run on the BF_BITFILE_EXTENTS table, this APAR initiates an index reorganization of type CLEANUP ONLY ALL for the table. The settings of the ALLOWREORGINDEX, REORGBEGINTIME, and REORGDURATION server options are not considered when starting this type of reorganization.
Temporary fix
Comments
APAR Information
APAR number
IC82352
Reported component name
TSM SERVER
Reported component ID
5698ISMSV
Reported release
62H
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2012-03-29
Closed date
2013-09-24
Last modified date
2013-09-24
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
R62A PSY
UP
R62H PSY
UP
R62L PSY
UP
R62S PSY
UP
R62W PSY
UP
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":"62H","Edition":"","Line of Business":{"code":"LOB26","label":"Storage"}}]
Document Information
Modified date:
24 September 2013