PH35217: LOAD COMMAND UNDULY SPECIFIES MORE THAN ONE BYTE SEPARATOR OR DELIMITER

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• (will not be fixed in HPU 4.3) The LOAD control cards generated
  for an unload in delimited format unduly specify a separator or
  a delimiter longer than one character.
  
  Delimited format stands for either of the following formats:
  - COMMA-DELIMITED from FastUnload
  - CSV from UNLOAD PLUS
  - DELIMITED for the Db2 UNLOAD utility
  
  The issue occurs if the unload specifies, as a separator or
  delimiter, a value longer than one byte in hexadecimal
  representation. By design, such unsupported value is tolerated
  as follows. Db2 HPU takes only the first byte of the specified
  separator or delimiter into account and reports the situation by
  issuing the following message: INZU112W STRING IN ITEM STARTING
  AT (x,y) IS TOO LONG AND IS TRUNCATED. Db2 HPU unloads the data
  using the first byte of the specified values as actual separator
  and delimiter accordingly. The corresponding separator or
  delimiter in the LOAD command should be consistent with the
  truncated values used in the unloaded data and should not be
  more than one character long.
  

Local fix

• replace the unsupported value for the separator or delimiter by
  the first byte of this value.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 High Performance Unload         *
  *                 for z/OS                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: The LOAD control cards generated for an *
  *                      unload in delimited format unduly       *
  *                      specify a separator or a delimiter      *
  *                      longer than one character.              *
  *                                                              *
  *                      Delimited format stands for either of   *
  *                      the following formats:                  *
  *                      - COMMA-DELIMITED from FastUnload       *
  *                      - CSV from UNLOAD PLUS                  *
  *                      - DELIMITED for the Db2 UNLOAD utility  *
  *                                                              *
  *                      The issue occurs if the unload          *
  *                      specifies, as a separator or delimiter, *
  *                      a value longer than one byte in         *
  *                      hexadecimal representation. By design,  *
  *                      such unsupported value is tolerated as  *
  *                      follows. Db2 HPU takes only the first   *
  *                      byte of the specified separator or      *
  *                      delimiter into account and reports the  *
  *                      situation by issuing the following      *
  *                      message: INZU112W STRING IN ITEM        *
  *                      STARTING AT (x,y) IS TOO LONG AND IS    *
  *                      TRUNCATED. Db2 HPU unloads the data     *
  *                      using the first byte of the specified   *
  *                      values as actual separator and          *
  *                      delimiter accordingly.                  *
  *                      The corresponding separator or          *
  *                      delimiter in the LOAD command should be *
  *                      consistent with the truncated values    *
  *                      used in the unloaded data and should    *
  *                      not be more than one chacter long.      *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF                                *
  ****************************************************************
  LOAD command unduly specifies more than one byte separator or
  delimiter
  

Problem conclusion

• Code has been changed to fix this problem
  

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

• INZCHECK INZCRX10 INZCRXSM INZCRXSQ INZTPMEM INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R510 PSY UI74571

     UP21/03/30 P F103

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.