PH42437: DEC 2021 ENH PTF

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• This PTF implements the following enhancements:
  
  1. REBUILD INDEX Utility: Implement support for the following
  keywords:
  
  FREQVAL, COUNT keyword
  
  2. REORG TABLESPACE Utility: Implement support for the following
  keywords:
  
    a. FREQVAL, COUNT keyword
    b. SORTCLUSTER (Db2 V11 keyword)
    c. ICLIMIT_DASD(FL 500)
    d. ICLIMIT_TAPE(FL 500)
  
  3. REORG INDEX Utility: Implement support for the following
  keywords:
  
    a. FREQVAL, COUNT keyword
    b. NOSYSUT1(FL 100)
    c. PARALLEL(FL 100)
  
  4. Support for REORG TABLESPACE ?labeled-duration-expression?
  field for the INITCCDS SEARCHTIME option.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: ALL USERS                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: This PTF implements the following       *
  *                      enhancements:                           *
  *                                                              *
  *                      1. REBUILD INDEX Utility: Implement     *
  *                         support for the following keywords:  *
  *                                                              *
  *                           FREQVAL, COUNT keyword             *
  *                                                              *
  *                      2. REORG TABLESPACE Utility: Implement  *
  *                         support for the following keywords:  *
  *                                                              *
  *                         a.  FREQVAL, COUNT keyword           *
  *                         b.  SORTCLUSTER (Db2 V11 keyword)    *
  *                         c.  ICLIMIT_DASD(FL 500)             *
  *                         d.  ICLIMIT_TAPE(FL 500)             *
  *                                                              *
  *                      3. REORG INDEX Utility: Implement       *
  *                         support for the following keywords:  *
  *                                                              *
  *                         a.  FREQVAL, COUNT keyword           *
  *                         b.  NOSYSUT1(FL 100)                 *
  *                         c.  PARALLEL(FL 100)                 *
  *                                                              *
  *                      4. Support for REORG TABLESPACE         *
  *                         "labeled-duration-expression" field  *
  *                         for the INITCCDS SEARCHTIME option.  *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF                                *
  ****************************************************************
  .
  

Problem conclusion

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:

  UI78708

Modules/Macros

• HAA#ACTR HAA#ADMJ HAA#AGEN HAA#AOBP HAA#AOIM HAA#ARCH HAA#AUTO
  HAA#AUXR HAA#BCLR HAA#BCTC HAA#BIND HAA#BPRI HAA#BRS  HAA#BSQL
  HAA#BST7 HAA#BST8 HAA#BSTS HAA#BTMP HAA#BULD HAA#CDCL HAA#CL
  HAA#CL64 HAA#CL7  HAA#CL8  HAA#CPM  HAA#CQMP HAA#DB2V HAA#DCMD
  HAA#DISP HAA#DMAL HAA#DMSQ HAA#DXCI HAA#DXCL HAA#DXCT HAA#DXDB
  HAA#DXDI HAA#DXDN HAA#DXDS HAA#DXDT HAA#DXES HAA#DXEV HAA#DXI2
  HAA#DXIN HAA#DXIS HAA#DXQD HAA#DXQN HAA#DXQS HAA#DXSG HAA#DXSI
  HAA#DXST HAA#DXSV HAA#DXT2 HAA#DXTS HAA#DXVD HAA#ECDS HAA#ECIC
  HAA#EDAY HAA#EDSP HAA#EIDA HAA#EMCS HAA#EMIC HAA#EMID HAA#EOTR
  HAA#EPRI HAA#ERSH HAA#ERSI HAA#ERSU HAA#ERT8 HAA#ERT9 HAA#ERTA
  HAA#ERTI HAA#ESCP HAA#ESTI HAA#ETGI HAA#EVSP HAA#EXCS HAA#EXUX
  HAA#HIST HAA#HPCD HAA#HPSC HAA#ICP7 HAA#ICP8 HAA#ICPO HAA#ILOB
  HAA#IOPF HAA#IX   HAA#IX10 HAA#IX12 HAA#IX7  HAA#IX8  HAA#IX9
  HAA#IXN8 HAA#IXP8 HAA#IXP9 HAA#IXPT HAA#JPRI HAA#LDEP HAA#LOB7
  HAA#LOB8 HAA#LOBC HAA#LPIO HAA#LRPT HAA#MAIN HAA#MPRI HAA#NTFB
  HAA#NTFE HAA#NTFI HAA#NTFJ HAA#NTFM HAA#NTFS HAA#NTFU HAA#OBEX
  HAA#OPCL HAA#OPRI HAA#OPVD HAA#OUT2 HAA#PDEP HAA#PITC HAA#PITS
  HAA#PLOG HAA#POST HAA#PRE  HAA#PRF5 HAA#PRSE HAA#RALR HAA#RCFS
  HAA#RH   HAA#RH10 HAA#RI   HAA#RIO  HAA#RIV7 HAA#RIV8 HAA#RIX
  HAA#RM24 HAA#SCHD HAA#SCPY HAA#SETP HAA#SETR HAA#SKCL HAA#SQL3
  HAA#SQLE HAA#SYMR HAA#TABL HAA#TB   HAA#TB7  HAA#TB8  HAA#TBPT
  HAA#TP   HAA#TP10 HAA#TS   HAA#TS10 HAA#TS12 HAA#TS7  HAA#TS8
  HAA#TS9  HAA#TSS  HAA#TSSA HAA#UOPC HAA#UPRI HAA#URDT HAA#UTED
  HAA#UTLL HAA#UTOB HAA#UTOP HAA#VERT HAA#VMTB HAA#VSAM HAA#XMLC
  HAA#YARC HAA#YCAL HAA#YCTL HAA#YDEL HAA$ABKP HAA$ACES HAA$ACTR
  HAA$ADM1 HAA$ADM2 HAA$ADM4 HAA$ADM5 HAA$ADM6 HAA$ADM7 HAA$ADMD
  HAA$ADMN HAA$ADMS HAA$ADMU HAA$ADMW HAA$ADRV HAA$ADSD HAA$ALLC
  HAA$ALRG HAA$ALRO HAA$ALRP HAA$ALRT HAA$ANST HAA$AOIM HAA$AOSP
  HAA$APAR HAA$APFT HAA$APRD HAA$ARST HAA$ASIM HAA$ASMU HAA$ASTK
  HAA$ATRH HAA$BCHJ HAA$BCPY HAA$BDSN HAA$BGDG HAA$BJBC HAA$BJBN
  HAA$BMSD HAA$BMSG HAA$BPRD HAA$BRST HAA$BSAU HAA$BSHU HAA$BSUU
  HAA$BULD HAA$BULJ HAA$BUT2 HAA$BUTA HAA$BUTB HAA$BUTC HAA$BUTD
  HAA$BUTE HAA$BUTG HAA$BUTH HAA$BUTI HAA$BUTJ HAA$BUTK HAA$BUTL
  HAA$BUTM HAA$BUTP HAA$BUTQ HAA$BUTR HAA$BUTS HAA$BUTT HAA$BUTU
  HAA$BUTV HAA$BUTW HAA$BUTX HAA$BUTY HAA$BUTZ HAA$CALL HAA$CHAR
  

Fix information

• Fixed component name

  DB2 AUTOMATION

• Fixed component ID

  5697G6300

Applicable component levels

• R430 PSY UI78708

     UP21/12/24 P F112

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.