IBM Support

LI74664: WITH DATA SHARING GROUP MEMBERS ON DIFFERENT ZOS LPARS, THE JCC PROPERTY CURRENTSCHEMA MIGHT NOT WORK, SO YOU GET ERROR SQL0204

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • You intermittently get SQL error -204 (SQL0204) with the
    Type 4 JCC driver
    (Java Common Client, or IBM DB2 Driver for JDBC and SQLJ)
    when you use the JCC property CurrentSchema to specify a
    schema name, and you have a sysplex workload balancing
    environment on zOS with members of a data sharing group that are
    in different LPARs (logical partitions).
    The error SQL0204 happens when the CurrentSchema property does
    not take effect, so that SQL is run without the correct schema
    name.
    

Local fix

Problem summary

  • Users affected:
    Users of the IBM DB2 Driver for JDBC and SQLJ Type 4 driver
    
    
    Problem Description:
    You intermittently get SQL error -204 (SQL0204) with the
    Type 4 JCC driver
    (Java Common Client, or IBM DB2 Driver for JDBC and SQLJ)
    when you use the JCC property CurrentSchema to specify a
    schema name, and you have a sysplex workload balancing
    environment on zOS with members of a data sharing group that are
    in different LPARs (logical partitions).
    The error SQL0204 happens when the CurrentSchema property does
    not take effect, so that SQL is run without the correct schema
    name.
    

Problem conclusion

  • First fixed in DB2 9 Fix Pack 8
    

Temporary fix

Comments

APAR Information

  • APAR number

    LI74664

  • Reported component name

    DB2 UDE ESE LIN

  • Reported component ID

    5765F4104

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-06-02

  • Closed date

    2009-11-09

  • Last modified date

    2009-11-09

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

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

    LI74666 IC61403

Fix information

  • Fixed component name

    DB2 UDE ESE LIN

  • Fixed component ID

    5765F4104

Applicable component levels

  • R910 PSN

       UP

  • R950 PSN

       UP

[{"Business Unit":{"code":"BU053","label":"Cloud \u0026 Data Platform"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"910","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
17 October 2021