A fix is available
APAR status
Closed as program error.
Error description
LOAD utility process the VARGRAPHIC column incorrectly when the input is delimited UTF-16 file and the data is a NULL for column.
Local fix
Do not use delimited file to load.
Problem summary
**************************************************************** * USERS AFFECTED: All DB2 9 for z/OS and DB2 10 for z/OS * * users of the LOAD utility with delimited * * input and vargraphic unicode columns. * **************************************************************** * PROBLEM DESCRIPTION: In DB2 V9 ABEND04E RC00E20005 DSNSVBK * * OFFSET09AC and in DB2 V10 ABENDS0C4 * * DSNSCON2 OFFSET15A4 when using the * * LOAD utility with delimited input * * on a unicode table with nullable * * vargraphic columns. * **************************************************************** * RECOMMENDATION: Apply corrective PTF when available * **************************************************************** A LOAD DATA FORMAT DELIMITED on a unicode table with a nullable vargraphic column abended with an ABEND04E RC00E20005 DSNSVBK +x'09AC' (V9) or an ABEND0C4 DSNSCON2 +x'15A4' (V10). The LOAD utility was interpreting the length of the nullable vargraphic field incorrectly because it was not recognizing the delimited input data, causing a storage overlay. In some cases, the overlay caused DB2 to crash with MSGDSNV086E RC00D94001. Additional Keywords: DB2OVRLAY/K DB2OVRLAY/M
Problem conclusion
Code has been modified to correctly process delimited data for nullable vargraphic columns in a unicode table.
Temporary fix
********* * HIPER * *********
Comments
APAR Information
APAR number
PM77557
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
A10
Status
CLOSED PER
PE
NoPE
HIPER
YesHIPER
Special Attention
NoSpecatt
Submitted date
2012-11-22
Closed date
2012-12-31
Last modified date
2013-02-04
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK90674 UK90675
Modules/Macros
DSNURWBG
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"},"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:
04 February 2013