A fix is available
APAR status
Closed as unreproducible in next release.
Error description
This APAR implements the following: 1) Support for Db2 V13: a. Page Sampling Inline Statistics - Support is added for page sampling in inline statistics for Reorg Tablespace utility. Panel HAA$USTT is enhanced to include the TABLESAMPLE keyword for Db2 V13 and is only valid when "Y" is specified for Table All. In addition, Page Sampling will be added to the object profile for when table specific statistics are required (panel HAA$STSM). b. The following fields on panel HAA$EPRU are being modified to allow BIGINT values to be entered. This is due to Db2 V13 (FL501 and above) expansion of specific INTEGER columns to BIGINT in catalog tables SYSIBM.SYSTABLESPACESTATS and SYSIBM.SYSINDEXSPACESTATS - as well as their associated history tables SYSIBM.SYSTABLESPACESTATS_H and SYSIBM.SYSINDEXPACESTATS_H: - Real Time IndexSpace Statistics INDEXSPACESTATS SPACE - Real Time Image Copy related Thresholds...since last COPY REALTIME ICOPY COPY_CHANGES - Real Time Reorg Tablespace related Thresholds...since last REORG REALTIME REORG TS INSERTS DELETES INS_UPD_DEL - Real Time Reorg Index related Thresholds...since last REORG REALTIME REORG IX INSERTS DELETES INS_DEL APPENDED_INS PSEUDO_DEL - Real Time Runstats related Thresholds...since last RUNSTATS REALTIME RUNSTATS INS_UPD_DEL c. Add support for the new Utility History catalog tables for backup and recovery. d. For Db2 V12 REORG INDEX utility, panel HAA$UREX (Reorg Index Utility Profile Options) contains a NOSYSUT1 field - and if "Y" is entered, the NOSYSUT1 keyword will be generated in the REORG INDEX utility syntax. For Db2 V13 REORG INDEX utility, the NOSYSUT1 field has been removed from panel HAA$UREX (Reorg Index Utility Profile Options) as Db2 V13 no longer requires a SYSUT1 template or dataset if SHRLEVEL = REFERENCE or CHANGE. However, if SHRLEVEL = NONE, then Db2 Automation Tool will generate the SYSUT1 template and dataset. 2) Support removal of the COUNT keyword in the Runstats IX and Recover utilities - to allow Db2 to automatically determine the number of frequently occurring values to collect so that the data distribution is no longer skewed.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: ALL USERS * **************************************************************** * PROBLEM DESCRIPTION: This HAA V4.3 APAR implements the * * following: * * 1) Support for Db2 V13: * * * * a. Page Sampling Inline * * Statistics - Support is added * * for page sampling in inline * * statistics for Reorg * * Tablespace utility. Panel * * HAA$USTT is enhanced to * * include the TABLESAMPLE * * keyword for Db2 V13 and is * * only valid when "Y" is * * specified for Table All. * * * * In addition, Page Sampling * * will be added to the object * * profile for when table * * specific statistics are * * required (panel HAA$STSM). * * * * b. The following fields on panel * * HAA$EPRU are being modified to * * allow BIGINT values to be * * entered. This is due to Db2 * * * * V13 (FL501 and above) * * expansion of specific INTEGER * * columns to BIGINT in catalog * * tables * * SYSIBM.SYSTABLESPACESTATS and * * SYSIBM.SYSINDEXSPACESTATS - * * as well as their associated * * history tables * * SYSIBM.SYSTABLESPACESTATS_H * * and * * SYSIBM.SYSINDEXPACESTATS_H: * * * * - Real Time IndexSpace * * Statistics * * INDEXSPACESTATS * * SPACE * * * * - Real Time Image Copy * * related Thresholds... * * since last COPY * * REALTIME ICOPY * * COPY_CHANGES * * * * - Real Time Reorg Table- * * space related Thresholds * * ...since last REORG * * REALTIME REORG TS * * INSERTS * * DELETES * * INS_UPD_DEL * * * * - Real Time Reorg Index... * * related Thresholds... * * since last REORG * * REALTIME REORG IX * * INSERTS * * DELETES * * INS_DEL * * APPENDED_INS * * PSEUDO_DEL * * * * - Real Time Runstats * * related Thresholds... * * since last RUNSTATS * * REALTIME RUNSTATS * * INS_UPD_DEL * * * * c. Add support for the new * * Utility History catalog * * tables for backup and recovery * * * * d. For Db2 V12 REORG INDEX * * utility, panel HAA$UREX * * (Reorg Index Utility Profile * * Options) contains a NOSYSUT1 * * field - and if "Y" is entered, * * the NOSYSUT1 keyword will be * * generated in the REORG INDEX * * utility syntax. * * * * For Db2 V13 REORG INDEX * * utility, the NOSYSUT1 field * * has been removed from panel * * HAA$UREX (Reorg Index Utility * * Profile Options) as Db2 V13 * * no longer requires a SYSUT1 * * template or dataset if * * SHRLEVEL = REFERENCE or * * CHANGE. However, if * * SHRLEVEL = NONE, then Db2 * * Automation Tool will generate * * the SYSUT1 template and * * dataset. * * * * 2) Support removal of the COUNT * * keyword in the Runstats IX and * * Recover utilities - to allow Db2 * * to automatically determine the * * number of frequently occurring * * values to collect so that the * * data distribution is no longer * * skewed. * **************************************************************** * RECOMMENDATION: APPLY THE PTF * **************************************************************** .
Problem conclusion
Temporary fix
Comments
×**** PE22/06/08 FIX IN ERROR. SEE APAR PH47088 FOR DESCRIPTION
APAR Information
APAR number
PH44145
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-14
Closed date
2022-04-26
Last modified date
2022-06-29
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI80306
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#ERT8 HAA#ERT9 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#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
Fix information
Fixed component name
DB2 AUTOMATION
Fixed component ID
5697G6300
Applicable component levels
R430 PSY UI80306
UP22/04/29 P F204
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.
[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"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"}]
Document Information
Modified date:
30 June 2022