PI19859: SQLCODEN525 WHEN STARTING PRODUCT IF CHANGE MANAGEMENT DATABASE OBJECTS NOT RECREATED ( ADBL.ADBPARM PACKAGE FLAGGED )

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS issues an error message:
  Rollback done
  
  SQLCODE : -525                           DSNTIAR CODE : 0
  DSNT408I SQLCODE = -525, ERROR:  THE SQL STATEMENT CANNOT BE
  EXECUTED BECAUSE IT WAS IN ERROR AT BIND TIME FOR SECTION = 1
  PACKAGE = <ssid>..ADBL.ADBPARM CONSISTENCY TOKEN =
  when starting due to the Change Management Database related
  template ADBCHANG 'Create Change Management Database' job
  not being executed.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS and IBM Tools Customizer for z/OS.      *
  ****************************************************************
  * PROBLEM DESCRIPTION: During DB2 Admin customization via      *
  *                      IBM Tools Customizer for z/OS, the      *
  *                      user can decide to not use the          *
  *                      Change Management (CM) function         *
  *                      and a SQLCODE=-525 / SQLCODEN525        *
  *                      is encountered when launching           *
  *                      the DB2 Admin Tool:                     *
  *                                                              *
  *                      DSNT408I SQLCODE = -525,                *
  *                      ERROR:  THE SQL STATEMENT               *
  *                      CANNOT BE EXECUTED                      *
  *                      BECAUSE IT WAS IN ERROR AT              *
  *                      BIND TIME FOR                           *
  *                      SECTION = 1 PACKAGE =                   *
  *                      >package_name<                          *
  *                      CONSISTENCY TOKEN =                     *
  *                      >consistency_token<                     *
  *                      DSNT418I SQLSTATE   = 51015             *
  *                      SQLSTATE RETURN CODE                    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  A SQLCODE=-525 / SQLCODEN525 is the result of tables
  ADBPROFILE, ADBPROFILE_DATA, and ADBPROFILE_PARMS_DATA not
  being created during customization of job template ADBCHANG
  'Create Change Management database objects' or ADBMCMA 'Upgrade
  CM database to current'.
  

Problem conclusion

• Problem has been resolved.
  DB2 Admin can be brought up with no errors if the user decides
  to not use the Change Management function.
  

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:

  UI20899

Modules/Macros

•    ADBGETP
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB10 PSY UI20899

     UP14/08/29 P F408

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.