PQ49742: THE METHODICAL DOCUMENT SHOULD BE PROVIDED BY WAS.


APAR

APAR status
Closed as documentation error.

Error description
default statementCacheSize (100) cause CLI0129E.
We need more sophisticated way to calculate UDB APPLHEAPSZ
and prepare statement cache size.
The methodical document should be provided by WAS.
For example,We specify 4096 to APPLHEAPSZ in UDB, and
take default statementCacheSize (100).
The DCF TechNotes #1006297 state that 4096 will allow
for 1326 concurrent open statement handle.
but, in our case, we still get CLI0129E no more handle
during processing.
We confirmed this size (71) by WAS datasource cm trace.
It is very hard work to customer to determine both size
 (APPHEAPSZ and statementCacheSize) each time.
The guide for calculation of these size should be provided
in WebSphere InfoCenter.
Local fix
Problem summary
Document should be provided by WAS to calculate
UDB APPLHEAPSZ and prepared statement cache size.
The DCF TechNotes #1006297 state that 4096 will allow
for a 1326 concurrent open statement handle but
this cause and error during processing: CLI0129E
no more handle.  This should be in InfoCenter for 3.5.
Problem conclusion
adjusted accordingly.
Temporary fix
Comments
APAR information
APAR numberPQ49742
Reported component nameWAS ADVANCED AI
Reported component ID5648C8400
Reported release350
StatusCLOSED DOC
PENoPE
HIPERNoHIPER
Submitted date2001-06-19
Closed date2001-07-18
Last modified date2001-07-18

APAR is sysrouted FROM one or more of the following:

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


Modules/Macros

Fix information
APAR is sysrouted TO one or more of the following:Modules/Macros

Applicable component levels











Document Information

Product categories: Software, Application Servers, Distributed Application & Web Servers, WebSphere Application Server, General
Software version: 350
Reference #: PQ49742
IBM Group: Software Group
Modified date: 2001-07-18