IBM Support

PH43895: Provide Phase II Support for Db2 V13

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as new function.

Error description

  • This APAR implements the following re: support for Db2 V13:
    
    a.  SHAADENU - provide support for Db2 V13 on TCz panel CCQPDB2
        - remove support for Db2 10 (remove value '101')
        - add support for Db2 v13 (add value '131')
    
    b.  Add new dialog to interface with the new Db2 V13
        SYSIBM.SYSUTILITIES catalog table.
        Customers can use this new dialog to display utility history
        runtime information for Db2 utilities via various filters.
        In addition, the new dialog provides the ability to delete
        rows from the new SYSIBM.SYSUTILITIES catalog table.
    
    c.  Add new Best Practice profile HAAUSER.REORG DYXRTSTS AND
        DYXRTHTS
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All Users                                    *
    ****************************************************************
    * PROBLEM DESCRIPTION: This APAR implements the following re:  *
    *                      support for Db2 V13:                    *
    *                                                              *
    *                      a.  SHAADENU, TCz panel CCQPDB2, field  *
    *                          Level Number:                       *
    *                                                              *
    *                           - remove support for Db2 V10; a    *
    *                             value of "101 has been removed   *
    *                           - add support for Db2 V13; a value *
    *                             of "131 has been added           *
    *                                                              *
    *                      b.  Add new dialog to interface with    *
    *                          the new Db2 V13 SYSIBM.SYSUTILITIES *
    *                          catalog table.  Customers can use   *
    *                          this new dialog to display utility  *
    *                          history runtime information for     *
    *                          Db2 utilities via various filters.  *
    *                                                              *
    *                          In addition, the new dialog         *
    *                          provides the ability to delete rows *
    *                          from the new SYSIBM.SYSUTILITIES    *
    *                          catalog table.                      *
    *                                                              *
    *                      c.  Add new Best Practice profile       *
    *                          HAAUSER.REORG DYXRTSTS AND DYXRTHTS *
    *                                                              *
    ****************************************************************
    * RECOMMENDATION: APPLY the PTF                                *
    ****************************************************************
    .
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    PH43895

  • Reported component name

    DB2 AUTOMATION

  • Reported component ID

    5697G6300

  • Reported release

    430

  • Status

    CLOSED UR1

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2022-02-07

  • Closed date

    2022-05-19

  • Last modified date

    2022-06-01

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

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

    UI80596

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#BND  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#ERTA HAA#ERTD
    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#UTLH HAA#UTLL HAA#UTOB HAA#UTOP HAA#VERT HAA#VMTB HAA#VSAM
    HAA#XMLC HAA#YARC HAA#YCAL HAA#YCTL HAA#YDEL HAA$$CCQ 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
    

Fix information

  • Fixed component name

    DB2 AUTOMATION

  • Fixed component ID

    5697G6300

Applicable component levels

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSZJXP","label":"DB2 Tools for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"4.3.0","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
06 July 2022