Fixes are available
APAR status
Closed as program error.
Error description
Problem Description: Currently, reorganization can be enabled or disabled for all tables and/or their indices. The capability to have reorganization enabled for most tables, but disabled for certain large tables is needed. This need has been specifically observed on very busy servers running deduplication. Some customers have experienced very long time periods to run table reorganizations which prevent reorganization from running on other tables. Other customers have experienced the server halting when the active log becomes full while index reorganization is running. Others have experienced server applications being canceled while reorganization is running to resolve deadlocks (message ANR1880W being issued). IC82352 introduced an INDEX REORG CLEANUP PAGES ALL reorganization on BF_BITFILE_EXTENTS which might cause the server to halt because of the active log becoming full. Disabling reorganization on very large tables will allow reorganization to run on the other tables while the server is operating, prevents server outages from occurring, and prevents server applications from being canceled because of reorganization activity. Tivoli Storage Manager Versions Affected: All 6.X versions of Tivoli Storage Manager server Initial Impact: Medium Additional Keywords: zz63 TSM table index reorganization IC81261 IC82352 IC83725 IC90985 IC91964 ANR1880W
Local fix
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 * * levels 6.3.5 and 7.1.1. 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. These new messages are introduced with this APAR: ANR3496W An invalid value, <option value>, is specified for option <option name>. The reason code is <reason code>. ANR3497W Reorganization is required on table <table name>. The reason code is <reason code>. ANR3498W One-time setting of the server reorganization options is performed. These new server options are introduced with this APAR: DISABLEREORGTABLE, DISABLEREORGINDEX, DISABLEREORGCLEANUPINDEX. See Technote 1452146, section APAR IC95301, for complete information on this APAR: http://www.ibm.com/support/docview.wss?uid=swg21452146
Temporary fix
Comments
APAR Information
APAR number
IC95301
Reported component name
TSM SERVER
Reported component ID
5698ISMSV
Reported release
63A
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2013-08-27
Closed date
2013-12-12
Last modified date
2013-12-12
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
R71A PSY
UP
R71H PSY
UP
R71L PSY
UP
R71S PSY
UP
R71W 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":"63A","Edition":"","Line of Business":{"code":"LOB26","label":"Storage"}}]
Document Information
Modified date:
12 December 2013