Help

 

Db2 Wait Metrics

The Db2 Wait Metrics report highlights wait time associated with those Db2 SQL statements being profiled in the Strobe measurement. It shows the SQL suspension/wait which occurred due to a lack of available resources.

The suspension could be the result of Db2 threads either being locked in contention with each other or a lack of resources available for adjusting those threads. For a full understanding of wait data, refer to Db2 nn for z/OS managing performance, suspensions, and wait time.

  • Package/Stored Procedure/Trigger identifies the Package/Stored Procedure/Trigger that executed the SQL statement.

  • Target Statement identifies a target SQL statement including all of its executing components.

  • Statement Number For static non-cursor statements, the report displays the statement numbers that appear in the application code. For both static cursor statements and dynamic statements, the report shows the statement numbers that Strobe generates.

  • Statement Count is the count of all SQL activity execution for the target SQL statement (activity such as Prepare, Open, Fetch, Close, Insert, Update, Delete).

  • Wait Times (sec) is the elapsed wait time in seconds that this SQL statement incurred within Db2.

  • Total Wait is the collective total of all the wait times.

  • Synchronous I/O is the accumulated wait time for synchronous I/O for the SQL statement.

  • Lock is the accumulated wait time for lock for the SQL statement.

  • Sync Execution Unit Switch is the accumulated wait time for synchronous execution switch for the SQL statement.

  • Global Locks is the accumulated wait time for global locks for the SQL statement.

  • Read by Competing Thread is the accumulated wait time for read activity done by another thread for the SQL statement.

  • Write by Competing Thread is the accumulated wait time for write activity done by another thread for the SQL statement.

  • Latch is the accumulated wait time for latch for the SQL statement.

  • Page Latch is the accumulated wait time for page latch for the SQL statement.

  • Drain Lock is the accumulated time for drain lock for the SQL statement.

  • Claim Release is the accumulated wait time for claim count for the SQL statement.

  • Log Writer is the accumulated wait time for log writer for the SQL statement.

Click next to a Package Stored Procedure/Trigger to view the DDF Requester Breakout. One of the following values can appear for this report:

  • Requester Location

  • Authorization ID

  • Correlation ID

  • End User ID

  • End User Workstation

  • End User Transaction