PM04911: 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 VAR
  columns is not adjusted for the increase in record
  size.  The LOAD utility detects a row too large for
  the page size.
  

Problem conclusion

• Object Compare is changed to correctly handle this
  situation.
  

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:

Modules/Macros

•    ADBCDTS
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R720 PSY UK54756

     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.