.
SQL DDL (BSTATDR)
This topic describes the SQL DDL section of the DB2 statistics detail report (BSTATDR).
------------------------- -------- ------- ------- -------
CREATE TABLE 0 0.00 0.00 0.00
CREATE TEMP TABLE 0 0.00 0.00 0.00
DECLARE GLBL TEMP TABLE 0 0.00 0.00 0.00
CREATE AUXILLARY TABLE 0 0.00 0.00 0.00
CREATE INDEX 0 0.00 0.00 0.00
CREATE VIEW 0 0.00 0.00 0.00
CREATE SYNONYM 0 0.00 0.00 0.00
CREATE TABLESPACE 0 0.00 0.00 0.00
CREATE DATABASE 0 0.00 0.00 0.00
CREATE STOGROUP 0 0.00 0.00 0.00
CREATE ALIAS 0 0.00 0.00 0.00
CREATE DISTINCT TYPE 0 0.00 0.00 0.00
CREATE FUNCTION 0 0.00 0.00 0.00
CREATE PROCEDURE 0 0.00 0.00 0.00
CREATE TRIGGER 0 0.00 0.00 0.00
CREATE SEQUENCE 0 0.00 0.00 0.00
ALTER TABLE 0 0.00 0.00 0.00
ALTER INDEX 0 0.00 0.00 0.00
ALTER TABLESPACE 0 0.00 0.00 0.00
ALTER DATABASE 0 0.00 0.00 0.00
ALTER STOGROUP 0 0.00 0.00 0.00
ALTER FUNCTION 0 0.00 0.00 0.00
ALTER PROCEDURE 0 0.00 0.00 0.00
ALTER SEQUENCE 0 0.00 0.00 0.00
ALTER VIEW 0 0.00 0.00 0.00
DROP TABLE 0 0.00 0.00 0.00
DROP INDEX 0 0.00 0.00 0.00
DROP VIEW 0 0.00 0.00 0.00
DROP SYNONYM 0 0.00 0.00 0.00
DROP TABLESPACE 0 0.00 0.00 0.00
DROP DATABASE 0 0.00 0.00 0.00
DROP STOGROUP 0 0.00 0.00 0.00
DROP ALIAS 0 0.00 0.00 0.00
DROP PACKAGE 0 0.00 0.00 0.00
DROP DISTINCT TYPE 0 0.00 0.00 0.00
DROP FUNCTION 0 0.00 0.00 0.00
DROP PROCEDURE 0 0.00 0.00 0.00
DROP TRIGGER 0 0.00 0.00 0.00
DROP SEQUENCE 0 0.00 0.00 0.00
RENAME TABLE 0 0.00 0.00 0.00
COMMENT ON 0 0.00 0.00 0.00
LABEL ON 0 0.00 0.00 0.00
CREATE ROLE 0 0.00 0.00 0.00
CREATE TRUSTED CONTEXT 0 0.00 0.00 0.00
DROP ROLE 0 0.00 0.00 0.00
DROP TRUSTED CONTEXT 0 0.00 0.00 0.00
ALTER TRUSTED CONTEXT 0 0.00 0.00 0.00
TOTAL 0 0.00 0.00 0.00
Following table describes the fields in the SQL DDL section.
Field | Description |
|---|---|
CREATE TABLE | Number of CREATE TABLE statements executed (QXCRTAB) |
CREATE TEMP TABLE | Number of CREATE GLOBAL TEMPORARY TABLE statements executed (QXCRGTT) |
DECLARE GLBL TEMP TABLE | Number of SQL DECLARE GLOBAL TEMPORARY TABLE statements |
CREATE AUX TABLE | Number of CREATE AUXILIARY TABLE statements executed (QXCRATB) |
CREATE INDEX | Number of CREATE DATABASE statements executed (QXCRINX) |
CREATE VIEW | Number of CREATE VIEW statements executed (QXCRTAB) |
CREATE SYNONYM | Number of CREATE SYNONYM statements executed (QXCRSYN) |
CREATE TABLESPACE | Number of CREATE TABLESPACE statements executed (QXCTABS) |
CREATE DATABASE | Number of CREATE DATABASE statements executed (QXCRDAB) |
CREATE STOGROUP | Number of CREATE STOGROUP statements executed (QXCRSTG) |
CREATE ALIAS | Number of CREATE ALIAS statements executed (QXCRALS) |
CREATE DISTINCT TYPE | Number of CREATE DISTINCT TYPE statements executed (QXCDIST) |
CREATE FUNCTION | Number of CREATE FUNCTION statements executed (QXCRUDF) |
CREATE PROCEDURE | Number of CREATE PROCEDURE statements executed (QXCRPRO) |
CREATE SEQUENCE | Number of CREATE SEQUENCE statements executed (QXCRESEQ) |
ALTER TABLE | Number of ALTER TABLE statements executed (QXALTTA) |
ALTER INDEX | Number of ALTER INDEX statements executed (QXALTIX) |
ALTER TABLESPACE | Number of ALTER TABLESPACE statements executed (QXALTTS) |
ALTER DATABASE | Number of ALTER DATABASE statements executed (QXALDAB) |
ALTER STOGROUP | Number of ALTER STOGROUP statements executed (QXALTST) |
ALTER FUNCTION | Number of ALTER FUNCTION statements executed (QXALUDF) |
ALTER PROCEDURE | Number of ALTER PROCEDURE statements executed (QXALPRO) |
ALTER SEQUENCE | Number of ALTER SEQUENCE statements executed (QXALTSEQ) |
ALTER VIEW | Number of ALTER VIEW statements executed (QXALTVW) |
DROP TABLE | Number of DROP TABLE statements executed (QXDRPTA) |
DROP INDEX | Number of DROP INDEX statements executed (QXDRPIX) |
DROP VIEW | Number of DROP VIEW statements executed (QXDRPVU) |
DROP SYNONYM | Number of DROP SYNONYM statements executed (QXDRPSY) |
DROP TABLESPACE | Number of DROP TABLESPACE statements executed (QXDRPTS) |
DROP DATABASE | Number of DROP DATABASE statements executed (QXDRPDB) |
DROP STOGROUP | Number of DROP STOGROUP statements executed (QXDRPST) |
DROP ALIAS | Number of DROP ALIAS statements executed (QXDRPAL) |
DROP PACKAGE | Number of DROP PACKAGE statements executed (QXDRPPKG) |
DROP DISTINCT TYPE | Number of DROP DISTINCT TYPE statements executed (QXDDIST) |
DROP FUNCTION | Number of DROP FUNCTION statements executed |
DROP PROCEDURE | Number of DROP PROCEDURE statements executed (QXDRPPR) |
DROP TRIGGER | Number of DROP TRIGGER statements executed (QXDRPTR) |
DROP SEQUENCE | Number of DROP SEQUENCE statements executed (QXDROSEQ) |
RENAME TABLE | Number of RENAME TABLE statements executed (QXRNTAB) |
COMMENT ON | Number of COMMENT ON statements executed (QXCMTON) |
LABEL ON | Number of LABEL ON statements executed (QXLABON) |
CREATE ROLE | Number of CREATE ROLE statements executed (QXCRROL) |
CREATE TRUSTED CONTEXT | Number of CREATE TRUSTED CONTEXT statements executed (QXCRCTX) |
DROP ROLE | Number of DROP ROLE statements executed (QXDRPROL) |
DROP TRUSTED CONTEXT | Number of DROP TRUSTED CONTEXT statements executed (QXDRPCTX) |
ALTER TRUSTED CONTEXT | Number of ALTER TRUSTED CONTEXT statements executed (QXALTCTX) |
TOTAL | Total number of SQL DDL statements executed |
Related topic