PI16202: LASTUSED COLUMN FOR TABLE SYSPACKAGE WAS NOT REMOVED WHEN DOING CATALOG COPY WITH CROSS LOADER.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• LASTUSED column for table SYSPACKAGE should be removed performin
  g Catalog Copy for DB2 V9 CM/ENFM/NFM and V10 CM8/ENFM8/CM9/
  ENFM9, and should be kept when in DB2 V10 NFM. When using
  load method CROSS LOADER, the LASTUSED column is not removed.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS and DB2 Object Comparison Tool for      *
  *                 z/OS who use the Catalog Copy function.      *
  ****************************************************************
  * PROBLEM DESCRIPTION: The Catalog Copy function does not      *
  *                      remove the LASTUSED column for table    *
  *                      SYSIBM.SYSPACKAGE in the declared       *
  *                      cursor when the DB2 version is          *
  *                      prior to DB2 10 New Function Mode       *
  *                      (NFM) and choosing option 'L - LOAD     *
  *                      from Cursor' for field 'Catalog Copy    *
  *                      Method' on panel ADB2CCJ 'Create        *
  *                      Catalog Copy and Bind Batch Jobs'.      *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The Catalog Copy function does not remove the LASTUSED
  column for table SYSIBM.SYSPACKAGE in the declared cursor
  when the DB2 version is prior to DB2 10 New Function Mode
  (NFM).
  

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:

  UI23456 UI23457

Modules/Macros

•    ADB2CCL
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA20 PSY UI23456

     UP14/12/02 P F412

• RB10 PSY UI23457

     UP14/12/02 P F412

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.