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 fixProblem 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 fixComments
APAR information | APAR number | PQ49742 | Reported component name | WAS ADVANCED AI | Reported component ID | 5648C8400 | Reported release | 350 | Status | CLOSED DOC | PE | NoPE | HIPER | NoHIPER | Submitted date | 2001-06-19 | Closed date | 2001-07-18 | Last modified date | 2001-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 APAR is sysrouted TO one or more of the following:Modules/Macros
Applicable component levels |
|