PH33848: CATALOG COPY: LOAD STATEMENTS FOR TABLES MULTI-TABLE TABLE SPACE GENERATED WRONG ORDER CAUSING CATALOG COPY SIZE INCREASE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When generating jobs for catalog copy, and selecting Type C and
  Catalog Copy Method L, the load statements for the tables of a
  multi-table table space are listed incorrectly.  This results in
  incorrect generation of RESUME YES versus NO clauses.
  
  For tables within a multi-table table space, the first table
  should have a load statement generated with RESUME NO REPLACE,
  and the remaining should have RESUME YES.
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the Db2 Administration Tool for     *
  *                 z/OS Catalog Copy function.                  *
  ****************************************************************
  * PROBLEM DESCRIPTION: When loading from a cursor, statements  *
  *                      for tables in a multi-table table space *
  *                      are listed incorrectly, causing the     *
  *                      catalog copy size to unexpectedly       *
  *                      increase.                               *
  ****************************************************************
  During catalog copy, when loading from a cursor, the statements
  are sorted by table name. For tables within a multi-table table
  space, their corresponding LOAD statement might therefore be
  generated with incorrect RESUME and REPLACE parameters.
  
  These statements could lead to inefficient use of space,
  depending on the table names. The fix in this scenario is to
  sort first by table space name, and then by table name.
  

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:

  UI75680

Modules/Macros

• ADB2CCJ
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI75680

     UP21/06/05 P F106

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.