A fix is available
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 number
PI13850
Reported component name
DB2 ADMIN TOOL
Reported component ID
568851500
Reported release
A10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2014-03-17
Closed date
2014-04-14
Last modified date
2014-05-02
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.
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSCVQTD","label":"IBM Db2 Administration Tool for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.1.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
02 May 2014