SQL Counts 3 Workspace

The SQL Counts 3 workspace provides information about currently committed rows, multi-row processing, workfile storage, and concentrate statements.

This workspace is comprised of the following views:

Use Currently Committed

Shows, for the selected thread, the number of rows for currently committed data that is skipped or accessed by read transactions when processing a DB2® application.

Multi-Row Processing

Enables you to track performance improvements such as multi-row fetch and multi-row insert.

Workfile Storage

Shows the statistics on the usage and storage of DB2 workfiles.

Concentrate Statements

Indicates if literal constants, which are referenced in dynamic SQL statements, are replaced with special markers so that these constants are not cached with the statement in the dynamic SQL statement cache.

Based on the information that this workspace provides, you can recommend changes, set up situations, and verify that your recommended changes improve system performance.