SQL DML

Accounting - SQL DML

The field labels shown in the following sample layout of Accounting - SQL DML are described in the following section.

Report:                        Trace:

SQL DML   AVERAGE    TOTAL     SQL DML      TOTAL
-------- -------- --------     --------- --------
SELECT       3.27      964     SELECT         488
INSERT       3.21      947     INSERT          37
 ROWS        3.21      947      ROWS           36
UPDATE       3.83     1131     UPDATE          45
 IAG1        3.21      947      IAG1           36
 IAG2        0.00        0      IAG2            0
 ROWS        5.03     1483      ROWS           36
MERGE        0.00        0     MERGE            0
UPDATE       3.83     1131     UPDATE          45
 ROWS        5.03     1483      ROWS           36
DELETE       0.14       40     DELETE           1
 ROWS        0.14       40      ROWS            0
MERGE        0.00        0     MERGE            0
DELETE       0.14       40     DELETE           1

 ROWS        0.14       40      ROWS            0
DESCRIBE     2.79      824     DESCRIBE         0

DESC.TBL     0.00        0     DESC.TBL         0
PREPARE      3.01      888     PREPARE          0
DESCRIBE     2.79      824     DESCRIBE         0
DESC.TBL     0.00        0     DESC.TBL         0
OPEN         5.20     1533     OPEN           125
FETCH        3.36      991     FETCH         1331
PREPARE      3.01      888     PREPARE          0
OPEN         5.20     1533     OPEN           125
 ROWS       10.37     3060      ROWS         1000
CLOSE        3.36      990     CLOSE          109
FETCH        3.36      991     FETCH         1331

 ROWS       10.37     3060      ROWS         1000
CLOSE        3.36      990     CLOSE          109
DML-ALL     28.16     8308     DML-ALL       2136

DML-ALL     28.16     8308     DML-ALL       2136

SELECT

The number of SQL SELECT statements executed.

Field Name: QXSELECT

INSERT

The number of INSERT statements executed.

Field Name: QXINSRT

IAG1

Inserts performed via algorithm type 1.

Field Name: QXRWIAG1

IAG2

Inserts performed via algorithm type 2.

Field Name: QXRWIAG2

INSERT - ROWS

The number of rows inserted (DB2 field: QXRWSINSRTD).

Field Name: ARWINSRT

UPDATE

The number of UPDATE statements executed.

Field Name: QXUPDTE

UPDATE - ROWS

The number of rows updated (DB2 field: QXRWSUPDTD).

Field Name: ARWUPDAT

MERGE

The number of times a MERGE statement was executed.

Field Name: QXMERGE

DELETE

The number of DELETE statements executed.

Field Name: QXDELET

DELETE - ROWS

The number of rows deleted (DB2 field: QXRWSDELETD).

Field Name: ARWDELET

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

DESC.TBL

The number of DESCRIBE TABLE statements executed.

Field Name: QXDSCRTB

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

OPEN

The number of OPEN statements executed.

Field Name: QXOPEN

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 - ROWS

The number of rows fetched (DB2 field: QXRWSFETCHD).

Field Name: ARWFETCH

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

DML-ALL

The total number of SQL DML statements executed.

Field Name: ASCDML