Fixes are available
DB2 Version 9.1 Fix Pack 7 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 5 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 6 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 6a for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 7a for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 8 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 9 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 10 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 11 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 12 for Linux, UNIX and Windows
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:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
DB2 CEE WINDOWS
Fixed component ID
5765F3001
Applicable component levels
R910 PSN
UP
Document Information
Modified date:
07 October 2021