PI13850: ISPT034 TABLE IS NOT OPEN TBTOP ISSUED FOR TABLE ADB2DB2D THAT IS NOT OPEN.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS fails with a message:
  ****************************************************
  * ISPT034
  *
  * Table is not open
  * TBTOP issued for table ADB2DB2D that is not open.
  *
  * Current dialog statement:
  * TBTOP ADB2DB2D
  

Local fix

• None, this APAR will deliver additional diagnostic information.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool         *
  *                 and IBM Tools Customizer for z/OS.           *
  ****************************************************************
  * PROBLEM DESCRIPTION: Upon initial invocation of DB2          *
  *                      Administration Tool Version 10,         *
  *                      Release 1, the following dialog         *
  *                      error (without user response/           *
  *                      guidance) can occur if the              *
  *                      Customization table can not be          *
  *                      located:                                *
  *                                                              *
  *                      ISPT034                                 *
  *                      Table is not open                       *
  *                      TBTOP issued for table                  *
  *                      ADB2DB2D that is not open.              *
  *                      Current dialog statement:               *
  *                      TBTOP ADB2DB2D                          *
  *                                                              *
  *                      Upon initial invocation of DB2          *
  *                      Administration Tool Version 10,         *
  *                      Relase 2 and higher, the following      *
  *                      dialog error (without user response/    *
  *                      guidance) can occur if the              *
  *                      Customization table can not be          *
  *                      located:                                *
  *                                                              *
  *                      Function : ADB TBTOP                    *
  *                      ADBTPARM                                *
  *                      Retcode  : 12                           *
  *                      Zerrmsg  : ISPT034                      *
  *                      Zerrsm   : Table is not open            *
  *                      Zerrlm   : TBTOP issued for table       *
  *                      ADBTPARM that is not open.              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Upon initial invocation of DB2 Administration Tool Version 10,
  Release 1, the following dialog error (without user response/
  guidance) can occur if the Customization table can not be
  located:
  
  ISPT034
  Table is not open
  TBTOP issued for table
  ADB2DB2D that is not open.
  Current dialog statement:
  TBTOP ADB2DB2D
  
  Upon initial invocation of DB2 Administration Tool Version 10,
  Relase 2 and higher, the following dialog error (without user
  response/guidance) can occur if the Customization table can
  not be located:
  
  Function : ADB TBTOP
  ADBTPARM
  Retcode  : 12
  Zerrmsg  : ISPT034
  Zerrsm   : Table is not open
  Zerrlm   : TBTOP issued for table
  ADBTPARM that is not open.
  

Problem conclusion

• Problem has been resolved.
  Instead of the dialog error, the following error message WITH
  user response/guidance will now be displayed:
  
  For DB2 Administration Tool Version 10, Release 1:
  Customization table ADB2PARM does not exist in the ADB2PARM
  DB2 Admin Tool tables library >hlq<.SADBTLIB.  If
  (including ADB2DB2D) are available in a different library,
  ensure that library is LIBDEFed to ISPTLIB.
  
  For DB2 Administration Tool Version 10, Release 2 and higher:
  Customization table ADBTPARM does not exist in the DB2
  Admin Tool tables library >hlq<.SADBTLIB.  If ADBTPARM is
  available in a different library, ensure that library is
  LIBDEFed to ISPTLIB.
  

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:

  UI17028 UI17029 UI17030

Modules/Macros

• ADB      ADBEDIAG ADBE8T   ADBR
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UI17028

     UP14/04/16 P F404

• RA20 PSY UI17029

     UP14/04/16 P F404

• RB10 PSY UI17030

     UP14/04/16 P F404

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.