PI66055: ADBT007E - SQL ERROR ON ADBCHKPT TABLE, SQL CODE=- 305 SQL ERROR TOKENS: 20

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Batch jobs generated through the
  Admin Tool to rebind packages may fail with the following error:
  
  ADBT007E - SQL error on ADBCHKPT Table, SQL code= -  305 SQL
  error tokens:   20
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Administration Tool for         *
  *                 z/OS who use Batch Restart program           *
  *                 ADBTEP2 to run Work Statement List           *
  *                 (WSL).                                       *
  ****************************************************************
  * PROBLEM DESCRIPTION: When running the Batch Restart          *
  *                      program ADBTEP2, DB2 Admin fails        *
  *                      with a SQLCODE = -305 / SQLCODEN305     *
  *                      if there is a checkpoint record         *
  *                      associated with the current work        *
  *                      statement list (WSL).                   *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  If there is a checkpoint record associated with the current
  work statement list (WSL), DB2 Admin fails with the following
  error ADBT007E / msgadbt007e and SQLCODE=-305:
  
  ADBT007E - SQL error on ADBCHKPT Table, SQL code= - 305
             SQL error tokens:   20
  

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:

  UI45190 UI45191

Modules/Macros

•    ADBTEP2
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB20 PSY UI45181

     UP17/03/07 P F703

• RC10 PSY UI45191

     UP17/03/07 P F703

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.