IBM Support

JR27835: DB2 CLI DRIVER NEEDS TO ISSUE AN IMPLICIT COMMIT AFTER SENDING S ET OPERATIONS FOLLOWING A CONNECT OPERATION.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • If a DB2 CLI (Call Level Interface) keyword such as CURRENTFUNCT
    IONPATH or CURRENTSCHEMA is used, then the DB2 CLI driver will s
    end the associated "SET CURRENT XXX" operation to the target ser
    ver implicitly after a Connection.   Currently the DB2 CLI drive
    r does not send a COMMIT request after the SET operations.
    .
    If the server is z/DB2 then this could cause an idle thread, sin
    ce the thread is waiting for the next statement in the transacti
    on.  If the application does not send another SQL statement or
    does not send an SQLDisconect call (which could happen if applic
    ation connection pooling is used), then on z/DB2 this could caus
    e the thread to hang until the idle thread timeout kicks in.
    

Local fix

  • The application can issue its own explicit COMMIT request after
    a connection is made.
    

Problem summary

  • Users Affected:  Application developers using CLI driver, or
    z/DB2 DBA's.
    Problem Description:  When a certain keyword like
    CURRENTFUNCTIONPATH, CURRENTSQLID or CURRENTSCHEMA is used with
    the CLI driver, the CLI driver will issue a SET CURRENT XXX
    command following a successful connection.  By default a COMMIT
    is not issued, which can leave a thread hanging on a z/DB2
    server.
    

Problem conclusion

  • First fixed in DB2 UDB Version 9, Fixpak 5
    

Temporary fix

  • Manually issue a commit after establishing a connection.
    

Comments

APAR Information

  • APAR number

    JR27835

  • Reported component name

    DB2 CEE WINDOWS

  • Reported component ID

    5765F3001

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2007-11-12

  • Closed date

    2008-07-02

  • Last modified date

    2008-07-21

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

    JR27559

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

    JR29953

Fix information

  • Fixed component name

    DB2 CEE WINDOWS

  • Fixed component ID

    5765F3001

Applicable component levels

  • R910 PSN

       UP

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"910"}]

Document Information

Modified date:
07 October 2021