PM57372: SQLCODEN4700 ATTEMPT TO USE NEW FUNCTION BEFORE NEW FUNCTION MODE PANEL ADB2DDF "USE DDF TO ACCESS REMOTE CATALOG" DB2 10

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS issue a message:
  DSNT408I SQLCODE = -4700, ERROR:  ATTEMPT TO USE NEW FUNCTION
  BEFORE NEW FUNCTION MODE
  DSNT418I SQLSTATE   = 56038 SQLSTATE RETURN CODE
  DSNT415I SQLERRP    = DSNHSM3D SQL PROCEDURE DETECTING ERROR
  DSNT416I SQLERRD    = 5  0  0  -1  10  507 SQL DIAGNOSTIC
  INFORMATION
  DSNT416I SQLERRD    = X'00000005'  X'00000000'  X'00000000'
  after a customer used option 'S - Use DDF to access remote
  catalog' from panel ADB2DDF 'Distributed DB2 Systems' and then
  selected option 'T - Tables, views, and aliases' on panel ADB21
  'DDF* System Catalog'.
  The local DB2 subsystem was running DB2 10 in NFM and the
  distributed DB2 subsystem was running DB2 10 in CM.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who use the Distributed Data Facility   *
  *                 (DDF) function.                              *
  ****************************************************************
  * PROBLEM DESCRIPTION: When DB2 Admin is accessing DB2 10      *
  *                      New Function Mode and the customer is   *
  *                      using the 'DD' command on panel ADB2    *
  *                      'DB2 Administration Menu' to access     *
  *                      location DB2 10 Compatibility Mode,     *
  *                      the catalog navigation on location DB2  *
  *                      10 Compatibility Mode will cause a      *
  *                      SQLCODE=-4700 / SQLCODEN4700 error:     *
  *                                                              *
  *                      DSNT408I SQLCODE = -4700,               *
  *                      ERROR:  ATTEMPT TO USE NEW              *
  *                      FUNCTION BEFORE NEW                     *
  *                      FUNCTION MODE                           *
  *                      DSNT418I SQLSTATE   =                   *
  *                      56038 SQLSTATE RETURN                   *
  *                      CODE                                    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  An SQLCODE=- 4700 / SQLCODEN4700 is received when running
  dynamic SQL SELECTs from DB2 10 New Function Mode to a DB2 10
  Compatibility Mode location.
  

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:

  UK77288

Modules/Macros

•    ADBMAIN
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK77288

     UP12/03/25 P F203

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.