PH43891: SDYXDENU - Implement Support for Db2 V13

APAR status

• Closed as new function.

Error description

• This APAR implements support for Db2 V13 as follows:
  1) SHAADENU, TCz panel CCQPDB2, field Level Number:
  a. remove support for Db2 V10; a value of "101" has been removed
  b. add support for Db2 V13; a value of "131" has been added
  2) SDYXDENU - TCz jobs for DYX DDL will be modified to ALTER the
  following columns from INTEGER to BIGINT:
  Table: SYSAUTO.SYSTABLESPACESTATS_HIST
    REORGINSERTS
    REORGDELETES
    REORGUPDATES
    STATSINSERTS
    STATSDELETES
    STATSUPDATES
    COPYCHANGES
  Table: SYSAUTO.SYSINDEXSPACESTATS_HIST
    SPACE
    REORGINSERTS
    REORGDELETES
    REORGAPPENDINSERT
    REORGPSEUDODELETES
    STATSINSERTS
    STATSDELETES
    COPYCHANGES
    In addition, the following NEW COLUMNS will be added:
      REORGEXCSPLITS      (INTEGER)
      REORGSPLITTIME      (BIGINT)
      REORGTOTALSPLITS    (INTEGER)
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All Users                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: This APAR implements support for Db2    *
  *                      V13 as follows:                         *
  *                                                              *
  *                      1) SHAADENU, TCz panel CCQPDB2, field   *
  *                         Level Number:                        *
  *                                                              *
  *                         a. remove support for Db2 V10; a     *
  *                            value of "101" has been removed   *
  *                         b. add support for Db2 V13; a value  *
  *                            of "131" has been added           *
  *                                                              *
  *                      2) SDYXDENU - TCz jobs for DYX DDL will *
  *                         be modified to ALTER the following   *
  *                         columns from INTEGER to BIGINT:      *
  *                                                              *
  *                      Table: SYSAUTO.SYSTABLESPACESTATS_HIST  *
  *                        REORGINSERTS                          *
  *                        REORGDELETES                          *
  *                        REORGUPDATES                          *
  *                        STATSINSERTS                          *
  *                        STATSDELETES                          *
  *                        STATSUPDATES                          *
  *                        COPYCHANGES                           *
  *                                                              *
  *                      Table: SYSAUTO.SYSINDEXSPACESTATS_HIST  *
  *                        SPACE                                 *
  *                        REORGINSERTS                          *
  *                        REORGDELETES                          *
  *                        REORGAPPENDINSERT                     *
  *                        REORGPSEUDODELETES                    *
  *                        STATSINSERTS                          *
  *                        STATSDELETES                          *
  *                        COPYCHANGES                           *
  *                                                              *
  *                         In addition, the following NEW       *
  *                         COLUMNS will be added:               *
  *                                                              *
  *                             REORGEXCSPLITS      (INTEGER)    *
  *                             REORGSPLITTIME      (BIGINT)     *
  *                             REORGTOTALSPLITS    (INTEGER)    *
  ****************************************************************
  * 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:

  UI80597

Modules/Macros

• DYX#BSQL DYX$$CCQ DYX@BSQL DYXDDL1
  

Fix information

• Fixed component name

  AUTONMICS DIR D

• Fixed component ID

  5655V9301

Applicable component levels