You may want to generate an export file in the following circumstances:
To import statements to the statement pool, you can create an export file, edit its contents, and import the file into the statement pool to import statements to the pool.
To examine the characteristics of the statements in the statement pool to help you troubleshoot statement pool performance.
To generate a statement pool export file, use the exportStatements() method of the ExtStatementPoolMonitorMBean interface. For example, the following code exports the contents of the statement pool associated with the connection to a file named stmt_export.txt:
To import statements to the statement pool, you can create an export file, edit its contents, and import the file into the statement pool to import statements to the pool.