PM10551: SPACES DISPLAY KTSPDBDS NOT DISPLAYING ALL INDEX SPACES

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Invoke DB2 SMU
  Select DB2 subsystem to be evaluated
  Select option 4 to view data spaces.
  Not all indexspaces are seen on screen KTSPDBDS.
  
  From the database display, KTSPDBSM, enter S to see dataspaces
  next to a database. Index spaces will be missing from screen
  KTSP1DBD.
  
  To identify the extent of the missing index spaces in the
  display run the following query -
  SELECT 'IX',IX.NAME,PARTITION,IX.TBNAME,NLEVELS,IX.PGSIZE,
  FIRSTKEYCARD,FULLKEYCARD,NLEAF,IX.SPACE,
  IP.CARD,FAROFFPOS,NEAROFFPOS,LEAFDIST,
  'I2',UNIQUERULE,CLUSTERING,CLUSTERED,IX.ERASERULE,
  IX.CLOSERULE,STORTYPE,
  STORNAME,IX.DBNAME,INDEXSPACE,
  IX.CREATOR,VCATNAME,IX.BPOOL,
  PQTY,SQTY,PCTFREE,IX.TBCREATOR,
  'I3',FREEPAGE,IX.COLCOUNT,IX.DBID,
  IX.OBID,ISOBID,IX.CREATEDBY,CLUSTERRATIO,
  IX.INDEXTYPE,TS.TYPE,LIMITKEY,
  'I4',SECQTYI,PIECESIZE,IX.COPY
  FROM   SYSIBM.SYSINDEXES IX,  SYSIBM.SYSINDEXPART IP,
         SYSIBM.SYSTABLES TB, SYSIBM.SYSTABLESPACE TS
  WHERE IX.NAME = IP.IXNAME AND IX.CREATOR = IP.IXCREATOR AND
        IX.TBNAME = TB.NAME AND TB.TSNAME = TS.NAME AND
        IX.TBCREATOR = TB.CREATOR AND TB.DBNAME = TS.DBNAME
        AND (TB.TYPE = 'T' OR TB.TYPE = 'X')
  ;
  
  This query can be found in hilev.SKTSSAMP(KTSEXTnn) where nn is
  the DB2 release, 71, 81, 91. This is the code to identify the
  index spaces.
  
  On the spaces display, KTSPDBDS,
  Set a filter for INDEXSPACES ONLY
  Enter Menu on the command line
  Select Option 4 to PRNT
  Enter a SYSOUT class that goes to a held JES Q
  This should send the entire display list out under your userid
  on the JES spool
  Using a command like XDC under SDSF send the sysout to a dataset
  
  Comparing the results of the SQL and the display of index spaces
  will give some idea what data is missing from the display
  

Local fix

• Apply PTF when available
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All users of SMU.                            *
  ****************************************************************
  * PROBLEM DESCRIPTION: KTSPDBDS panel not displaying           *
  *                      index spaces.                           *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Incorrect index space list processing in KTCLSBLP
  caused missing spaces in KTSPDBDS panel.
  

Problem conclusion

• Code changed to fix this problem.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UK57092

Modules/Macros

• KTCLSBLP
  

Fix information

• Fixed component name

  DB2 STORAGE MGM

• Fixed component ID

  5655SMU00

Applicable component levels

• R110 PSY UK57092

     UP10/05/22 P F005

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.