The system-wide SQL statement cache, ..., can improve the performance of
programs using dynamic SQL statements. No user action is required to activate
or administer this function.
When a dynamic SQL statement that has previously executed is later reexecuted, if the statement is still available in the cache, IBMR DB2R for AS/400 can retrieve (rather than construct) key information associated with the cached statement, and thereby reduce the processing resource and the time required to execute the statement again.