PH02457: DB2 ADMIN TOOL - ADD SUPPORT FOR NEW DB2 RUNSTATS OPTION INVALIDATECACHE

Obtain the fix for this APAR.

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 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.