PM66624: ISSUES WITH SUBSYSTEMS IN CM8 MODE AFTER UPGRADE FROM DB2 V8 TO V10

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• This APAR addresses the following issues with DB2 V10 subsystems
  that are in V8 compatibility mode (CM8):
  1) VERIFYSET and ENFORCE keywords included on Recover utility.
  2) On panel HAA$UOPE (Online Reorg Options), setting 'AUX' field
  to 'Y' is allowed.
  3) On panel HAA$URPR (Repair Options), fields 'No Advisory Reorg
  Pending', 'Rebuild Pending' and 'Page Set Rebuild Pending' are
  available for update.
  4) Access to panel HAA$STI2 (Runstats Column Statistics) is
  allowed.
  5) On panel HAA$UREO (Reorg Utility Profile Options), fields
  'Parallel', 'Auto Estimate Hash Space', 'Perform LOB Dependency
  checks', and 'Exclude objects that failed Dependency check' are
  available for update.
  6) On panel HAA$URBD (Rebind Utility profile options), updates
  to
  fields 'Access Path Retain Duplicate' and 'Switch' can result in
  incorrect error messages.
  7) Error message HAAB074E can be incorrectly displayed for
  tablespaces
  DSNDB01.SYSDBDXA, DSNDB01.SYSSPUXA, and DSNDB01.SYSSPUXB.
  8) On panels HAA$ORS and HAA$URST, fields 'Table Sample' and
  'Repeatable' are available for update.
  9) On panel HAA$EPRU (Update Exception Profile Display) options
  SYSTABLEPART.ROWFORMAT and OBJECT.PBG_TS are available.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Automation Tool.                *
  ****************************************************************
  * PROBLEM DESCRIPTION: This APAR addresses the following       *
  *                      issues with DB2 V10 subsystems that     *
  *                      are in V8 compatibility mode (CM8):     *
  *                      1. VERIFYSET and ENFORCE keywords       *
  *                       included on Recover utility.           *
  *                      2. On panel HAA$UOPE (Online Reorg      *
  *                       Options), setting 'AUX' field to 'Y'   *
  *                       is allowed.                            *
  *                      3. On panel HAA$URPR (Repair Options),  *
  *                       fields 'No Advisory Reorg Pending',    *
  *                       'Rebuild Pending' and 'Page Set        *
  *                       Rebuild Pending' are available for     *
  *                       update.                                *
  *                      4. Access to panel HAA$STI2 (Runstats   *
  *                       Column Statistics) is allowed.         *
  *                      5. On panel HAA$UREO (Reorg Utility     *
  *                       Profile Options), fields 'Parallel',   *
  *                       'Auto Estimate Hash Space',            *
  *                       'Perform LOB Dependency checks', and   *
  *                       'Exclude objects that failed           *
  *                       Dependency check' are available for    *
  *                       update.                                *
  *                      6. On panel HAA$URBD (Rebind Utility    *
  *                       profile options), updates to fields    *
  *                       'Access Path Retain Duplicate' and     *
  *                       'Switch' can result in incorrect error *
  *                       messages.                              *
  *                      7. Error message HAAB074E can be        *
  *                       incorrectly displayed for tablespaces  *
  *                       DSNDB01.SYSDBDXA, DSNDB01.SYSSPUXA,    *
  *                       and DSNDB01.SYSSPUXB.                  *
  *                      8. On panels HAA$ORS and HAA$URST,      *
  *                       fields 'Table Sample' and 'Repeatable' *
  *                       are available for update.              *
  *                      9. On panel HAA$EPRU (Update Exception  *
  *                       Profile Display) options               *
  *                       SYSTABLEPART.ROWFORMAT and             *
  *                       OBJECT.PBG_TS are available.           *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Code has been changed to correct this condition.
  

Problem conclusion

• APPLY the PTF.
  

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:

Modules/Macros

• HAA$STSM HAAREPRC
  

Fix information

• Fixed component name

  DB2 AUTOMATION

• Fixed component ID

  5697G6300

Applicable component levels

• R310 PSY UK81158

     UP12/08/23 P F208

• R410 PSY UK81159

     UP12/08/23 P F208

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.