SQL DCL

This topic shows detailed information about Accounting - SQL DCL.

This block shows information about SQL DCL (Data Control Language) declarations.

The following example applies to both the report layout and the trace layout.

Accounting - SQL DCL

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


SQL DCL            TOTAL
--------------  --------
LOCK TABLE             0
GRANT                  0
REVOKE                 0
SET CURR.SQLID         0
SET HOST VAR.          0
SET CUR.DEGREE         0
SET RULES              0
SET TIMEOUT            1
 FROM APPL.            0
 FROM PROF.            1
SET CURR.PATH          0
SET CURR.PREC          0
CONNECT TYPE 1         0
CONNECT TYPE 2         0
SET CONNECTION         0
RELEASE                0
CALL                   0
ASSOC LOCATORS         0
ALLOC CURSOR           0
HOLD LOCATOR           0
FREE LOCATOR           0
DCL-ALL                0

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 CURR.SQLID

The number of SET CURRENT SQLID statements executed.

Field Name: QXSETSQL

SET HOST VAR.

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

Field Name: QXSETHV

SET CUR.DEGREE

The number of SET CURRENT DEGREE statements executed.

Field Name: QXSETCDG

SET RULES

The number of SET CURRENT RULES statements executed.

Field Name: QXSETCRL

SET CURR.PATH

The number of SET CURRENT PATH statements executed.

Field Name: QXSETPTH

SET CURR.PREC

The number of SET CURRENT PRECISION statements executed.

Field Name: QXSETCPR

SET TIMEOUT

Number of times the CURRENT LOCK TIMEOUT special register was changed.

Background and Tuning Information

Number of times the CURRENT LOCK TIMEOUT special register was changed.

Field Name: ASTOTCTO

FROM APPL.

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

Background and Tuning Information

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

Field Name: QXCTOAPP

FROM PROF.

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

Background and Tuning Information

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

Field Name: QXCTOPRF

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

SET CONNECTION

The number of SET CONNECTION statements executed.

Field Name: QXSETCON

RELEASE

The number of RELEASE statements executed.

Field Name: QXREL

CALL

The number of SQL CALL statements executed.

Field Name: QXCALL

ASSOC LOCATORS

The number of SQL ASSOCIATE LOCATORS statements executed.

Field Name: QXALOCL

ALLOC CURSOR

The number of SQL ALLOCATE CURSOR statements executed.

Field Name: QXALOCC

HOLD LOCATOR

The number of HOLD LOCATOR statements executed.

Field Name: QXHLDLOC

FREE LOCATOR

The number of times a FREE LOCATOR statement was issued.

Field Name: QXFRELOC

DCL-ALL

The total number of DCL statements executed.

Field Name: ASCDCL