Database: Calls (DB2 UDB for UNIX and
Windows) 
To display information on calls, call the DBA Cockpit.
...
1. In the navigation frame, choose Performance ® Database.
The Database Snapshot screen appears.
2. Choose Calls.
|
Field |
Description |
|
Rows |
|
|
Deleted |
Number of data records that were deleted |
|
Inserted |
Number of data records that were inserted |
|
Selected |
Number of data records that were selected |
|
Updated |
Number of data records that were updated |
|
Statements Executed |
|
|
SELECT SQL |
Number of SELECT statements that were executed |
|
UPDATE/INSERT/DELETE |
Number of UPDATE, INSERT, and DELETE statements that were executed |
|
DDL |
Number of Data Definition Language (DDL) statements that were executed. For example, CREATE TABLE, CREATE VIEW, ALTER TABLE, and DROP INDEX. |
|
Statements Attempted |
|
|
COMMITs |
Number of COMMIT statements that have been attempted |
|
Rollbacks |
Number of ROLLBACK statements that have been attempted. Automatic rollbacks caused by error situations or deadlocks are not included. |
|
Dynamic SQL |
Number of dynamic SQL statements attempted |
|
Static SQL |
Number of static SQL statements attempted |
|
Failed SQL |
Number of attempted SQL statements that failed |
|
Hash Joins |
|
|
Total |
Total number of hash joins executed |
|
Total Hash Loops |
Total number of times that a single partition of a hash join was larger that the available sort heap space |
|
Overflows |
Number of times that hash join data exceeded the available sort heap space |
|
Small Overflows |
Number of times that hash join data exceeded the available sort heap space by less than 10 % |