PI58703: ADBTEP2 GETTABLEKEYINFO ABENDS0C4

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS' Batch Restart Program
  ADBTEP2 fails with:
  SYSTEM ABEND CODE 0C4   REASON CODE 00000004
  CEE3845I CEEDUMP Processing started.
  PLIDUMP was called from statement number 1019 at offset
  +00000208 from GETTABLEKEYINFO with entry address nnnnnnnn
  Information for enclave ADBTEP2
  when attempting to process an ADMIN ACCELERATOR RECREATE TABLES
  ON statement.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS and the DB2 Object Comparison Tool for  *
  *                 z/OS who use the IBM DB2 Analytics           *
  *                 Accelerator for IBM z/OS (IDAA) product for  *
  *                 query enhancements and who make changes to   *
  *                 the table definitions added to the           *
  *                 accelerator.                                 *
  ****************************************************************
  * PROBLEM DESCRIPTION: When alter table, alter index or        *
  *                      remove/recreate tables in an            *
  *                      accelerator the jobs fail with SYSTEM   *
  *                      ABEND CODE 0C4.                         *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The DB2 Administration Tool for z/OS' CM batch, Object Compare
  or ALT function jobs involving ALTering DB2 table definition,
  fail with:
  
  IBM0534S ONCODE=8094  Protection exception
     From entry point GETTABLEKEYINFO at statement 1019 at
     compile unit offset +nnnnnnnn at entry offset +nnnnnnnn at
     address nnnnnnnn.
  

Problem conclusion

• Message ADB5258E  has been modified to display additional point
  of failure information.
  
  For example:
  
  ADB5044I *** INPUT STATEMENT:
          ADMIN ACCELERATOR RECREATE TABLES ON ACCEL1 INCLUDE
          >schema<.>tablename<;
  DSNT408I SQLCODE = -444, ERROR:  USER PROGRAM >prg_name< COULD
           NOT BE FOUND
  DSNT418I SQLSTATE   = 42724 SQLSTATE RETURN CODE
  DSNT415I SQLERRP    = DSNX9CAC SQL PROCEDURE DETECTING ERROR
  DSNT416I SQLERRD    = 0  0  0  -1  0  0 SQL DIAGNOSTIC
           INFORMATION
  DSNT416I SQLERRD    = X'00000000'  X'00000000'  X'00000000'
           X'FFFFFFFF' X'00000000'  X'00000000' SQL DIAGNOSTIC
           INFORMATION
  
  ADB5258E Table(s) cannot be recreated on the accelerator.
  Sqlcode = -444
  ADB5185E The run is ending due to errors.
  
  New messages while doing recreate on accelerator:
  
  ADB5275I
  Type: Informational
  Message: Found >keytype< key >colname< for >table-name<.
  Explanation: This informational message is displayed while
               trying to recreate DB2 tables on the accelerator
               and if distribution or organizing keys were
               specified for those accelerated tables previously.
  User action: None
  System action: Processing continues
  
  ADB5276I
  Type: Informational
  Message: No distribution or organizing keys found for the
           tables.
  Explanation: This informational message is displayed while
               trying to recreate DB2 tables on the accelerator
               and no keys were specified for those accelerated
               tables.
  User action: None
  System action: Processing continues
  
  We are also delivering additional IDAA related CM Batch
  parameters:
  
  RECREATE_ACCELERATED_TABLES:
    The recreate_accelerated_tables parameter specifies whether
    to automatically detect and recreate accelerated tables,
    in situations of DROP/CREATE or ALTER of accelerated tables
    in DB2, involving changes to its definition or partitions.
  
    Values: YES, NO
          YES - Recreate accelerated tables.
          NO - Do not recreate accelerated tables.
    Default:  YES
  
  REMOVE_ACCELERATED_TABLES:
    The remove_accelerated_tables parameter specifies whether
    to automatically detect and remove dropped DB2 tables
    involved in change management, from the accelerator.
  
    Values: YES, NO
          YES - Remove accelerated tables.
          NO - Do not remove accelerated tables.
    Default: YES
  

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:

  UI36650

Modules/Macros

•    ADBCCM   ADBDAT   ADB2000  ADB5000  H0IHB20J
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB20 PSY UI36650

     UP16/04/01 P F603

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.