IBM Support

PM97985: UNLOAD UTILITY NO LONGER ALLOWS DEFAULT DELIMITER VALUE AFTER PM79448 UK92381 AND ISSUES MSGDSNU1141I 13/09/30 PTF PECHANGE

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • UNLOAD DELIMITED utility returns DSNU1141I after PM79448 UK92381
    was applied for EBCDIC MBCS and DBCS encoding scheme when
    DEFAULT delimiter was used.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All DB2 9 for z/OS utility users of UNLOAD   *
    *                 DELIMITED with PM79448 (UK92382) applied.    *
    *                 All DB2 10 for z/OS utility users of UNLOAD  *
    *                 DELIMITED with PM79448 (UK92381) applied.    *
    *                 All DB2 11 for z/OS utility users of UNLOAD  *
    *                 DELIMITED                                    *
    ****************************************************************
    * PROBLEM DESCRIPTION: After applying the PTF for PM79448      *
    *                      (UK92381), UNLOAD DELIMITED of an       *
    *                      EBCDIC table containing DBCS/MBCS       *
    *                      data and using the default delimiters   *
    *                      correctly issues MSGDSNU1141I - INVALID *
    *                      DELIMITER CHARACTER ',' (X'6B') and     *
    *                      ends with RC8                           *
    *                                                              *
    *                      As they are default delimiters, UNLOAD  *
    *                      should allow them to be used            *
    *                      successfully.                           *
    ****************************************************************
    * RECOMMENDATION: Apply corrective PTF when available          *
    ****************************************************************
    After applying the PTF for PM79448 (UK92381), UNLOAD DELIMITED
    of an EBCDIC table containing DBCS and/or MBCS data and using
    the default delimiters, correctly ends with RC8 after issuing
    DSNU1141I - INVALID DELIMITER CHARACTER ',' (X'6B') for an
    invalid column delimiter.
    
    PM79448 corrected a code error so that invalid delimiters, even
    if a default value, would cause the UNLOAD to fail which would
    match what was documented in the Utilities Guide and Reference.
    However, this caused a change of behavior which affected some
    customers for which the UNLOAD was working.
    
    The same error would be expected if the column delimiter was
    valid but the default character delimiter '"' (x'7F') was used.
    
    As they are default delimiters, UNLOAD should allow them to be
    used successfully.
    
    This same outcome would occur in DB2 9 with PM79448 (UK92382)
    applied and in DB2 11.
    

Problem conclusion

  • The fix for PM79448 has been removed and UNLOAD DELIMITED code
    has been changed to allow the default value for the column
    delimiter (x'6B') and for the character delimiter (X'7F') when
    unloading from an EBCDIC table containing MBCS and/or DBCS
    columns and defaulting to the encoding scheme of the table for
    the output.
    
    
    As such, the following document changes will be made to the
    Utility Guide and Reference.
    
    A. DB2 9 for z/OS
    
    1. Under the chapter for LOAD, Table 36. Maximum delimiter
       values for different encoding schemes:
    
      Encoding scheme       Maximum allowable value
      EBCDIC SBCS           None
    | EBCDIC DBCS/MBCS      X'3F' (X'7F', X'4B', X'6B' also allowed)
      ASCII/Unicode SBCS    None
      ASCII/Unicode MBCS    X'7F'
    
    2. Under the chapter for UNLOAD, Table 125. Maximum delimiter
       values for different encoding schemes:
    
      Encoding scheme       Maximum allowable value
      EBCDIC SBCS           None
    | EBCDIC DBCS/MBCS      X'3F' (X'7F', X'4B', X'6B' also allowed)
      ASCII/Unicode SBCS    None
      ASCII/Unicode MBCS    X'7F'
    
    
    B. DB2 10 for z/OS
    
    1. Under the chapter for LOAD, Table 37. Maximum delimiter
       values for different encoding schemes:
    
      Encoding scheme       Maximum allowable value
      EBCDIC SBCS           None
    | EBCDIC DBCS/MBCS      X'3F' (X'7F', X'4B', X'6B' also allowed)
      ASCII/Unicode SBCS    None
      ASCII/Unicode MBCS    X'7F'
    
    2. Under the chapter for UNLOAD, Table 127. Maximum delimiter
       values for different encoding schemes:
    
      Encoding scheme       Maximum allowable value
      EBCDIC SBCS           None
    | EBCDIC DBCS/MBCS      X'3F' (X'7F', X'4B', X'6B' also allowed)
      ASCII/Unicode SBCS    None
      ASCII/Unicode MBCS    X'7F'
    
    
    C. DB2 11 for z/OS
    
    1. Under the chapter for LOAD, Table 36. Maximum delimiter
       values for different encoding schemes:
    
      Encoding scheme       Maximum allowable value
      EBCDIC SBCS           None
    | EBCDIC DBCS/MBCS      X'3F' (X'7F', X'4B', X'6B' also allowed)
      ASCII/Unicode SBCS    None
      ASCII/Unicode MBCS    X'7F'
    
    2. Under the chapter for UNLOAD, Table 125. Maximum delimiter
       values for different encoding schemes:
    
      Encoding scheme       Maximum allowable value
      EBCDIC SBCS           None
    | EBCDIC DBCS/MBCS      X'3F' (X'7F', X'4B', X'6B' also allowed)
      ASCII/Unicode SBCS    None
      ASCII/Unicode MBCS    X'7F'
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM97985

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    A10

  • Status

    CLOSED PER

  • PE

    YesPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-09-27

  • Closed date

    2013-12-24

  • Last modified date

    2014-02-05

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

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

    UI13841 UI13842 UI13843

Modules/Macros

  • DSNURILD DSNUULIA DSNUULVA
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RA10 PSY UI13841

       UP14/01/10 P F401 {

  • RB10 PSY UI13842

       UP14/01/10 P F401 {

  • R910 PSY UI13843

       UP14/01/10 P F401 {

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.

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.1","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
05 February 2014