PK94159: DSNU310I DSNURCON DISCARDED CONVERSION ERROR OR DSNU1218I DSNUULIA LOGICAL RECORD LENGTH OF OUTPUT RECORD EXCEEDED

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Object Comparison Tool for z/OS APPLY jobs created when
  working with tables with LONG VARCHAR columns may end RC04 with
  a message:
  DSNU310I  aaaaa- DSNURCON - RECORD (1) WILL BE DISCARDED DUE TO
  'aaa' CONVERSION ERROR FOR aaa.aaa
  or end RC08 with a message:
  DSNU1218I aaaaa- DSNUULIA - LOGICAL RECORD LENGTH OF OUTPUT
  RECORD EXCEEDED THE  LIMIT FOR TABLE aaa.aaa
  as the NOPAD option is not used.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Object Comparison               *
  *                 Tool for z/OS who have DB2 tables            *
  *                 that contain LONG VARCHAR or                 *
  *                 LONG VARGRAPHIC columns.                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: If the following conditions are         *
  *                      true:                                   *
  *                      1) The table contains LONG              *
  *                           VARCHAR or LONG                    *
  *                           VARGRAPHIC columns.                *
  *                      2) The table is changed so              *
  *                           that the amount of space           *
  *                           required for other columns         *
  *                           is increased.                      *
  *                      3) The change is implemented            *
  *                           by DROP/CREATE without             *
  *                           conversion.                        *
  *                                                              *
  *                      The job will fail in the LOAD utility   *
  *                      with a MSGDSNU1218I.                    *
  ****************************************************************
  * RECOMMENDATION: Apply The PTF.                               *
  ****************************************************************
  The number of bytes allocated to LONG VARCHAR
  columns is not adjusted for the increase in record
  size. The LOAD utility detects a row too large for
  the page size.
  

Problem conclusion

• DB2 Object Comparison Tool is changed to
  correctly handle this situation.
  

Temporary fix

• *********
  * HIPER *
  *********
  

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Modules/Macros

•    GOC2CMF  GOC2CMT
  

Fix information

• Fixed component name

  DB2 OBJECT COMP

• Fixed component ID

  5697G6400

Applicable component levels

• R720 PSY UK54758

     UP10/03/04 P F003

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.