PI17881: CATALOG COPY BIND JOBS DSNX200I SQLCODEN204 TOKENS=<SCHEMA>.XSRO BJECTS ( RELATED TO DB2-SUPPLIED XSR STORED PROCEDURES / XML )

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS' Catalog Copy does not
  support the SYSIBM.XSROBJECTS table resulting in a message:
  DSNX200I  #DSNA- BIND SQL ERROR
             USING <userid> AUTHORITY
             PLAN=(NOT APPLICABLE)
             DBRM=ADB2REM
             STATEMENT=11338
             SQLCODE=-204
             SQLSTATE=42704
             TOKENS=C717086.XSROBJECTS
             CSECT NAME=DSNXOTL
             RDS CODE=-500
  being issued by the BIND step.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who use the Catalog Copy function.      *
  ****************************************************************
  * PROBLEM DESCRIPTION: The Catalog Copy function does not      *
  *                      support the DB2 catalog table           *
  *                      SYSIBM.XSROBJECTS, resulting in         *
  *                      the following SQLCODE=-204 /            *
  *                      SQLCODEN204 error message:              *
  *                                                              *
  *                      DSNX200I  #>ssid<- BIND SQL ERROR       *
  *                                USING >userid< AUTHORITY      *
  *                                PLAN=(NOT APPLICABLE)         *
  *                                DBRM=ADB2REM                  *
  *                                STATEMENT=11338               *
  *                                SQLCODE=-204                  *
  *                                SQLSTATE=42704                *
  *                                TOKENS=>schema<.XSROBJECTS    *
  *                                CSECT NAME=DSNXOTL            *
  *                                RDS CODE=-500                 *
  *                                                              *
  *                      being issued in the BIND step.          *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The Catalog Copy function does not support database DSNXSR.
  

Problem conclusion

• Problem has been resolved.
  The Catalog Copy function now supports database DSNXSR.
  

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:

  UI22285 UI22286

Modules/Macros

•    ADB2CC   ADB2CCJ  ADB2CCL  ADB2CCU  ADB2CCV
  ADB2GEN
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA20 PSY UI22285

     UP14/10/22 P F410

• RB10 PSY UI22286

     UP14/10/22 P F410

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.