PM75788: DB2 ADMINISTRATION TOOL FOR Z/OS V10.1 MIGRATE TABLESPACE ENDS WITH RC8 COLUMN "ID" IS OMITTED DURING LOAD

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 Administration Tool for z/OS V10.1 Migrate Tablespace ends
  with RC8 COLUMN 'ID' is omitted during LOAD
  .
  msgDSNU323I  -ssid ddd hh:mm:ss.tt DSNURWUF - COLUMN 'ID' IS
  OMITTED
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who use the Migrate (MIG) function to   *
  *                 migrate a table space containing a table     *
  *                 with an identity column and use a TEMPLATE   *
  *                 to load the data on panel ADB28M 'Migrate    *
  *                 Parameters'.                                 *
  ****************************************************************
  * PROBLEM DESCRIPTION: When using the MIG function to migrate  *
  *                      a table space containing a table with   *
  *                      an identity column, and specifying      *
  *                      'YES' for the 'Generate template        *
  *                      Statements' on panel ADB28M 'Migrate    *
  *                      Parameters', the job fails with a RC8   *
  *                      / return code 8 and the following       *
  *                      messages:                               *
  *                                                              *
  *                      DSNU323I  #ssid  DSNURWUF -             *
  *                      COLUMN ccc IS OMITTED                   *
  *                                                              *
  *                      DSNU012I - DSNUGBAC -  UTILITY          *
  *                               EXECUTION TERMINATED,          *
  *                               HIGHEST RETURN                 *
  *                               CODE = rr                      *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When using the MIG function to migrate a table space containing
  a table with an identity column, and specifying 'YES' for the
  'Generate template Statements' on panel ADB28M 'Migrate
  Parameters', the job fails with a RC8 / return code 8 and the
  following messages:
  
  DSNU323I csect-name COLUMN ccc IS OMITTED
  
  DSNU012I csect-name UTILITY
           EXECUTION TERMINATED,
           HIGHEST RETURN
           CODE = rr
  

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:

  UK83822 UK83823

Modules/Macros

•    ADB28MC
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK83822

     UP12/11/30 P F211

• RA20 PSY UK83823

     UP12/11/30 P F211

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.