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 number
PH43891
Reported component name
AUTONMICS DIR D
Reported component ID
5655V9301
Reported release
160
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:
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
[{"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":"1.6.0","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
06 July 2022