IBM Support

PM74326: ABEND S0C4 WHEN TRYING TO INSERT DATA WHERE SOME OF THE COLUMNS ARE NULL INTO A DB2 TABLE ON Z/OS

A fix is available

Subscribe

You can track all active APARs for this component.

 

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

    PM74326

  • Reported component name

    WTX APP PGM ZOS

  • Reported component ID

    5655R9502

  • Reported release

    842

  • 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:

    PM74308

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

    UK83191

Modules/Macros

  • DTXCTBL  DTXCTST  DTXCXIT  DTXDD58  DTXDPAXB
    DTXIMQS  DTXIMS   DTXIMSIT DTXISQL  DTXI48DA DTXI48IN DTXI48UC
    DTXKTST  DTXKXIT  DTXLC22  DTXMAPLD DTXMPULD DTXMSG22 DTXPSB1
    DTXPSB2  DTXSDK   DTXSDK64 DTXTEST  DTXTESTA DTXTESTC DTXTESTP
    DTX4C58  DTX840AD DTX840CI DTX840DB DTX840ED DTX840IC DTX840IK
    DTX840IU DTX840KB DTX840KC DTX840KD DTX840KI DTX840KL DTX840KM
    DTX840KP DTX840KS DTX840KU DTX840KZ DTX840LD DTX840ML DTX840MP
    DTX840NM DTX840RK DTX840RL DTX840RM DTX840RS DTX840RU DTX840RZ
    DTX840TB DTX840TK DTX840XB DTX840XC DTX840XD DTX840XK DTX840XL
    DTX840XM DTX8404C DTX8404M DTX8404S DTX8405C DTX8405L DTX8405M
    DTX8405N DTX8405S GTXDRIVE GTXSDK   GTXTESTA
    

Fix information

  • Fixed component name

    WTX APP PGM ZOS

  • Fixed component ID

    5655R9502

Applicable component levels

  • R842 PSY UK83191

       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","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","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
14 January 2013