A fix is available
APAR status
Closed as new function.
Error description
Db2 V12.1 added RUNSTATS option INVALIDATECACHE Y/N to give more control over when RUNSTATS invalidates statements in the dynamic statement. Previously running the RUNSTATS always invalidates the dynamic cache. This APAR adds support for INVALIDATECACHE option.
Local fix
n/a
Problem summary
**************************************************************** * USERS AFFECTED: Users of the Db2 Administration and Object * * Comparison Tool for z/OS. * **************************************************************** * PROBLEM DESCRIPTION: This APAR provides below enhancements: * * 1. Support new Db2 v12 Utility * * Statistics Options * * 2. Ability to dynamically find DECP * * settings from DB2 session variables * * (instead of getting them from DSNHDECP * * module). * * 3. Tolerate Db2 Function level 505. * * * * Changes made in the utilities are as * * follows: * * * * RUNSTATS/REORG Tablespace, * * REORG/REBUILD Index, LOAD Table. * **************************************************************** This APAR provides below enhancements: 1. Support new Db2 v12 Utility Statistics Options 2. Ability to dynamically find DECP settings from DB2 session variables (instead of getting them from DSNHDECP module). 3. Tolerate Db2 Function level 505. Changes made in the utilities are as follows: 1.RUNSTATS Tablespace: - Panel ADB2USRA 'Specify Utility Options - RUNSTATS (TS)' is updated to let user enter INVALIDATECACHE option. - New CM batch parameter is added. util_runstats_invalidatecache: Specifies the INVALIDATECACHE option for the generated RUNSTATS utility statements. 2.REORG Tablespace: - Panel ADB2USO 'Specify Utility Options - REORG' is updated to let user enter INVALIDATECACHE and USE PROFILE options. - New CM batch parameters are added. util_reorg_statistics_invalidatecache: Specifies the INVALIDATECACHE option for the generated REORG utility statements with inline statistics. If you specify util_reorg_statistics_invalidatecache, you must also specify util_reorg_statistics ='Y'. util_reorg_statistics_use_profile: Specifies that the USE PROFILE option is to be added to the generated REORG utility statements. 3.REORG Index: - Panel ADB2UXO2 'Specify Utility Options - REORG INDEX' is updated to let user enter INVALIDATECACHE and OCCUR options. 4.REBUILD Index: - Panel ADB2UXB 'Specify Utility Options - REBUILD INDEX' is updated to let user enter INVALIDATECACHE and OCCUR options. 5.LOAD Table: - Panel ADB2UTC 'Specify Utility Options - LOAD' and panel ADBPUTLC 'Specify Utility Options - LOAD with Cross Loader' is updated to let user enter INVALIDATECACHE and USE PROFILE options.
Problem conclusion
Enhancements delivered and problems resolved.
Temporary fix
Comments
APAR Information
APAR number
PH02457
Reported component name
DB2 ADMIN TOOL
Reported component ID
568851500
Reported release
C10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2018-09-07
Closed date
2019-08-08
Last modified date
2019-09-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI64651
Modules/Macros
ADB1000 ADB2000 ADB25LU ADB26COQ ADB27AC ADB28M ADB28MC ADB28MCT ADB2CCL ADB2CCU ADB2CID ADB2CM1 ADB2CM2 ADB2CM3 ADB2CME ADB2CMF ADB2CMO ADB2CMP ADB2CMR ADB2CMS ADB2CMT ADB2CMU ADB2DEP ADB2FMT ADB2GDP ADB2INC ADB2MSK ADB2MSQ ADB2PA ADB2PA3 ADB2PA4 ADB2PA5 ADB2PA6 ADB2PA7 ADB2PRP ADB2RE ADB2REE ADB2REG ADB2REH ADB2REM ADB2REP ADB2RER ADB2RES ADB2RET ADB2REU ADB2REY ADB2REZ ADB2RGC ADB2U ADB2UOPS ADB2US ADB2USO ADB2USOP ADB2USRA ADB2USRO ADB2UT ADB2UTC ADB2UTCO ADB2UX ADB2UXB ADB2UXBO ADB2UXO2 ADB2UXOO ADB2W1Q ADB2WCL ADB2WIN ADB2WVL ADB2ZZ ADBALT ADBBIND ADBCCM ADBCCMM ADBCDTS ADBCDTW ADBCEST ADBCEXP ADBCMBIV ADBCP ADBCRCM ADBCRCR ADBCVEY ADBD ADBDET ADBDK ADBE7JA0 ADBEALT ADBEDIAG ADBGAJOB ADBHUSO ADBHUSRA ADBHUTC ADBHUTLC ADBHUXB ADBHUXO2 ADBLI ADBMAIN ADBNSPB ADBPA ADBPA1 ADBPUTLC ADBR ADBTEP2 ADBTEPI ADBTEPU ADBV99 ADBVERS
Fix information
Fixed component name
DB2 ADMIN TOOL
Fixed component ID
568851500
Applicable component levels
RC10 PSY UI64651
UP19/08/09 P F908
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.
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSCVQTD","label":"IBM Db2 Administration Tool for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"12.1.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
01 September 2019