PH45607: ADB2GEN RC=12 SQLCODE -811 WHEN ACCELERATOR-ONLY TABLE IS DEFINED FOR HIGH AVAILABILITY.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• ADB2GEN ends with RC 12 with SQLCODE -811 when GEN line command
  is used to generate DDL for AOT(Accelerator only-table) that has
  been defined for high availability.
  
  ADDITIONAL SYMPTOMS:
  ADB2GEN SQLCODE811N AOT
  

Local fix

• BYPASS/CIRCUMVENTION:
  NA
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Administration Tool for z/OS    *
  *                 who use the GEN or DDL line command          *
  *                                                              *
  ****************************************************************
  * PROBLEM DESCRIPTION: ADB2GEN ends with RC12 and SQLCODE -811 *
  *                      when the GEN or DDL line command is     *
  *                      used on an accelerator-only table (AOT) *
  *                      that has been defined for high          *
  *                      availability (HA).                      *
  *                                                              *
  ****************************************************************
  When the GEN or DDL line command is used for an HA AOT, the
  query for the accelerator name returns multiple rows. The
  current SQL statement does not account for the multiple rows and
  results in SQLCODE -811.
  
  With this APAR, ADB2GEN is updated to handle multiple
  accelerators that are associated with an HA AOT. Also, the
  following new messages are introduced:
  
  ADB1668W Multiple accelerator aliases can be used to create the
  high availability accelerator-only table (HA AOT)
  accelerator-only-table-name. HA AOT accelerator-only-table-name
  will be created with the accelerator alias
  accelerator-alias-name.
  
  ADB1669W No accelerator alias includes list-of-accelerator-names
  for the high availability accelerator-only table (HA AOT)
  accelerator-only-table-name. DDL is not generated for HA AOT
  accelerator-only-table-name.
  
  ADB1670W DDL is not generated for object-type object-name
  because it is not supported on the function level
  target-function-level. The required function level is
  required-function-level.
  
  Keywords: ADB2GEN, SQLCODE811N, HA AOT
  

Problem conclusion

• The problem has been resolved.
  

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:

  UI81479 UI81480

Modules/Macros

• ADB1000  ADB2REM
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI81479

     UP22/07/16 P F207

• RD10 PSY UI81480

     UP22/07/16 P F207

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.