PI67259: -924 ERROR WHEN TRYING TO EXPORT STATISTICS FOR A TABLESPACE FROM A CATALOG COPY DURING MIGRATE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When attempting to export tablespace statistics for a
  tablespace from a catalog copy, the following error may result:
  
  Call to stored procedure DSNWZP failed. SQL code = -924
  DSNT408I SQLCODE = -924, ERROR: DB2 CONNECTION INTERNAL ERROR,
  0001, 0100,
  00F30016
  DSNT418I SQLSTATE = 58006 SQLSTATE RETURN CODE
  DSNT415I SQLERRP = DSNAET03 SQL PROCEDURE DETECTING ERROR
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Administration Tool for         *
  *                 z/OS who use the Migrate (MIG)               *
  *                 function after switching to a copy of        *
  *                 the catalog.                                 *
  ****************************************************************
  * PROBLEM DESCRIPTION: After switching to a copy of the        *
  *                      catalog on panel ADB21 'CCxx System     *
  *                      Catalog', migrating the objects         *
  *                      will result in a SQLCODE = -924 /       *
  *                      SQLCODEN924 when calling stored         *
  *                      procedure DSNWZP to get the DB2         *
  *                      ZPARM setting.                          *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When attempting to export tablespace statistics for a
  tablespace from a catalog copy, the following error
  SQLCODE=-924 / SQLCODEN924 may occur:
  
  DSNT408I SQLCODE = -924, ERROR: DB2 CONNECTION
  INTERNAL ERROR, 0001, 0100, 00F30016
  DSNT418I SQLSTATE = 58006
  SQLSTATE RETURN CODE
  

Problem conclusion

• The BIND PLAN ADB>Planname suffix< statement has been
  added into the generated bind job when creating catalog
  copy jobs to avoid a SQLCODE = -924 during the migration
  after switching to use copies of the DB2 catalog.
  

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:

  UI45192 UI45193 UI45194

Modules/Macros

•    ADB2CBND ADB2CC
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB10 PSY UI45192

     UP17/03/07 P F703

• RB20 PSY UI45193

     UP17/03/07 P F703

• RC10 PSY UI45194

     UP17/03/07 P F703

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.