IBM Support

PH37166: POSSIBLE S0C4 DURING SQL GENERATION WHEN XML DATA WITH CCSID EBCDIC IS REPORTED

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • This APAR includes fix for "Possible S0C4 during SQL generation
    when XML data with CCSID EBCDIC is reported"
    and some other minor fixes:
    1) Fixed column reordering for delimited output or fixed
    external format when Load data into Db2 is selected.
    2) Fixed HSM recalls wait time parameter for JSON file
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of Db2 Log Analysis Tool for z/OS      *
    ****************************************************************
    * PROBLEM DESCRIPTION: 1) Fix for "Possible S0C4 during SQL    *
    *                      generation when XML data with CCSID     *
    *                      EBCDIC is reported"                     *
    *                      2) Fixed column reordering for          *
    *                      delimited output or fixed external      *
    *                      format when Load data into Db2          *
    *                      is selected.                            *
    *                      3) Fixed HSM recalls wait time          *
    *                      parameter for JSON file generation.     *
    ****************************************************************
    * RECOMMENDATION: Apply the PTF                                *
    ****************************************************************
    Possible S0C4 during SQL generation when XML data with CCSID
    EBCDIC is reported
    

Problem conclusion

  • Apply the PTF
    

Temporary fix

Comments

APAR Information

  • APAR number

    PH37166

  • Reported component name

    DB2 LOG ANALYSI

  • Reported component ID

    5655E6601

  • Reported release

    350

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2021-05-12

  • Closed date

    2021-07-02

  • Last modified date

    2021-08-09

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

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

    UI76184

Modules/Macros

  • ALA#LCLF ALA#LDSN ALABSQL  ALACLDEL ALAFMAIN ALAFR2   ALAJSON
    ALALLB   ALARXML  ALASETUP ALAUNI
    

Fix information

  • Fixed component name

    DB2 LOG ANALYSI

  • Fixed component ID

    5655E6601

Applicable component levels

  • R350 PSY UI76184

       UP21/07/07 P F107

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.

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSZJXP","label":"DB2 Tools for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"3.5.0"}]

Document Information

Modified date:
10 August 2021