IBM Support

LI74666: 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 Data Server Driver for JDBC and SQLJ (also  *
    * called the JCC driver) who connect to a sysplex workload     *
    * balancing environment on zOS with members of a data sharing  *
    * group that are in different LPARs (logical partitions).      *
    ****************************************************************
    * 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.                                         *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * .                                                            *
    ****************************************************************
    

Problem conclusion

  • Problem was first fixed in Version 9.5 Fix Pack 6
    

Temporary fix

Comments

APAR Information

  • APAR number

    LI74666

  • Reported component name

    DB2 UDE ESE LIN

  • Reported component ID

    5765F4104

  • Reported release

    950

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-06-03

  • Closed date

    2011-01-24

  • Last modified date

    2011-01-27

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

    LI74664

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

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":"950","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
17 October 2021