Fixes are available
APAR status
Closed as program error.
Error description
When a program tries to open a lot of statement handles (up to the limit which is indicated by an SQL0805), and then closes some handles and again opens a new statement handle, then a SQL0805 error is received, even though this should not happen (because some handles were closed in between, at least same number of handles should be allowed to be opened as they were closed earlier) This behaviour is observed in universal (JCC T2 and T4) drivers while legacy drivers work as expected i.e. the application can create again as many statements as the cli-packages allow. This problem is observed on all versions i.e. DB2 V8.1, V8.2, V9.1, V9.5 using Universal Driver (JCC).
Local fix
If the application really needs to use these many statements concurrently, then this -805 suggests that there are no more packages to use and user should bind more packages. Binding more packages will allow using more than the earlier number of statements. Furthermore, if the application doesn't really need to use these many statements concurrently, it's a good practice to close the statement right after using it then the number of statement won't reach the limitation.
Problem summary
When a program tries to open a lot of statement handles (up to the limit which is indicated by an SQL0805), and then closes some handles and again opens a new statement handle, then a SQL0805 error is received, even though this should not happen (because some handles were closed in between, at least same number of handles should be allowed to be opened as they were closed earlier) This behaviour is observed in universal (JCC T2 and T4) drivers while legacy drivers work as expected i.e. the application can create again as many statements as the cli-packages allow. This problem is observed on all versions i.e. DB2 V8.1, V8.2, V9.1, V9.5 using Universal Driver (JCC).
Problem conclusion
Problem was first fixed in Version v9.1 Fix Pack 7
Temporary fix
Comments
APAR Information
APAR number
IZ44579
Reported component name
DB2 CEE AIX
Reported component ID
5765F3000
Reported release
910
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2009-02-24
Closed date
2009-04-21
Last modified date
2009-04-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 AIX
Fixed component ID
5765F3000
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:
04 October 2021