A fix is available
APAR status
Closed as program error.
Error description
A map that is executed on z/OS that attempts to insert (or update) data in a DB2 table, where the data being inserted contains a NULL for any column could ABEND.
Local fix
WTXCQ - WTX00041503 PB / PB Circumvention: Design the insert and update statements so that NULLs are not sent.
Problem summary
**************************************************************** * USERS AFFECTED: All users of WebSphere Transformation * * Extender V8.4 * **************************************************************** * PROBLEM DESCRIPTION: ABEND S0C4 WHEN TRYING TO INSERT DATA * * WHERE SOME OF THE COLUMNS ARE NULL * * INTO A DB2 TABLE ON Z/OS * **************************************************************** * RECOMMENDATION: Apply this maintenance * **************************************************************** ABEND S0C4 WHEN TRYING TO INSERT DATA WHERE SOME OF THE COLUMNS ARE NULL INTO A DB2 TABLE ON Z/OS
Problem conclusion
ABEND S0C4 WHEN TRYING TO INSERT DATA WHERE SOME OF THE COLUMNS ARE NULL INTO A DB2 TABLE ON Z/OS
Temporary fix
Comments
APAR Information
APAR number
PM74315
Reported component name
WTX COMMAND SER
Reported component ID
5655R9501
Reported release
841
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2012-10-04
Closed date
2012-11-01
Last modified date
2013-01-14
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK83190
Modules/Macros
DTXCMDSV DTXPAGE DTXPROF DTX840 GTXCMDSV GTXPAGE GTXPROF GTX840
Fix information
Fixed component name
WTX COMMAND SER
Fixed component ID
5655R9501
Applicable component levels
R841 PSY UK83190
UP12/11/07 P F211
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":"SSVSD8","label":"IBM Transformation Extender"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.4.1","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}},{"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":"8.4.1","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
14 January 2013