A fix is available
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