PH70984: CATALOG COPY FAILS ON GENERATED COLUMNS WHEN FL IS LOWER THAN CAT LVL (V13R1M505)

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When Catalog Copy is used on a subsystem with function level
  lower than V13R1M505 and catalog level is equal to or higher
  than V13R1M507 - load step fails due to missing
  OVERRIDE(NONDETERMINISTIC)
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Administration Tool for z/OS    *
  ****************************************************************
  * PROBLEM DESCRIPTION: A Catalog Copy load job fails for       *
  *                      GENERATED columns when the Db2 function *
  *                      level is lower than the catalog level.  *
  ****************************************************************
  When Catalog Copy is used on a subsystem whose Db2 function
  level is lower than V13R1M505 but catalog level is V13R1M505
  or higher, the generated load job omits the OVERRIDE
  (NONDETERMINISTIC) clause required for GENERATED columns,
  such as GEN_SESSION_USER, causing the load step to fail.
  

Problem conclusion

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

  UO07897

Modules/Macros

• ADB2CCL
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RD10 PSY UO07897

     UP26/05/21 I 1000

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.