#CALL
SQL Call Statements
D#CALL
Reports the number of stored procedure calls during the sampling period (QXCALL)
Parameter: User-defined identifier for the request or blank.
Warning
DW0400W (nn) hh:mm:ss SQL CALL STATEMENTS(parm) =v IN x intrvl (>thrshld)
#DYN
Dynamic SQL Statements
D#DYN
Reports the number of dynamic SQL statements (PREPARE) during the sampling period (QXPREP)
Parameter: User-defined identifier for the request or blank.
Warning
DW0030W (nn) hh:mm:ss DYNAMIC SQL STATEMENTS(parm) =v IN x intrvl (>thrshld)
#REOP
Reoptimiza-tions
D#REOP
Reports the number of times that re-optimization for host variables occurred during the sampling period (QXSTREOP)
Parameter: User-defined identifier for the request or blank.
Warning
DW0600W (nn) hh:mm:ss REOPTIMIZATIONS(parm) =v IN x intrvl (>thrshld)
#SPRC
Stored Procedures Executed
D#SPRC
Reports the number of stored procedures executed during the sampling period (QXCALL, QXCALLAB, QXCALLTO, QXCALLRJ)
Parameter: User-defined identifier for the request or blank.
Warning
DW0410W (nn) hh:mm:ss SPROCS EXECUTED(parm) =v IN x intrvl (>thrshld)
#SQLA
Administrative SQL Statements
D#SQLA
Reports the number of SQL administrative statements issued by a transaction during the sampling period
This value includes:
LOCK TABLE
COMMENT
LABEL
GRANT
REVOKE
SET CURRENT SQL ID
SET CONNECTION
SET CURRENT DEGREE
CONNECT
RELEASE
SET CURRENT RULES
(QXCMTON + QXLOCK + QXGRANT + QXREVOK + QXLABON + QXSETSQL + QXCON1 + QXCON2 + QXREL + QXSETCON + QXSETCDG + QXSETCRL)
Parameter: User-defined identifier for the request or blank.
Warning
DW0210W (nn) hh:mm:ss ADMINISTRATIVE STMTS(parm) =v IN x intrvl (>thrshld)
#SQLC
SQL Statements per Commit
D#SQLC
Reports the number of SQL statements per commit point (SELECT, FETCH, INSERT, DELETE, UPDATE, MERGE, TRUNCATE) during the sampling period (QXSELECT + QXFETCH + QXINSRT + QXDELET + QXUPDTE + QXMERGE + QXTRTBL)
Parameter: User-defined identifier for the request or blank.
Warning
DW0220W (nn) hh:mm:ss SQL STMTS PER COMMIT(parm) =v IN x intrvl (>thrshld)
#SQLD
DDL Statements
D#SQLD
Reports the number of Data Definition Language statements (CREATE, ALTER, DROP) during the sampling period (QXCRTAB + QXCRINX + QXCTABS + QXCRSYN + QXCRDAB + QXCRSTG + QXDEFVU + QXDRPIX + QXDRPTA + QXDRPTS + QXDRPDB + QXDRPSY + QXDRPST + QXDRPVU + QXALTST + QXFETCH + QXALTTS + QXALTTA + QXALTIX + QXDRPAL + QXCRALS + QXALDAB + QXDRPPKG)
Parameter: User-defined identifier for the request or blank.
Warning
DW0020W (nn) hh:mm:ss DDL SQL STATEMENTS(parm) =v IN x intrvl (>thrshld)
#SQLM
Data Manipulative SQL Statements
D#SQLM
Reports the number of data manipulative SQL statements issued by a transaction (SELECT, INSERT, UPDATE, DELETE, PREPARE, OPEN, CLOSE, FETCH, MERGE, TRUNCATE) during the sampling period (QXSELECT + QXINSRT + QXUPDTE + QXDELET + QXPREP + QXOPEN + QXCLOSE + QXFETCH + QXMERGE + QXTRTBL)
Parameter: User-defined identifier for the request or blank.
Warning
DW0200W (nn) hh:mm:ss DATA MANIPULATIVE SQL(parm) =v IN x intrvl (>thrshld)
