Disable statement pooling performing Data Definition Language (DDL) operations, which might not be compatible with statement pooling.
DDL operations, such as dropping and recreating tables, are not compatible with statement pooling when using the IBM Informix database. DDL operations invalidate the pooled statements or cause them to produce unexpected results.
Complete the following steps to use the administrative console to disable statement pooling. Statement pooling is disabled by specifying a value of zero for the statement cache size setting for your datasource.
In this information ...Related tasks
Related reference
| IBM Redbooks, demos, education, and more(Index) |