Direct links to fixes
IBM Spectrum Control 5.2.11 - Windows Server
IBM Spectrum Control 5.2.11 - Linux Server
IBM Spectrum Control 5.2.11 - AIX Server
IBM Spectrum Control 5.2.11 - Agent
IBM Spectrum Control V5.2.11 (August 2016)
IBM Spectrum Control V5.2.12 (November 2016)
IBM Spectrum Control V5.2.13 (March 2017)
IBM Spectrum Control V5.2.14 (May 2017)
IBM Spectrum Control V5.2.15 (August 2017)
IBM Spectrum Control V5.2.15.2 (November 2017)
IBM Spectrum Control V5.2.16 (March 2018)
IBM Spectrum Control V5.2.17 (May 2018)
APAR status
Closed as program error.
Error description
T_RES_MULTIPATH_DEVICE should have a primary key/index defined - without them, operations such as reorg, runstats commands are unable to gather table statistics for optimization actions, etc. RECREATE STEPS: N/A ________________________________________________________________ DB2 Version used for Server: N/A The defect is against component: 5608TPC00 Server/Manager build/release (TPC): 5.2.8 ___________________________________________________ Problem as described by customer: Questions about tables without primary key Initial customer impact (low/med/high): med
Local fix
Apply fixing PTF when available. Manual table update syntax available from support upon request
Problem summary
**************************************************************** * USERS AFFECTED: * * IBM Spectrum Control and TPC 5.2.x sers who added many SRAs * **************************************************************** * PROBLEM DESCRIPTION: * * L3 Panel showing Server Detail -> Data Path might load a bit * * slow if many servers are added in TPC * **************************************************************** * RECOMMENDATION: * * Create the 2 indexes manually in a db2 command window: * * CREATE INDEX T_RES_MULTIPATH_DEVICE_X1 ON * * T_RES_MULTIPATH_DEVICE (MULTIPATH_DEVICE_ID ASC, * * HOST_APPLICATION_ID ASC, NAME ASC) ALLOW REVERSE SCANS * * CREATE INDEX T_RES_MULTIPATH_DEVICE_X2 ON * * T_RES_MULTIPATH_DEVICE (MULTIPATH_DEVICE_ID ASC, * * HOST_APPLICATION_ID ASC, PATH_SELECTION_POLICY ASC) ALLOW * * REVERSE SCANS * * * * OR upgrade to 5.2.11 when available. * ****************************************************************
Problem conclusion
The fix is to recreat the missing indexes and is targeted for the following maintenance package: | refresh pack | 5.2-TIV-TPC-RP0011 - target August 2016 Fixed in IBM Spectrum Control 5.2.11. http://www.ibm.com/support/docview.wss?&uid=swg21320822 The target dates for future refresh packs do not represent a formal commitment by IBM. The dates are subject to change without notice.
Temporary fix
Comments
APAR Information
APAR number
IT13971
Reported component name
TPC
Reported component ID
5608TPC00
Reported release
528
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2016-02-24
Closed date
2016-05-18
Last modified date
2016-05-18
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
DB
Fix information
Fixed component name
TPC
Fixed component ID
5608TPC00
Applicable component levels
R528 PSY
UP
R529 PSY
UP
R520 PSY
UP
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SS5R93","label":"IBM Spectrum Control"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"528","Edition":"","Line of Business":{"code":"LOB26","label":"Storage"}}]
Document Information
Modified date:
22 February 2022