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

A fix is available

Subscribe

You can track all active APARs for this component.

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 number

    PM79448

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-12-18

  • Closed date

    2013-03-08

  • Last modified date

    2013-12-24

  • 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.



Rate this page:

(0 users)Average rating

Document information


More support for:

DB2 for z/OS

Software version:

910

Reference #:

PM79448

Modified date:

2013-12-24

Translate my page

Machine Translation

Content navigation