PH38172: GOC

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• GOC - Support for missing Db2 utility options
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the Db2 Administration Tool for     *
  *                 z/OS and Db2 Object Comparison Tool for      *
  *                 z/OS                                         *
  ****************************************************************
  * PROBLEM DESCRIPTION: This APAR provides enhancements to      *
  *                      add support for utility options         *
  *                      for the following utilities:            *
  *                                                              *
  *                      (1) UNLOAD                              *
  *                      (2) COPYTOCOPY                          *
  *                      (3) RUNSTATS                            *
  *                      (4) REBUILD INDEX                       *
  *                      (5) RECOVER                             *
  *                      (6) MODIFY STATISTICS                   *
  *                      (7) REORG TABLESPACE                    *
  ****************************************************************
  This APAR adds support as follows:
  
  (1) UNLOAD utility: The FROMSEQNO option was added to the
  'Specify Utility Options - UNLOAD' panel (ADB2USU).
  
  (2) COPYTOCOPY utility: The FROMLASTFLASHCOPY option was added
  to the 'Specify Utility Options - COPYTOCOPY' panel (ADB2US2)
  and to the 'Specify Utility Options - COPYTOCOPY INDEX' panel
  (ADB2UX2).
  
  (3) RUNSTATS utility: The STATCLGMEMSRT option and the value
  NONE for the TABLESAMPLE SYSTEM option were added to the
  'Specify Utility Options - RUNSTATS (TS)' panel (ADB2USR). NONE
  is valid for Db2 12 only.
  
  The SORTDEVT and SORTNUM options were added to the 'Specify
  Utility Options - RUNSTATS (TS)' panel (ADB2USRA).
  
  The following Change Management (CM) batch parameters
  were added:
  
  UTIL_RUNSTATS_PROFILE
  UTIL_RUNSTATS_SORTDEVT
  UTIL_RUNSTATS_SORTNUM
  (4) REBUILD INDEX utility: The values for the RBALRSN_CONVERSION
  option on the 'Specify Utility Options - REBUILD INDEX' panel
  (ADB2UXB) were updated to match those values that are currently
  supported by Db2 11 and 12. BASIC is valid for Db2 11 only.
  
  (5) RECOVER utility: The FROM option was added to the 'Specify
  Utility Options RECOVER' panel (ADB2USV). FROM is valid for
  Db2 12 only.
  
  The new 'Specify SOURCE for redirected recovery' panel
  (ADB2USVF) was added. This panel contains the fields to specify
  the source and the TOCOPY utility option.
  
  After the 'Specify Utility Options - RECOVER' panel (ADB2USV),
  the 'Specify Utility Options - REBUILD INDEX' panel (ADB2UXB)
  is displayed. Specifying UPDATED for the SCOPE option on panel
  ADB2USV now automatically sets the value PENDING for the SCOPE
  option on panel ADB2UXB.
  
  (6) MODIFY STATISTICS utility: The new 'Specify Utility
  Options - MODIFY STATISTICS' panel (ADB2USMS) was added. This
  panel contains the DELETE, AGE and DATE options.
  
  (7) REORG TABLESPACE utility: The options STATCLGMEMSRT, FORCE,
  NOCHECKPEND and SORTNPSI were added to the 'Specify Utility
  Options - REORG' panel (ADB2USO).
  
  The following CM batch parameters were added:
  
  UTIL_REORG_NOCHECKPEND
  UTIL_REORG_SORTNPSI
  UTIL_REORG_FORCE
  

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:

  UI76028

Modules/Macros

• GOCGCMP
  

Fix information

• Fixed component name

  DB2 OBJECT COMP

• Fixed component ID

  5697G6400

Applicable component levels

• RC10 PSY UI76028

     UP21/06/25 P F106

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.