.
SQL DCL (BSTATLT)
This topic describes the SQL DCL section of the DB2 statistics trace—long report (BSTATLT).
-------------------------- -------- ------- ------- -------
LOCK TABLE 0 0.00 0.00 0.00
GRANT 0 0.00 0.00 0.00
REVOKE 0 0.00 0.00 0.00
SET CURRENT SQLID 0 0.00 0.00 0.00
SET HOST VARIABLE 0 0.00 0.00 0.00
SET CURRENT DEGREE 0 0.00 0.00 0.00
SET CURRENT RULES 0 0.00 0.00 0.00
CONNECT TYPE 1 0 0.00 0.00 0.00
CONNECT TYPE 2 0 0.00 0.00 0.00
RELEASE 0 0.00 0.00 0.00
SET CONNECTION 0 0.00 0.00 0.00
SET CURRENT PATH 0 0.00 0.00 0.00
SET CURRENT PRECISION 0 0.00 0.00 0.00
ASSOCIATE LOCATORS 0 0.00 0.00 0.00
ALLOCATE LOCATORS 0 0.00 0.00 0.00
HOLD LOCATOR 0 0.00 0.00 0.00
FREE LOCATOR 0 0.00 0.00 0.00
TOTAL 0 0.00 0.00 0.00
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 CURRENT SQLID | Number of SET CURRENT SQLID statements executed (QXSETSQL) |
SET HOST VARIABLE | Number of SET HOST VARIABLE statements executed (QXSETHV) |
SET CURRENT 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 CURRENT 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 TYPE 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 TYPE 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). |
RELEASE | Number of RELEASE statements issued (QXREL) This number is a count of the SQL RELEASE statements processed for the application. |
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. |
SET CURRENT PATH | Number of SET CURRENT PATH statements executed (QXSETPTH) |
SET CUR PRECISION | Number of SET CURRENT PRECISION statements executed (QXSETCPR) |
CALL | Number of CALL statements executed (QXCALL) |
ASSOCIATE 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. |
ALLOCATE LOCATORS | Number of ALLOCATE LOCATORS statements executed (QXALOCC) |
HOLD LOCATOR | Number of HOLD LOCATOR statements executed (QXHOLDL) |
FREE LOCATOR | Number of FREE LOCATOR statements executed (QXFREEL) |
TOTAL | Total number of DCL statements executed QXLOCK + QXGRANT + QXREVOK + QXSETSQL + QXSETHV + QXSETCDG + QXSETCRL + QXCON1 + QXCON2 + QXSETCON + QXREL + QXCALL + QXHOLDL + QXFREEL |
Related topic