PI08123: ADBMAIN SQLCODEN525 WHEN RUNNING ON DB2 10 CM8 13/12/16 PTF PECHANGE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS' ADBMAIN program fails
  with a SQLCODEN525 / SQLCODE -525 when running on a DB2 Version
  10.1 CM8 subsystem.
  
  Additional symptoms : This APAR also corrects SQLCODE = -311
  SQLCODEN311 received on panel ADB21D for the DS command
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS running on DB2 10 in CM8 (Conversion    *
  *                 mode from V8).                               *
  ****************************************************************
  * PROBLEM DESCRIPTION: An SQLCODE=-525 / SQLCODEN525 was       *
  *                      received on all dynamic SQL             *
  *                      statements:                             *
  *                                                              *
  *                      DSNT408I SQLCODE = -525, ERROR:         *
  *                      THE SQL STATEMENT CANNOT BE             *
  *                      EXECUTED BECAUSE IT WAS IN ERROR        *
  *                      AT BIND TIME FOR                        *
  *                      SECTION = 3 PACKAGE =                   *
  *                      >package_name<                          *
  *                      CONSISTENCY TOKEN =                     *
  *                      >consistency_token<                     *
  *                      DSNT418I SQLSTATE   = 51015             *
  *                      SQLSTATE RETURN CODE                    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  DB2 is returning SQLCODE=-525 / SQLCODEN525 on THE PREPARE if
  the module has been precompiled on DB2 9 but runs on DB2 10
  CM8.
  

Problem conclusion

• Problem has been resolved.
  

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:

  UI14583 UI14584

Modules/Macros

•    ADBMAIN  H0IHA20J H0IHB10J
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA20 PSY UI14583

     UP14/01/30 P F401

• RB10 PSY UI14584

     UP14/01/30 P F401

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.