PK44829: DEFECT FIXES

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Various defects as described
  
  Abend during extract
   PSW=078D2000 000180FC
       (Running in PRIMARY, key 8, AMODE 24, DAT ON)
       DISABLED FOR PER
      ASID(X'003E') 0180FC. KTSXTRCT+0103D4 IN PRIVATE
      ASID(X'003E') 0180FC. AREA(Subpool251Key08)+0110FC IN
  PRIVATE
     ASCB62 at FB9A00, JOB(SMU), for the home ASID
     ASXB62 at 6FDCF8 and TCB62E at 6C9B08 for the home ASID
     HOME ASID: 003E PRIMARY ASID: 003E SECONDARY ASID: 003E
  
  ===============================================================
  When generating a MOVE job using the M select on an object the
  IDCAMS control statement that are generated are incorrect. The
  DELETE CLUSTER and the ALTER that is generated includes the data
  portion name hilev.DSNDBD.** rather than cluster name
  hilev.DSNDBC
  ================================================================
  

Local fix

• For 0C4 in extract
  Run the following query - this will determine if there indexes
  on materialized tables
  SELECT 'IX',IX.NAME,PARTITION,IX.TBNAME
  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 = 'M' ;
  
  If the list has any rows returned
  1) make a backup copy of hilev.SKTSSAMP(KTSEXT81)  -
  for the appropriate extract
  
  2) hile.SKTSSAMP(KTSEXT81)
  3) find the select that starts like this (about line 22
  probably)
  SELECT 'IX',IX.NAME,PARTITION,IX.TBNAME,NLEVELS,IX.PGSIZE,
  4) add the following line
  AND (TB.TYPE = 'T' OR TB.TYPE = 'X')
  as the last line of the WHERE clause so the last few lines look
  like
  this
  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')
  5) run the extract
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All users of DB2 Storage Management Utility  *
  ****************************************************************
  * PROBLEM DESCRIPTION: Correction of various defects:          *
  *                      1.  ktshexd2 config help system pds has *
  *                          extraneous letters                  *
  *                      2.  ktshexdb,needs a  'more:>',there is *
  *                          another panel, ktshexd2             *
  *                      3.  ktshexdb-config info not describing *
  *                          what a pds is                       *
  *                      4.  ktshops1 config exits,match exit    *
  *                          names with help panel               *
  *                      5.  ktshops2 config max reports         *
  *                          help-max sums not used              *
  *                      6.  ktshopu4 skip maps help-delete user *
  *                          opts line                           *
  *                      7.  help panel 'ktshbutd' is            *
  *                          truncated                           *
  *                      8.  ktspsgsp - invalid *error in vol    *
  *                          ser for dsnc910                     *
  *                      9.  ktspdsvl - invalid space map/scan   *
  *                          for not found                       *
  *                      10. sqlcode - 104 on drop index widow   *
  *                          process                             *
  *                      11. in a build cannot find ktszstat in  *
  *                          system dataset                      *
  *                      12. typo in extract output: sysstogrup  *
  *                      13. intermittent abend 0c3 in ktclsblp  *
  *                          b/c ix on mqt cannot find tb        *
  *                      14. customization help uses taylor      *
  *                          instead of tailor                   *
  *                      15. missing help for volume candidate   *
  *                          list                                *
  *                      16. missing the last sg value in panel  *
  *                          display                             *
  *                      17. move has 2 alter statements for the *
  *                          same data set name                  *
  *                      18. remove move from batch              *
  *                      19. ktspvldb - volume list shows *error *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Correction of various defects.
  

Problem conclusion

• Various defects were corrected. Apply the PTF.
  

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:

  UK28954

Modules/Macros

• KTCEXTWT KTCHOPTS KTCIHTL4 KTCIHT08 KTCIH012
  KTCIH016 KTCIH017 KTCIH018 KTCIH12W KTCIPTL4 KTCLSBLE KTCLSBLP
  KTCRH018 KTSBLD2  KTSDB262 KTSDSFMT KTSEXT71 KTSEXT81 KTSEXT91
  KTSHA0D9 KTSHBPMU KTSHBUTD KTSHEXDB KTSHEXD2 KTSHMENU KTSHMNH7
  KTSHNAME KTSHOPS1 KTSHOPS2 KTSHOPS3 KTSHOPS4 KTSHOPS7 KTSHOPS8
  KTSHOPT1 KTSHOPU4 KTSHSIZE KTSHUPFL KTSHVCL  KTSIHTL1 KTSMVGDS
  KTSP#PMU KTSPONUT KTSWSWCH
  

Fix information

• Fixed component name

  DB2 STORAGE MGM

• Fixed component ID

  5655SMU00

Applicable component levels

• R110 PSY UK28954

     UP07/09/21 P F709

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.