IBM Support

IT39056: IMPROPER SPECIAL REGISTER CURRENT SCHEMA CAUSING SQLSYNTAXERROREXCEPTION

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error description

  • Type4 connectivity: With heavy transaction load and in a sysplex
    enabled environment current schema special registers
    are not replayed properly when connected to Db2 on z/OS V12 and
    causes SqlSyntaxErrorException.
    
    In a sysplex environment during the WLB, there is transport
    switch that happens to distribute the workload across members.
    Driver replays the special register values to keep the
    connection values same across the members during execution.
    Under heavy load, some time the replay was not proper causing
    wrong special register replay. In such scenario, when the
    current schema is replayed wrongly, it can cause a
    SqlSyntaxErrorException from server during SQL execution.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Db2 JCC Users using WLB against Db2 on z/os V12              *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * upgrade to Db2 11.1.4.7                                      *
    ****************************************************************
    

Problem conclusion

  • Problem fixed in Db V11.1.4.7
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT39056

  • Reported component name

    DB2 CONNECT

  • Reported component ID

    DB2CONNCT

  • Reported release

    B10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2021-11-12

  • Closed date

    2022-01-10

  • Last modified date

    2022-01-10

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

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

Fix information

  • Fixed component name

    DB2 CONNECT

  • Fixed component ID

    DB2CONNCT

Applicable component levels

  • RB10 PSN

       UP

[{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M"},"Platform":[{"code":"PF054","label":"z Systems"}],"Version":"11.1"}]

Document Information

Modified date:
04 May 2022