PM79448: UNLOAD DELIMITED UTILITY USES THE INVALID DEFAULT DELIMITER VALUES FOR EBCDIC DBCS/MBCS TABLES.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When UNLOAD a table who has MBCS columns, if DELIMITED keyword
  is specified, but none of the delimiters values are specified
  explicitly, the default delimiters values will be used :
  COLDEL  X'6B'  CHARDEL X'7F'  DECPT  X'4B'
  
  UNLOAD runs well without problem. However, when the customer
  runs LOAD utility to reload these data back to this table, or a
  similar table, the LOAD job will fail with:
  DSNU1141I   337 23:15:39.79 DSNURILD - INVALID DELIMITER
  CHARACTER ','  (X'6B')
  
  It is because the maximum allowable delimiter values for EBCDIC
  DBCS/MBCS is X'3F', as mentioned the Utility Guide and
  Reference.
  
  The customer would like UNLOAD utility to check the default
  delimiter values in this situation, and issue message to
  terminate itself.
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 9 for z/OS and DB2 10 for z/OS       *
  *                 utility users of UNLOAD DELIMITED            *
  ****************************************************************
  * PROBLEM DESCRIPTION: UNLOAD DELIMITED of a table with EBCDIC *
  *                      MBCS without specifying any character   *
  *                      delimiters, generates invalid default   *
  *                      delimiters.                             *
  ****************************************************************
  * RECOMMENDATION: Apply corrective PTF when available          *
  ****************************************************************
  An UNLOAD DELIMITED utility was run on a table with an encoding
  scheme of EBCDIC MBCS.  The UNLOAD statement did not include any
  character delimiter values (CHARDEL COLDEL DECPT), causing the
  unloaded data to include default character delimiters.  A
  subsequent LOAD utility, using the generated SYSREC and SYSPUNCH
  from the UNLOAD failed with MSGDSNU1141I - INVALID DELIMITER
  CHARACTER ',' (X'6B') and ended with RC8.
  
  The default character delimiter values are not valid for
  EBCDIC MIXED and DBCS tables.  If no character delimiters
  are specified on the UNLOAD statement, UNLOAD will now issue
  MSGDSNU1141I - INVALID DELIMITER CHARACTER and end with RC8.
  
  For EBCDIC MIXED or DBCS tables, user specified delimiters
  must be x'40' or below for CHARDEL and COLDEL and x'4B' or
  below for DECPT.
  

Problem conclusion

• The UNLOAD utility has been modified to issue a DSNU1141I
  message and end with RC8 if defaulted delimiter values
  are invalid for the target table.
  

Temporary fix

Comments

• ž**** PE13/09/27 FIX IN ERROR. SEE APAR PM97985  FOR DESCRIPTION
  

APAR Information

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

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

  UK92381 UK92382

Modules/Macros

• DSNURILD DSNUULIA
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UK92381

     UP13/03/23 P F303

• R910 PSY UK92382

     UP13/03/23 P F303

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.