SQL DCL
------------ --------
LOCK TABLE 0
GRANT 0
REVOKE 0
SET SQLID 0
SET HOST VAR 0
SET DEGREE 0
SET RULES 0
CONNECT 1 0
CONNECT 2 0
SET CONNECT 0
RELEASE 0
CALL 0
ASSOC.LOCATORS 0
ASSOC.CURSOR 0
HOLD LOCATOR 0
FREE LOCATOR 0
DCL-ALL 0
SET CURR PATH 0
SET CURR PREC 0
The following table describes the fields in the SQL DCL section:
Field | Description |
|---|---|
LOCK TABLE | Number of LOCK TABLE statements executed (either SHARE or EXCLUSIVE) (QXLOCK) |
GRANT | Number of GRANT statements executed (QXGRANT) Tuning Tip: This field is useful for the auditor who wishes to monitor the grants of authority by user. Other audit traces can be activated to capture which authorities were granted. The catalog can also be queried. |
REVOKE | Number of REVOKE statements executed (QXREVOK) Tuning Tip: This field is useful for the auditor who wants to monitor the revocations of authority by user. Other audit traces can be activated to capture which authorities were revoked. |
SET SQLID | Number of SET CURRENT SQLID statements executed (QXSETSQL) |
SET HOST VAR | Number of SET HOST VARIABLE statements executed (QXSETHV) |
SET DEGREE | Number of SET CURRENT DEGREE statements executed (QXSETCDG) This number is a count of the SQL SET CURRENT DEGREE statements processed for the application. This register enables or disables parallel processing for dynamic SQL. |
SET RULES | Number of SET CURRENT RULES statements executed (QXSETCRL) This number is a count of the SQL SET CURRENT RULES statements processed for the application. This register is used to change syntax parsing from SQL rules to ANSI/SQL processing. |
CONNECT 1 | Number of Type 1 CONNECT statements executed (QXCON1) This value is a count of the number of Type 1 SQL CONNECT statements processed for the application. Tuning Tip: Type 1 SQL CONNECT statements allow one site that can be updated in the connection. Type 2 SQL CONNECT statements allow multiple sites that can be updated in the distributed connection. The type of CONNECT statement is specified as a precompiler parameter CONNECT(1) or CONNECT(2). |
CONNECT 2 | Number of Type 2 CONNECT statements executed (QXCON2) This value is a count of the number of Type 2 CONNECT SQL statements processed for the application. Tuning Tip: Type 1 SQL CONNECT statements allow one site that can be updated in the connection. Type 2 SQL CONNECT statements allow multiple sites that can be updated in the distributed connection. The type of CONNECT statement is specified as a precompiler parameter CONNECT(1) or CONNECT(2). |
SET CONNECT | Number of SET CONNECTION statements executed (QXSETCON) This number is a count of the SQL SET CONNECTION statements processed for the application. Tuning Tip: This verb is required to perform multisite updates. |
RELEASE | Number of RELEASE statements issued (QXREL) This number is a count of the SQL RELEASE statements processed for the application. |
CALL | Number of CALL statements executed (QXCALL) |
ASSOC.LOCATORS | Number of ASSOCIATE LOCATOR statements executed (QXALOCL) These statements get the result set locator value for each result set returned by a stored procedure. |
ASSOC.CURSOR | Number of ASSOCIATE CURSOR statements executed (QXALOCC) |
HOLD LOCATOR | Number of HOLD LOCATOR statements executed (QXHOLDL) |
FREE LOCATOR | Number of FREE LOCATOR statements executed (QXFREEL) |
DCL-ALL | Total number of DCL statements executed QXLOCK + QXGRANT + QXREVOK + QXSETSQL + QXSETHV + QXSETCDG + QXSETCRL + QXCON1 + QXCON2 + QXSETCON + QXREL + QXCALL + QXHOLDL + QXFREEL |
SET CURRENT PATH | Number of SET CURRENT PATH statements executed (QXSETPTH) |
SET CUR PREC | Number of SET CURRENT PRECISION statements executed (QXSETCPR) |