PI37023: WHEN OPTION CO SET TO YES BUT ACCELERATED TABLES DO NOT EXIST, ALTER PROCESS RESULTS IN ERROR

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 Administration Tool for z/OS when option CO is set to YES
  but
  the accelerated tables do not exist ALTer process results in
  the error message with RC=8:
  Unexpected sqlcode : 100 in SYSACCEL.SYSACCELERATORS does not
  exist.
  ADBCMPDB - Exiting due to an error. Return code =  8
  

Local fix

• Set CO option to NO on Panel ADB2P :
  ---DB2 Change DB2 Admin Options ---
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS and DB2 Object Comparison Tool for      *
  *                 z/OS who use Compare but IBM DB2 Analytics   *
  *                 Accelerator for z/OS (IDAA) is not           *
  *                 available on their DB2 subsystem.            *
  ****************************************************************
  * PROBLEM DESCRIPTION: When setting 'Reload accelerated        *
  *                      tables' to 'YES' on panel ADB2PCO       *
  *                      'Change Options Common to Change        *
  *                      Functions', but the accelerated         *
  *                      tables do not exist, the alter          *
  *                      process results in RC=8 / Return        *
  *                      Code 8 and the following error          *
  *                      message:                                *
  *                                                              *
  *                      Unexpected sqlcode :                    *
  *                      100 in SYSACCEL.SYSACCELERATORS         *
  *                      does not exist.                         *
  *                      ADBCMPDB - Exiting due to an error.     *
  *                      Return code =  8                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Program should not display an Unexpected sqlcode message when
  IDAA is not available for DB2 subsystem.
  

Problem conclusion

• Problem has been resolved to display a new warning message
  when detecting IDAA is not available for the current DB2
  subsystem:
  
  ADB7952W
  IBM DB2 Analytics Accelerator is not available for the
  current DB2 subsystem.
  
  Explanation
  Admin or Object Comparison Tool has detected and reloaded
  the accelerated tables that contain modified data, but DB2
  Analytics Accelerator is not available for the current DB2
  subsystem.
  
  User response
  Turn off Reload accelerated tables on panel ADB2PCO or
  install DB2 Analytics Accelerator for the current DB2
  subsystem.
  
  System action
  A return code of 4 is set, and processing continues.
  

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:

  UI27731

Modules/Macros

•    ADBCMPDB ADB7000
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB10 PSY UI27731

     UP15/05/19 P F505

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.