A fix is available
APAR status
-
Closed as program error.
Error description
-
UNLOAD XML with SPANNED YES and HEADER NONE generates an invalid SYSREC. It will cause the LOAD with SPANNED YES fails with DSNU338I message.
Local fix
-
N.A.
Problem summary
-
**************************************************************** * USERS AFFECTED: All DB2 10 for z/OS and DB2 11 for z/OS * * users of UNLOAD SPANNED YES FROM TABLE with * * option HEADER NONE * **************************************************************** * PROBLEM DESCRIPTION: MSGDSNU338I issued with LOAD FORMAT * * SPANNED YES using SYSREC data set * * generated by UNLOAD SPANNED YES FROM * * TABLE with option HEADER NONE for a * * table with XML columns. * **************************************************************** * RECOMMENDATION: Apply corrective PTF when available. * **************************************************************** A LOAD FORMAT SPANNED YES utility issued message DSNU338I (INVALID COLUMN SPECIFICATION) and abended with ABEND04E RC00E40323 when using a SYSREC data set generated by UNLOAD SPANNED YES FROM TABLE with option HEADER NONE for a table with XML columns. The problem occurred when user tried to unload only the XML columns, so that the first column in the field specification of the UNLOAD statement was an XML column. UNLOAD SPANNED YES incorrectly positioned the data in the SYSREC when HEADER NONE was specified and XML column was the first column to unload. The problem can also happen with tables with LOB columns. Additional unpredictable symptoms, such as MSGDSNU334I (DSNU334I INPUT FIELD INVALID), could occur.
Problem conclusion
-
UNLOAD SPANNED YES has been modified to correctly position the data in the SYSREC data set when HEADER NONE is specified.
Temporary fix
Comments
APAR Information
-
APAR number
PI24174
-
Reported component name
DB2 OS/390 & Z/
-
Reported component ID
5740XYR00
-
Reported release
A10
-
Status
CLOSED PER
-
PE
NoPE
-
HIPER
NoHIPER
-
Special Attention
NoSpecatt / Xsystem
-
Submitted date
2014-08-20
-
Closed date
2014-11-16
-
Last modified date
2015-01-02
-
APAR is sysrouted FROM one or more of the following:
-
APAR is sysrouted TO one or more of the following:
UI23104 UI23105
Modules/Macros
-
DSNUULMB
Fix information
-
Fixed component name
DB2 OS/390 & Z/
-
Fixed component ID
5740XYR00
Applicable component levels
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"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
30 March 2021