SQL DCL

Statistics - SQL DCL

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

SQL DCL                      QUANTITY  /SECOND  /THREAD  /COMMIT
---------------------------  --------  -------  -------  -------
LOCK TABLE                       0.00     0.00      N/C     0.00
GRANT                            1.00     0.01      N/C     0.03
REVOKE                           0.00     0.00      N/C     0.00
SET HOST VARIABLE                0.00     0.00      N/C     0.00
SET CURRENT SQLID                0.00     0.00      N/C     0.00
SET CURRENT DEGREE               0.00     0.00      N/C     0.00
SET CURRENT RULES                0.00     0.00      N/C     0.00
SET CURRENT PATH                 0.00     0.00      N/C     0.00
SET CURRENT PRECISION            0.00     0.00      N/C     0.00
SET CURRENT LOCK TIMEOUT         0.00     0.00     0.00     0.00
   FROM APPLICATION              0.00     0.00      N/C     0.00
   FROM PROFILE                  0.00     0.00      N/C     0.00

CONNECT TYPE 1                   0.00     0.00      N/C     0.00
CONNECT TYPE 2                   0.00     0.00      N/C     0.00
RELEASE                          0.00     0.00      N/C     0.00
SET CONNECTION                   0.00     0.00      N/C     0.00

ASSOCIATE LOCATORS               0.00     0.00      N/C     0.00
ALLOCATE CURSOR                  0.00     0.00      N/C     0.00

HOLD LOCATOR                     0.00     0.00      N/C     0.00
FREE LOCATOR                     0.00     0.00      N/C     0.00

TOTAL                            1.00     0.01      N/C     0.03

LOCK TABLE

The number of LOCK TABLE statements executed.

Field Name: QXLOCK

GRANT

The number of GRANT statements executed.

Field Name: QXGRANT

REVOKE

The number of REVOKE statements executed.

Field Name: QXREVOK

SET HOST VARIABLE

The number of SET HOST VARIABLE statements executed. The special register that was retrieved is not tracked.

Field Name: QXSETHV

SET CURRENT SQLID

The number of SET CURRENT SQLID statements executed.

Field Name: QXSETSQL

SET CURRENT DEGREE

The number of SET CURRENT DEGREE statements executed.

Field Name: QXSETCDG

SET CURRENT RULES

The number of SET CURRENT RULES statements executed.

Field Name: QXSETCRL

SET CURRENT PATH

The number of SET CURRENT PATH statements executed.

Field Name: QXSETPTH

SET CURRENT PRECISION

The number of SET CURRENT PRECISION statements executed.

Field Name: QXSETCPR

SET CURRENT LOCK TIMEOUT

Total number of times that the CURRENT LOCK TIMEOUT special register was set.

Field Name: TOTSCTO

FROM APPLICATION

Number of times the SET CURRENT LOCK TIMEOUT statement was executed from application.

Field Name: QXSTTIMEOUTFromAppl

FROM PROFILE

Number of times that the CURRENT LOCK TIMEOUT special register was set from a profile table.

Field Name: QXSTTIMEOUTFromProf

CONNECT TYPE 1

The number of CONNECT type 1 statements executed.

Field Name: QXCON1

CONNECT TYPE 2

The number of CONNECT type 2 statements executed.

Field Name: QXCON2

RELEASE

The number of RELEASE statements executed.

Field Name: QXREL

SET CONNECTION

The number of SET CONNECTION statements executed.

Field Name: QXSETCON

ASSOCIATE LOCATORS

The number of SQL ASSOCIATE LOCATORS statements executed.

Field Name: QXALOCL

ALLOCATE CURSOR

The number of SQL ALLOCATE CURSOR statements executed.

Field Name: QXALOCC

HOLD LOCATOR

The number of SQL HOLD LOCATOR statements executed.

Field Name: QXHOLDL

FREE LOCATOR

The number of SQL FREE LOCATOR statements executed.

Field Name: QXFREEL

TOTAL

The total number of DCL statements executed.

The exception field name is SSCDCL.

Field Name: SSCDCL