PI18149: DB2 ADMIN TOOL FOR Z/OS MIGRATE FUNCTION TRUNCATES THE COLCARDDATA COLUMN

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 Administration Tool for z/OS Migrate function is truncating
  COLCARDDATA at 124 characters. This can cause DB2 for z/OS
  utilities to abend, for example a DB2 Reorg can abend with an
  S0CC abend.
  DB2 COMPID 5740XYR00.
  

Local fix

• Please contact IBM Service to discuss this APAR if you see the
  symptoms.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who want to Migrate (MIG) catalog       *
  *                 statistics.                                  *
  ****************************************************************
  * PROBLEM DESCRIPTION: The MIG function truncated column       *
  *                      COLCARDATA to 124 characters            *
  *                      for the DB2 catalog table               *
  *                      SYSIBM.SYSCOLSTATS.  It caused          *
  *                      a DB2 DSNUTIL_S0CC abend when           *
  *                      performing an online REORG.             *
  *                                                              *
  *                      "DSNU017I    057 >time_stamp<           *
  *                      DSNUGBAC -                              *
  *                      UTILITY DATA BASE SERVICES              *
  *                      MEMORY EXECUTION ABENDED,               *
  *                      REASON=X'00CC'  "                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The statistics data is truncated for column COLCARDATA of the
  DB2 catalog table SYSIBM.SYSCOLSTATS.
  

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:

  UI19982 UI19983

Modules/Macros

•    ADB2RES
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA20 PSY UI19982

     UP14/07/30 P F407

• RB10 PSY UI19983

     UP14/07/30 P F407

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.