PH65051: CATALOG COPY FAILS DURING LOAD FOR TABLES WITH GENERATED EXPRESSION COLUMNS

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When catalog copy is used on a V13R1M505 or higher subsystem,
  LOAD fails due to being unable to resolve GENERATED ALWAYS AS
  (session_user) column.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Administration Tool for z/OS    *
  *                 and Db2 Object Comparison Tool for z/OS      *
  ****************************************************************
  * PROBLEM DESCRIPTION: This APAR addresses problems with the   *
  *                      catalog copy functionality.             *
  ****************************************************************
  1. When using catalog copy on a subsystem with Db2 13 function
  level 505 or higher, the LOAD utility fails due to its inability
  to resolve generated expression columns, both using UNLOAD
  with LOAD and load from a cursor.
  2. When using catalog copy, if 'Catalog Copy Method' is set to
  'L' and XML schema repository catalog tables exist in a single
  table space, the LOAD utility fails due to incorrect generation
  of LOAD statements.
  

Problem conclusion

• The problems have 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:

  UO02401

Modules/Macros

• ADB28MC  ADB2CC   ADB2CCL  ADB2CDC  ADB2CM1  ADB2CM2  ADB2CM3
  ADB2CME  ADB2CMF  ADB2CMP  ADB2CMR  ADB2CMS  ADB2CMT  ADB2CMU
  ADB2DEP  ADB2FMM  ADB2FMP  ADB2GEN  ADB2RE   ADB2REC  ADB2REE
  ADB2REG  ADB2REH  ADB2REM  ADB2REP  ADB2RER  ADB2RES  ADB2RET
  ADB2REU  ADB2REY  ADB2REZ  ADB2RGC  ADB2RS   ADB2RSD  ADB2WCL
  ADB2WVL  ADBCP    ADBGDDL  ADBGMP   ADBGMSP
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RD10 PSY UO02401

     UP25/03/13 P F503

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.