SQL Activity window
Use the SQL Activity window to view subsystem-wide SQL
activity for determining the SQL workload on the system. This information
displays the number of times each SQL statement has been executed.
To display this window, select SQL Activity from
the DB2® Statistics Detail panel.
DGOMSWSQ SQL Activity
INTERVAL 2:48.421
More: - +
Incremental Binds . . . . . . . . . . : 0
Total DML . . . . . . . . . . . . . . : 108
Select . . . . . . . . . . . . . . : 2
Insert . . . . . . . . . . . . . . : 0
Update . . . . . . . . . . . . . . : 0
Delete . . . . . . . . . . . . . . : 0
Prepare . . . . . . . . . . . . . . : 10
Describe . . . . . . . . . . . . . : 0
Describe Table . . . . . . . . . . : 0
Open Cursor . . . . . . . . . . . . : 3
Close Cursor . . . . . . . . . . . : 3
Fetch . . . . . . . . . . . . . . . : 90
Total DCL . . . . . . . . . . . . . . : 4
Lock Table . . . . . . . . . . . . : 0
Grant . . . . . . . . . . . . . . . : 4
Revoke . . . . . . . . . . . . . . : 0
Set Current SQLID . . . . . . . . . : 0
Set Host Variable . . . . . . . . . : 0
Set Current Degree . . . . . . . . : 0
Connect Type 1 . . . . . . . . . . : 0
Connect Type 2 . . . . . . . . . . : 0
Set Connection . . . . . . . . . . : 0
Release . . . . . . . . . . . . . . : 0
Set current rules . . . . . . . . . : 0
SQL call . . . . . . . . . . . . . : 0
Associate locators . . . . . . . . : 5
Allocate cursor . . . . . . . . . . : 3
Total DDL . . . . . . . . . . . . . . : 10
Rename table . . . . . . . . . . . : 0
Comment On . . . . . . . . . . . . : 0
Label On . . . . . . . . . . . . . : 0
CREATE DROP ALTER
Table . . . . : 1 1 0
Temp. Table . : 5 N/A N/A
Index . . . . : 0 0 0
Tablespace . : 0 0 0
Database . . : 0 0 0
Stogroup . . : 0 0 0
Synonym . . . : 0 0 N/A
View . . . . : 0 0 N/A
Alias . . . . : 3 0 N/A
Package . . . : N/A 0 N/A
Command ===> ______________________________________
F1=Help F2=Split F3=Exit F5=Auto
F6=History F7=Up F8=Down F9=Swap
F10=Delta F11=Interval F12=Cancel F16=Look
F17=Collect- Total DML (Data Manipulation Language)
- This section shows the number of executions performed by various SQL statements concerning the manipulation of data.
- Total DCL (Data Control Language)
- This section shows the number of executions performed by various SQL statements concerning the controlling of various activities.
- Total DDL (Data Definition Language)
- This section shows a table that contain the number of executions performed by various DDL SQL statements for each of the applicable object types. These SQL statements are used to create, drop, and alter objects.
- Incremental Binds
- This field is the number of INCREMENTAL BINDs.
If a plan is bound with VALIDATE(RUN), Db2 performs validity checks (such as authorizations and existence of referenced Db2 objects) at bind time and rechecks any failures at run time. This can result in catalog contention and degraded application performance, depending on the number of statements flagged and the number of times they are executed. Therefore VALIDATE(RUN) should be avoided as much as possible. Ensure that all objects are created and all privileges are granted before binding, and select the VALIDATE(BIND) option.
In addition to plans bound with VALIDATE(RUN), this counter is incremented for plans using Db2 private protocol.