SQL DML
This topic shows detailed information about Statistics - SQL DML
.
Statistics - SQL DML
The field labels shown in the following sample layout of Statistics - SQL DML
are
described in the following section.
SQL DML QUANTITY /SECOND /THREAD /COMMIT
--------------------------- -------- ------- ------- -------
SELECT 0.00 0.00 N/C 0.00
INSERT 0.00 0.00 N/C 0.00
NUMBER OF ROWS 1551.00 8.53 N/C 47.00
TYPE 1 INSERT ALGORITHM 1551.00 8.53 N/C 47.00
TYPE 2 INSERT ALGORITHM 0.00 0.00 N/C 0.00
TYPE 2 SWITCH TO TYPE 1 0.00 0.00 N/C 0.00
RE-ENABLE ATTEMPTED 0.00 0.00 N/C 0.00
RE-ENABLE SUCCESSFUL 0.00 0.00 N/C 0.00
UPDATE 0.00 0.00 N/C 0.00
NUMBER OF ROWS 28.00 0.15 N/C 0.85
MERGE 0.00 0.00 N/C 0.00
DELETE 0.00 0.00 N/C 0.00
NUMBER OF ROWS 0.00 0.00 N/C 0.00
PREPARE 16.00 0.09 N/C 0.48
DESCRIBE 0.00 0.00 N/C 0.00
DESCRIBE TABLE 0.00 0.00 N/C 0.00
OPEN 16.00 0.09 N/C 0.48
CLOSE 0.00 0.00 N/C 0.00
FETCH 0.00 0.00 N/C 0.00
NUMBER OF ROWS 16.00 0.09 N/C 0.48
TOTAL DML 32.00 0.18 N/C 0.97
- SELECT
-
The number of SQL SELECT statements executed.
Field Name: QXSELECT
- INSERT
-
The number of INSERT statements executed.
Field Name: QXINSRT
- INSERT - NUMBER OF ROWS
-
The number of rows inserted (Db2 field: QXRWSINSRTD).
Field Name: SRWINSRT
- INSERT - TYPE 1 INSERT ALGORITHM
-
The number of rows inserted (Db2 field: QXRWSINSRTD).
Field Name: QXRWSINSRTDALG1
- INSERT - TYPE 2 INSERT ALGORITHM
-
The number of rows inserted (Db2 field: QXRWSINSRTD).
Field Name: QXRWSINSRTDALG2
- INSERT - TYPE 2 SWITCH TO TYPE 1
-
The number of inserts being switched from using insert algorithm 2 to the basic insert algorithm.
Field Name: QXINSRTIAG2TO1
- INSERT - TYPE 2 INSERT ALGORITHM - RE-ENABLE ATTEMPTED
-
Number of times IAG2 pipe re-enable was attempted.
Field Name: QISTINPR
- INSERT - TYPE 2 INSERT ALGORITHM - RE-ENABLE SUCCESSFUL
-
Number of times IAG2 pipe re-enable was successful.
Field Name: QISTINPE
- UPDATE
-
The number of UPDATE statements executed.
Field Name: QXUPDTE
- UPDATE - NUMBER OF ROWS
-
The number of rows updated (Db2 field: QXRWSUPDTD).
Field Name: SRWUPDAT
- MERGE
-
The number of times a MERGE statement was executed.
Field Name: QXMERGE
- DELETE
-
The number of DELETE statements executed.
Field Name: QXDELET
- DELETE - NUMBER OF ROWS
-
The number of rows deleted (Db2 field: QXRWSDELETD).
Field Name: SRWDELET
- PREPARE
-
The number of SQL PREPARE statements executed. This number at the server location might not match the number at the user application because of the internal processing of the Distributed Data Facility (DDF).
Field Name: QXPREP
- DESCRIBE
-
The number of DESCRIBE, DESCRIBE CURSOR, DESCRIBE INPUT, and DESCRIBE PROCEDURE statements executed. This number at the server location might not match the number at the user application because of the internal processing of the Distributed Data Facility (DDF).
Field Name: QXDESC
- DESCRIBE TABLE
-
The number of DESCRIBE TABLE statements executed.
Field Name: QXDSCRTB
- OPEN
-
The number of OPEN statements executed.
Field Name: QXOPEN
- CLOSE
-
The number of CLOSE statements executed. This number at the server location might not match the number at the user application because of the internal processing of the Distributed Data Facility (DDF).
Field Name: QXCLOSE
- FETCH
-
The number of FETCH statements executed. This number at the server location might not match the number at the user application because of the internal processing of the Distributed Data Facility (DDF).
Field Name: QXFETCH
- FETCH - NUMBER OF ROWS
-
The number of rows fetched (Db2 field: QXRWSFETCHD).
Field Name: SRWFETCH
- TOTAL
-
The total number of SQL DML statements executed.
Field Name: SSCDML
This is an exception field.