IBM Support

IC93139: CLI OR .NET APPLICATION WITH PUREQUERY CLIENT OPTIMIZATION MAY THROW SQL0805N WHEN USING FORCESINGLEBINDISOLATION OPTION.

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • When forceSingleBindIsolation is set to TRUE, it will create DB2
    package for only a single isolation level. It will not have
    number appended to the name of the package to indicate the
    isolation level. However CLI or .NET application as if oblivious
    to forceSingleBindIsolation option, will try to look for
    packages at multiple isolation levels, instead of finding all
    the statements in single package. This may result in SQL0805N
    package not found error.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Users using PureQuery Client Optimization                    *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * First fixed in DB2 V9.7 Fixpack 9                            *
    ****************************************************************
    

Problem conclusion

  • First fixed in DB2 V9.7 Fixpack 9
    

Temporary fix

  • Do not use forceSingleBindIsolation with PQR. It will generate
    packages for each isolation level. Manually remove packages for
    all other isolation levels except the one which you want to use.
    

Comments

APAR Information

  • APAR number

    IC93139

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-06-17

  • Closed date

    2013-12-16

  • Last modified date

    2013-12-16

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

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

    IC95044 IC95045

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSN

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC93139

Modified date: 16 December 2013