A fix is available
APAR status
Closed as program error.
Error description
The DB2 Administration Tool for z/OS' BIND job fails with SQLCODEN204 / SQLCODE -204 for the BIND of PACKAGE(ADBL) with MEMBER(ADBC0): DSNX200I +DBS1 BIND SQL ERROR USING >sqlid< AUTHORITY PLAN=(NOT APPLICABLE) DBRM=ADBC0 STATEMENT=953 SQLCODE=-204 SQLSTATE=42704 TOKENS=SYSPROF.ADBCMPREP CSECT NAME=DSNXOTL RDS CODE=-500 and the following tables: ADBIGNORECHGOBJ ADBCMPREP ADBCMPREPOBJ ADBCMPREPOBJLINES ADBCMPREP ADBIGNORECHGSPEC as the SADBSAMP library member ADBCHG01 had not been executed.
Local fix
Run the SADBSAMP library member ADBCHG01 then the BIND job.
Problem summary
**************************************************************** * USERS AFFECTED: Users of the DB2 Administration Tool and * * IBM Tools Customizer (TCz) for z/OS. * **************************************************************** * PROBLEM DESCRIPTION: The following have been fixed: * * * * 1. The DB2 Administration Tool for * * z/OS BIND job ADBBIND fails with * * SQLCODEN204 / SQLCODE=-204 for the * * BIND of PACKAGE(ADBL) with member * * ADBC0: * * * * DSNX200I >ssid< BIND SQL * * ERROR USING >sqlid< * * AUTHORITY * * PLAN=(NOT APPLICABLE) * * DBRM=ADBC0 * * STATEMENT=953 * * SQLCODE=-204 * * SQLSTATE=42704 * * TOKENS=SYSPROF.ADBCMPREP * * CSECT NAME=DSNXOTL * * RDS CODE=-500 * * * * The BIND failure is due to the * * following objects that have not been * * created during the Change * * Management Upgrade process: * * * * ADBIGNORECHGOBJ * * ADBCMPREP * * ADBCMPREPOBJ * * ADBCMPREPOBJLINES * * ADBIGNORECHGSPEC * * * * To resolve this, a new member * * SADBSAMP(ADBCHG02) has been provided * * as part of the Change Management * * Upgrade process to create the * * missing objects. * * * * 2. Removed redundant * * usage/reference of template * * ADBOPTS since the process * * to add options to the DB2 * * Administration Tool Primary * * Menu 'ADB2' panel is already * * accommodated by General * * Customization template * * ADBCUST. * * * * 3. Input field '(Global) REXX * * user exit libraries' on panel * * CCQPPRD 'Product Parameters' * * only allowed one dataset. * * * * 4. Input field '(Global) HPU * * parameter library' on panel * * CCQPPRD 'Product Parameters' * * only allowed one dataset. * * * * 5. Input field '(Global) HPU * * load library' on panel * * CCQPPRD 'Product Parameters' * * only allowed one dataset. * * * * 6. Ensure job for template * * ADBPRHIS is not generated * * for DB2 9. * **************************************************************** * RECOMMENDATION: * **************************************************************** The following have been fixed: 1. The DB2 Administration Tool for z/OS BIND job ADBBIND fails with SQLCODEN204 / SQLCODE= -204 for the BIND of PACKAGE(ADBL) with member ADBC0: DSNX200I >ssid< BIND SQL ERROR USING >sqlid< AUTHORITY PLAN=(NOT APPLICABLE) DBRM=ADBC0 STATEMENT=953 SQLCODE=-204 SQLSTATE=42704 TOKENS=SYSPROF.ADBCMPREP CSECT NAME=DSNXOTL RDS CODE=-500 The BIND failure is due to the following objects that have not been created during the Change Management Upgrade process: ADBIGNORECHGOBJ ADBCMPREP ADBCMPREPOBJ ADBCMPREPOBJLINES ADBIGNORECHGSPEC To resolve this, a new member SADBSAMP(ADBCHG02) has been provided as part of the Change Management Upgrade process to create the missing objects. 2. Removed redundant usage/reference of template ADBOPTS since the process to add options to the DB2 Administration Tool Primary Menu 'ADB2' panel is already accommodated by General Customization template ADBCUST. 3. Input field '(Global) REXX user exit libraries' on panel CCQPPRD 'Product Parameters' only allowed one dataset. 4. Input field '(Global) HPU parameter library' on panel CCQPPRD 'Product Parameters' only allowed one dataset. 5. Input field '(Global) HPU load library' on panel CCQPPRD 'Product Parameters' only allowed one dataset 6. Ensure job for template ADBPRHIS is not generated for DB2 9.
Problem conclusion
Problem has been resolved. A new member SADBSAMP(ADBCHG02) has been added. Its purpose is to upgrade the Change Management (CM) database with the following: 1. Alter existing DB2 Administration Tool Version 10.1 CM table to Version 10.2. 2. Create new CM objects for DB2 Administration Tool Version 10.2. Instructions on how to resolve the reported BIND error(s): 1. Submit TCz job ADBMCMA - JOB TO UPGRADE CHANGE MANAGEMENT DB FROM DB2 ADMIN VERSION 10.1 TO VERSION 10.2. 2. Submit 'DMTOOL.ADBA2MPE.SADBSAMP(ADBCHG01)' 3. Submit 'DMTOOL.ADBA2MPE.SADBSAMP(ADBCHG02)' 4. Submit TCz job ADBBIND - Job to BIND DB2 Administration Tool.
Temporary fix
Comments
APAR Information
APAR number
PM80870
Reported component name
DB2 ADMIN TOOL
Reported component ID
568851500
Reported release
A20
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2013-01-17
Closed date
2013-02-22
Last modified date
2013-03-04
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK91912
Modules/Macros
ADB$$PRM ADB$$SEQ ADBBIND ADBCHANG ADBCHG02 ADBCUST ADBMCMA ADBTEP2R ADB2CUST
Fix information
Fixed component name
DB2 ADMIN TOOL
Fixed component ID
568851500
Applicable component levels
RA20 PSY UK91912
UP13/02/26 P F302
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.2.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
04 March 2013