Viewing DB2 Object Performance Data in the Investigator › Subsystem Performance Monitoring › Dynamic SQL Cache

Dynamic SQL Cache

The Dynamic SQL Cache subsystem performance folder provides information about dynamic SQL statements that are cached for reuse. Use this information to determine cached dynamic SQL statements and the accumulated resource use for each statement. The complete cached SQL statement can also be displayed.