PI06196: REPLACE OBSOLETE ADBGC10 FOR AOC 10.2 AND 11.1

Obtain the fix for this APAR.

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 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

• RA20 PSY UI13018

     UP13/11/30 P F311

• RB10 PSY UI13019

     UP13/11/30 P F311

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.