PH18193: RECREATING AND LOADING OF MORE THAN 1 TABLE ONTO IDAA WITH ADBTEP2 NOT WORK CORRECTLY

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Customer is using CM batch to compare, register, analyze and run
  a change, involving two DB2 tables, that are also added to an
  accelerator. As part of run (ALTER), DB2 tables are also
  recreated (drop/create), replicated, loaded & enabled on
  accelerator. Process of updating 1st table goes fine, but 2nd
  (or any subsequent) table fails with protection exception as
  below:
  
  IBM0534S ONCODE=8094 Protection exception
  From entry point HANDLEADMINRECREATEACCEL at statement 50015 at
  compile unit offset +0000047E at entry offset
  +0000047E at address 3BD2800E.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the Db2 Administration Tool for     *
  *                 z/OS.                                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: When using ADBTEP2 to recreate and      *
  *                      re-enable tables for acceleration on an *
  *                      IDAA accelerator, the second set of     *
  *                      statements processed may fail with      *
  *                      IBM0534S ONCODE=8094                    *
  ****************************************************************
  When using ADBTEP2 to recreate and re-enable tables for
  acceleration on an IDAA accelerator, the second set of
  statements processed may fail with IBM0534S ONCODE=8094.
  
  In the following example the fifth statement will fail.
  
  ADMIN ACCELERATOR RECREATE TABLES ON <accel01>
    INCLUDE <table1, table2 ,table3>;
  ADMIN ACCELERATOR ENABLE TABLES ON <accel01> TYPE REPLICATION
    INCLUDE <table1, table2 ,table3>;
  ADMIN ACCELERATOR LOAD TABLES ON <accel01> LOCKMODE TABLESET
    INCLUDE <table1, table2 ,table3>;
  ADMIN ACCELERATOR ENABLE TABLES ON <accel01> TYPE ACCELERATION
    INCLUDE <table1, table2 ,table3>;
  
  
  ADMIN ACCELERATOR RECREATE TABLES ON <accel02>
    INCLUDE <table4, table5 ,table6>;
  ADMIN ACCELERATOR ENABLE TABLES ON <accel01> TYPE REPLICATION
    INCLUDE <table4, table5 ,table6>;
  ADMIN ACCELERATOR LOAD TABLES ON <accel01> LOCKMODE TABLESET
    INCLUDE <table4, table5 ,table6>;
  ADMIN ACCELERATOR ENABLE TABLES ON <accel01> TYPE ACCELERATION
    INCLUDE <table4, table5 ,table6>;
  

Problem conclusion

• The issue 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:

  UI67440

Modules/Macros

• ADBDAT   ADBEAA   ADBTEP2
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI67440

     UP20/01/21 P F001

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.