PH40074: SUPPORT FOR MISSING DB2 12 ZPARMS

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• Support for missing Db2 12 ZPARMs
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Administration Tool for z/OS    *
  *                 and Db2 Object Comparison Tool for z/OS      *
  ****************************************************************
  * PROBLEM DESCRIPTION: This APAR provides enhancements to      *
  *                      add support for additional Db2 v12      *
  *                      subsystem parameters (ZPARMs).          *
  ****************************************************************
  This APAR adds support as follows:
  (1) The following ZPARMs have been added to the ADB2ZZMN panel
  (System Parameters - System Parameters) in alphabetical order:
  
  ALLOW_UPD_DEL_INS_WITH_UR
  FTB_NON_UNIQUE_INDEX
  INLISTP
  LOAD_RO_OBJECTS
  STATIME_MAIN
  UNION_COLNAME_7
  UTILS_USE_ZSORT
  REORG_IC_LIMIT_DASD
  REORG_IC_LIMIT_TAPE
  REORG_INDEX_NOSYSUT1
  Additionally, the following corrections have been made on this
  panel:
  
  The CDDS_MODE and CDDS_PREFIX parameters are now
  displayed for Db2 v12.
  The description of the SYSTEM_LEVEL_BACKUPS parameter has
  been corrected.
  The abbreviation of the IX_TB_PART_CONV_EXCLUDE parameter
  has been corrected.
  (2) The MFA_AUTHCACHE_UNUSED_TIME parameter has been added to
  the ADB2ZZPR panel (System Parameters - Protection and Data
  Definition) at the end of the existing list.
  
  (3) The following changes were made on the ADB2ZZAP panel
  (System Parameters - Application Programming):
  
  The abbreviation of the LC_TYPE parameter has been
  corrected.
  A problem with displaying the value of the DECIMAL and
  LOB_INLINE_LENGTH parameters has been fixed.
  

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:

  UI77357

Modules/Macros

• ADB2ZZ   ADB2ZZAP ADB2ZZMN ADB2ZZPR ADB2ZZV9 ADB2ZZVA ADB2ZZVB
  ADB2ZZVC ADB41
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI77357

     UP21/10/01 P F109

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.