A fix is available
APAR status
Closed as program error.
Error description
REPLACE OBSOLETE ADBGC10 FOR both AOC 10.2 AND 11.1. ADBGC SHOULD BE USED INSTEAD.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of DB2 Administration Tool for z/OS * * and IBM Tools Customizer (TCz) for z/OS. * **************************************************************** * PROBLEM DESCRIPTION: When performing a migration to DB2 10 * * or DB2 11 New Function Mode (NFM), and * * executing the DDL line command on a * * table space, DB2 Administration Tool * * issues a SQLCODE = -525 / SQLCODEN525: * * * * DSNT408I SQLCODE = -525, * * ERROR: THE SQL STATEMENT * * CANNOT BE EXECUTED BECAUSE * * IT WAS IN ERROR AT BIND TIME * * FOR SECTION = 6 PACKAGE = * * >ssid<.>package< * * DSNT418I SQLSTATE = 51015 * * SQLSTATE RETURN CODE * **************************************************************** * RECOMMENDATION: * **************************************************************** When performing a migration to DB2 10 or DB2 11 New Function Mode (NFM), and executing the DDL line command on a table space, DB2 Administration Tool issues a SQLCODE = -525 / SQLCODEN525: DSNT408I SQLCODE = -525, ERROR: THE SQL STATEMENT CANNOT BE EXECUTED BECAUSE IT WAS IN ERROR AT BIND TIME FOR SECTION = 6 PACKAGE = >ssid<.>package< DSNT418I SQLSTATE = 51015 SQLSTATE RETURN CODE
Problem conclusion
Problem has been resolved. TCz job template SADBDENU(ADBGC) for DB2 Administration Tool Version 10, Release 2 or greater has been enhanced to conditionally produce the appropriate GRANT statements based on the value specified for input field 'Level Number' on panel CCQPDB2 'DB2 Parameters', hence job template ADBGC10 is now obsolete and no longer generated / accessible via the TCz panel flow. Instructions: 1. Using TCz for DB2 Adminstration Tool, navigate to panel CCQPDB2 'DB2 Parameters' and ensure the following 'Level number' parameter value is set to 101 or 111: General DB2 Information Mode . . . . . . . . . . . . . . NFM (CM, CM8, CM9, NFM) Level number . . . . . . . . . . 101 (910, 101, 111) 2. Regenerate job template ADBGC 'GRANT on DB2 Catalog tables' and submit the job. Expect to see the following added GRANT statements in the job get executed: GRANT SELECT ON TABLE SYSIBM.SYSPENDINGDDL TO PUBLIC ; GRANT SELECT ON TABLE SYSIBM.SYSXMLTYPMSCHEMA TO PUBLIC ; GRANT SELECT ON TABLE SYSIBM.SYSCONTROLS TO PUBLIC ; GRANT SELECT ON TABLE SYSIBM.SYSTABLES_PROFILES TO PUBLIC ; GRANT SELECT ON TABLE SYSIBM.XSROBJECTS TO PUBLIC ; If migrating to DB2 Version 11, Release 1, set the 'Level Number' to 111, regenerate job template ADBGC 'GRANT on DB2 Catalog tables' ,and submit the job. Expect to see the following added GRANT statements in the job get executed: GRANT SELECT ON TABLE SYSIBM.SYSINDEXCLEANUP TO PUBLIC ; GRANT SELECT ON TABLE SYSIBM.SYSQUERYPREDICATE TO PUBLIC ; GRANT SELECT ON TABLE SYSIBM.SYSQUERYSEL TO PUBLIC ; GRANT SELECT ON TABLE SYSIBM.SYSSTATFEEDBACK TO PUBLIC ; GRANT SELECT ON TABLE SYSIBM.SYSVARIABLEAUTH TO PUBLIC ; GRANT SELECT ON TABLE SYSIBM.SYSVARIABLES TO PUBLIC ; Note: The following packages are affected: ADBTEPR ADB2REM ADB2REP ADB2RER ADB27SP ADB2SQL
Temporary fix
Comments
APAR Information
APAR number
PI06196
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-11-14
Closed date
2013-11-27
Last modified date
2013-12-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI13019 UI13052
Modules/Macros
ADBGC
Fix information
Fixed component name
DB2 ADMIN TOOL
Fixed component ID
568851500
Applicable component levels
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:
02 December 2013