PH56995: (GOC) INTERNAL APAR SUPPORT FOR MISSING LOAD UTILITY OPTIONS

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• (GOC) Internal APAR  Support for missing LOAD utility options
  

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 LOAD utility options.   *
  ****************************************************************
  This APAR adds support as follows:
  
  The following options have been added to the 'Specify Utility
  Options - LOAD' panel (ADB2UTC):
   - FORCE
   - DEFINEAUX
   - PREFORMAT
   - FLOAT
   - NOCHECKPEND
   - NOSUBS
   - IGNORE
   - OVERRIDE
   - DRAIN_WAIT
   - RETRY
   - RETRY_DELAY
   - SWITCHTIME
   - INDEXDEFER
   - UPDMAXASSIGNEDVAL
  
  The following options have been added to the 'Table Utilities -
  LOAD with Cross Loader' panel (ADBPUTLC):
   - FORCE
   - DEFINEAUX
   - PREFORMAT
   - NOCHECKPEND
   - IGNORE
   - OVERRIDE
   - DRAIN_WAIT
   - RETRY
   - RETRY_DELAY
   - SWITCHTIME
   - INDEXDEFER
   - UPDMAXASSIGNEDVAL
  
  Also, for Db2 Admin Tool 12.1, statistics options STATCLGMEMSRT,
  HISTORY and FORCEROLLUP were added to the ADB2UTC and ADBPUTLC
  panels. In Db2 Admin Tool 13.1, these options have already been
  supported since GA.
  
  The following Change Management (CM) batch parameters have been
  added to CM batch:
   - UTIL_LOAD_BACKOUT
   - UTIL_LOAD_DECFLOAT_ROUNDMODE
   - UTIL_LOAD_DEFINEAUX
   - UTIL_LOAD_FORCE
   - UTIL_LOAD_INDEXDEFER
   - UTIL_LOAD_INDEXDEFER_NONUNIQUE
   - UTIL_LOAD_NOCHECKPEND
   - UTIL_LOAD_NOSUBS
   - UTIL_LOAD_PREFORMAT
  Also, Db2 Admin Tool 12.1 added support for the following
  additional parameters that are already supported in version
  13.1:
   - UTIL_LOAD_STATISTICS
   - UTIL_LOAD_STATISTICS_FORCEROLLUP
   - UTIL_LOAD_STATISTICS_INVALIDATECACHE
   - UTIL_LOAD_STATISTICS_HISTORY
   - UTIL_LOAD_STATISTICS_REPORT
   - UTIL_LOAD_STATISTICS_TABLE_SAMPLE
   - UTIL_LOAD_STATISTICS_UPDATE
   - UTIL_LOAD_STATISTICS_USE_PROFILE
  

Problem conclusion

Temporary fix

Comments

• Enhancements have been delivered.
  

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UI93649 UI93650

Modules/Macros

• GOCGCMP  GOCMENU
  

Fix information

• Fixed component name

  DB2 OBJECT COMP

• Fixed component ID

  5697G6400

Applicable component levels

• RC10 PSY UI93649

     UP23/09/23 P F309  

• RD10 PSY UI93650

     UP23/09/23 P F309  

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.