Database monitor SQL table format
Displays the format used to create the QSYS/QAQQDBMN performance statistics table, that is shipped with the system.
CREATE TABLE QSYS.QAQQDBMN (
QQRID DECIMAL(15, 0) NOT NULL DEFAULT 0 ,
QQTIME TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ,
QQJFLD CHAR(46) CCSID 65535 NOT NULL DEFAULT '' ,
QQRDBN CHAR(18) CCSID 37 NOT NULL DEFAULT '' ,
QQSYS CHAR(8) CCSID 37 NOT NULL DEFAULT '' ,
QQJOB CHAR(10) CCSID 37 NOT NULL DEFAULT '' ,
QQUSER CHAR(10) CCSID 37 NOT NULL DEFAULT '' ,
QQJNUM CHAR(6) CCSID 37 NOT NULL DEFAULT '' ,
QQUCNT DECIMAL(15, 0) DEFAULT NULL ,
QQUDEF VARCHAR(100) CCSID 37 DEFAULT NULL ,
QQSTN DECIMAL(15, 0) DEFAULT NULL ,
QQQDTN DECIMAL(15, 0) DEFAULT NULL ,
QQQDTL DECIMAL(15, 0) DEFAULT NULL ,
QQMATN DECIMAL(15, 0) DEFAULT NULL ,
QQMATL DECIMAL(15, 0) DEFAULT NULL ,
QQTLN CHAR(10) CCSID 37 DEFAULT NULL ,
QQTFN CHAR(10) CCSID 37 DEFAULT NULL ,
QQTMN CHAR(10) CCSID 37 DEFAULT NULL ,
QQPTLN CHAR(10) CCSID 37 DEFAULT NULL ,
QQPTFN CHAR(10) CCSID 37 DEFAULT NULL ,
QQPTMN CHAR(10) CCSID 37 DEFAULT NULL ,
QQILNM CHAR(10) CCSID 37 DEFAULT NULL ,
QQIFNM CHAR(10) CCSID 37 DEFAULT NULL ,
QQIMNM CHAR(10) CCSID 37 DEFAULT NULL ,
QQNTNM CHAR(10) CCSID 37 DEFAULT NULL ,
QQNLNM CHAR(10) CCSID 37 DEFAULT NULL ,
QQSTIM TIMESTAMP DEFAULT NULL ,
QQETIM TIMESTAMP DEFAULT NULL ,
QQKP CHAR(1) CCSID 37 DEFAULT NULL ,
QQKS CHAR(1) CCSID 37 DEFAULT NULL ,
QQTOTR DECIMAL(15, 0) DEFAULT NULL ,
QQTMPR DECIMAL(15, 0) DEFAULT NULL ,
QQJNP DECIMAL(15, 0) DEFAULT NULL ,
QQEPT DECIMAL(15, 0) DEFAULT NULL ,
QQDSS CHAR(1) CCSID 37 DEFAULT NULL ,
QQIDXA CHAR(1) CCSID 37 DEFAULT NULL ,
QQORDG CHAR(1) CCSID 37 DEFAULT NULL ,
QQGRPG CHAR(1) CCSID 37 DEFAULT NULL ,
QQJNG CHAR(1) CCSID 37 DEFAULT NULL ,
QQUNIN CHAR(1) CCSID 37 DEFAULT NULL ,
QQSUBQ CHAR(1) CCSID 37 DEFAULT NULL ,
QQHSTV CHAR(1) CCSID 37 DEFAULT NULL ,
QQRCDS CHAR(1) CCSID 37 DEFAULT NULL ,
QQRCOD CHAR(2) CCSID 37 DEFAULT NULL ,
QQRSS DECIMAL(15, 0) DEFAULT NULL ,
QQREST DECIMAL(15, 0) DEFAULT NULL ,
QQRIDX DECIMAL(15, 0) DEFAULT NULL ,
QQFKEY DECIMAL(15, 0) DEFAULT NULL ,
QQKSEL DECIMAL(15, 0) DEFAULT NULL ,
QQAJN DECIMAL(15, 0) DEFAULT NULL ,
QQIDXD VARCHAR(1000) ALLOCATE(48) CCSID 37 DEFAULT NULL ,
QQC11 CHAR(1) CCSID 37 DEFAULT NULL ,
QQC12 CHAR(1) CCSID 37 DEFAULT NULL ,
QQC13 CHAR(1) CCSID 37 DEFAULT NULL ,
QQC14 CHAR(1) CCSID 37 DEFAULT NULL ,
QQC15 CHAR(1) CCSID 37 DEFAULT NULL ,
QQC16 CHAR(1) CCSID 37 DEFAULT NULL ,
QQC18 CHAR(1) CCSID 37 DEFAULT NULL ,
QQC21 CHAR(2) CCSID 37 DEFAULT NULL ,
QQC22 CHAR(2) CCSID 37 DEFAULT NULL ,
QQC23 CHAR(2) CCSID 37 DEFAULT NULL ,
QQI1 DECIMAL(15, 0) DEFAULT NULL ,
QQI2 DECIMAL(15, 0) DEFAULT NULL ,
QQI3 DECIMAL(15, 0) DEFAULT NULL ,
QQI4 DECIMAL(15, 0) DEFAULT NULL ,
QQI5 DECIMAL(15, 0) DEFAULT NULL ,
QQI6 DECIMAL(15, 0) DEFAULT NULL ,
QQI7 DECIMAL(15, 0) DEFAULT NULL ,
QQI8 DECIMAL(15, 0) DEFAULT NULL ,
QQI9 DECIMAL(15, 0) DEFAULT NULL ,
QQIA DECIMAL(15, 0) DEFAULT NULL ,
QQF1 DECIMAL(15, 0) DEFAULT NULL ,
QQF2 DECIMAL(15, 0) DEFAULT NULL ,
QQF3 DECIMAL(15, 0) DEFAULT NULL ,
QQC61 CHAR(6) CCSID 37 DEFAULT NULL ,
QQC81 CHAR(8) CCSID 37 DEFAULT NULL ,
QQC82 CHAR(8) CCSID 37 DEFAULT NULL ,
QQC83 CHAR(8) CCSID 37 DEFAULT NULL ,
QQC84 CHAR(8) CCSID 37 DEFAULT NULL ,
QQC101 CHAR(10) CCSID 37 DEFAULT NULL ,
QQC102 CHAR(10) CCSID 37 DEFAULT NULL ,
QQC103 CHAR(10) CCSID 37 DEFAULT NULL ,
QQC104 CHAR(10) CCSID 37 DEFAULT NULL ,
QQC105 CHAR(10) CCSID 37 DEFAULT NULL ,
QQC106 CHAR(10) CCSID 37 DEFAULT NULL ,
QQC181 VARCHAR(128) ALLOCATE(18) CCSID 37 DEFAULT NULL ,
QQC182 VARCHAR(128) ALLOCATE(18) CCSID 37 DEFAULT NULL ,
QQC183 VARCHAR(128) ALLOCATE(15) CCSID 37 DEFAULT NULL ,
QQC301 VARCHAR(30) ALLOCATE(10) CCSID 37 DEFAULT NULL ,
QQC302 VARCHAR(30) ALLOCATE(10) CCSID 37 DEFAULT NULL ,
QQC303 VARCHAR(30) ALLOCATE(10) CCSID 37 DEFAULT NULL ,
QQ1000 VARCHAR(1000) ALLOCATE(48) CCSID 37 DEFAULT NULL ,
QQTIM1 TIMESTAMP DEFAULT NULL ,
QQTIM2 TIMESTAMP DEFAULT NULL ,
QVQTBL VARCHAR(128) ALLOCATE(10) CCSID 37 DEFAULT NULL ,
QVQLIB VARCHAR(128) ALLOCATE(10) CCSID 37 DEFAULT NULL ,
QVPTBL VARCHAR(128) ALLOCATE(10) CCSID 37 DEFAULT NULL ,
QVPLIB VARCHAR(128) ALLOCATE(10) CCSID 37 DEFAULT NULL ,
QVINAM VARCHAR(128) ALLOCATE(10) CCSID 37 DEFAULT NULL ,
QVILIB VARCHAR(128) ALLOCATE(10) CCSID 37 DEFAULT NULL ,
QVQTBLI CHAR(1) CCSID 37 DEFAULT NULL ,
QVPTBLI CHAR(1) CCSID 37 DEFAULT NULL ,
QVINAMI CHAR(1) CCSID 37 DEFAULT NULL ,
QVBNDY CHAR(1) CCSID 37 DEFAULT NULL ,
QVJFANO CHAR(1) CCSID 37 DEFAULT NULL ,
QVPARPF CHAR(1) CCSID 37 DEFAULT NULL ,
QVPARPL CHAR(1) CCSID 37 DEFAULT NULL ,
QVC11 CHAR(1) CCSID 37 DEFAULT NULL ,
QVC12 CHAR(1) CCSID 37 DEFAULT NULL ,
QVC13 CHAR(1) CCSID 37 DEFAULT NULL ,
QVC14 CHAR(1) CCSID 37 DEFAULT NULL ,
QVC15 CHAR(1) CCSID 37 DEFAULT NULL ,
QVC16 CHAR(1) CCSID 37 DEFAULT NULL ,
QVC17 CHAR(1) CCSID 37 DEFAULT NULL ,
QVC18 CHAR(1) CCSID 37 DEFAULT NULL ,
QVC19 CHAR(1) CCSID 37 DEFAULT NULL ,
QVC1A CHAR(1) CCSID 37 DEFAULT NULL ,
QVC1B CHAR(1) CCSID 37 DEFAULT NULL ,
QVC1C CHAR(1) CCSID 37 DEFAULT NULL ,
QVC1D CHAR(1) CCSID 37 DEFAULT NULL ,
QVC1E CHAR(1) CCSID 37 DEFAULT NULL ,
QVC1F CHAR(1) CCSID 37 DEFAULT NULL ,
QWC11 CHAR(1) CCSID 37 DEFAULT NULL ,
QWC12 CHAR(1) CCSID 37 DEFAULT NULL ,
QWC13 CHAR(1) CCSID 37 DEFAULT NULL ,
QWC14 CHAR(1) CCSID 37 DEFAULT NULL ,
QWC15 CHAR(1) CCSID 37 DEFAULT NULL ,
QWC16 CHAR(1) CCSID 37 DEFAULT NULL ,
QWC17 CHAR(1) CCSID 37 DEFAULT NULL ,
QWC18 CHAR(1) CCSID 37 DEFAULT NULL ,
QWC19 CHAR(1) CCSID 37 DEFAULT NULL ,
QWC1A CHAR(1) CCSID 37 DEFAULT NULL ,
QWC1B CHAR(1) CCSID 37 DEFAULT NULL ,
QWC1C CHAR(1) CCSID 37 DEFAULT NULL ,
QWC1D CHAR(1) CCSID 37 DEFAULT NULL ,
QWC1E CHAR(1) CCSID 37 DEFAULT NULL ,
QWC1F CHAR(1) CCSID 37 DEFAULT NULL ,
QVC21 CHAR(2) CCSID 37 DEFAULT NULL ,
QVC22 CHAR(2) CCSID 37 DEFAULT NULL ,
QVC23 CHAR(2) CCSID 37 DEFAULT NULL ,
QVC24 CHAR(2) CCSID 37 DEFAULT NULL ,
QVCTIM DECIMAL(15, 0) DEFAULT NULL ,
QVPARD DECIMAL(15, 0) DEFAULT NULL ,
QVPARU DECIMAL(15, 0) DEFAULT NULL ,
QVPARRC DECIMAL(15, 0) DEFAULT NULL ,
QVRCNT DECIMAL(15, 0) DEFAULT NULL ,
QVFILES DECIMAL(15, 0) DEFAULT NULL ,
QVP151 DECIMAL(15, 0) DEFAULT NULL ,
QVP152 DECIMAL(15, 0) DEFAULT NULL ,
QVP153 DECIMAL(15, 0) DEFAULT NULL ,
QVP154 DECIMAL(15, 0) DEFAULT NULL ,
QVP155 DECIMAL(15, 0) DEFAULT NULL ,
QVP156 DECIMAL(15, 0) DEFAULT NULL ,
QVP157 DECIMAL(15, 0) DEFAULT NULL ,
QVP158 DECIMAL(15, 0) DEFAULT NULL ,
QVP159 DECIMAL(15, 0) DEFAULT NULL ,
QVP15A DECIMAL(15, 0) DEFAULT NULL ,
QVP15B DECIMAL(15, 0) DEFAULT NULL ,
QVP15C DECIMAL(15, 0) DEFAULT NULL ,
QVP15D DECIMAL(15, 0) DEFAULT NULL ,
QVP15E DECIMAL(15, 0) DEFAULT NULL ,
QVP15F DECIMAL(15, 0) DEFAULT NULL ,
QVC41 CHAR(4) CCSID 37 DEFAULT NULL ,
QVC42 CHAR(4) CCSID 37 DEFAULT NULL ,
QVC43 CHAR(4) CCSID 37 DEFAULT NULL ,
QVC44 CHAR(4) CCSID 37 DEFAULT NULL ,
QVC81 CHAR(8) CCSID 37 DEFAULT NULL ,
QVC82 CHAR(8) CCSID 37 DEFAULT NULL ,
QVC83 CHAR(8) CCSID 37 DEFAULT NULL ,
QVC84 CHAR(8) CCSID 37 DEFAULT NULL ,
QVC85 CHAR(8) CCSID 37 DEFAULT NULL ,
QVC86 CHAR(8) CCSID 37 DEFAULT NULL ,
QVC87 CHAR(8) CCSID 37 DEFAULT NULL ,
QVC88 CHAR(8) CCSID 37 DEFAULT NULL ,
QVC101 CHAR(10) CCSID 37 DEFAULT NULL ,
QVC102 CHAR(10) CCSID 37 DEFAULT NULL ,
QVC103 CHAR(10) CCSID 37 DEFAULT NULL ,
QVC104 CHAR(10) CCSID 37 DEFAULT NULL ,
QVC105 CHAR(10) CCSID 37 DEFAULT NULL ,
QVC106 CHAR(10) CCSID 37 DEFAULT NULL ,
QVC107 CHAR(10) CCSID 37 DEFAULT NULL ,
QVC108 CHAR(10) CCSID 37 DEFAULT NULL ,
QVC1281 VARCHAR(128) ALLOCATE(10) CCSID 37 DEFAULT NULL ,
QVC1282 VARCHAR(128) ALLOCATE(10) CCSID 37 DEFAULT NULL ,
QVC1283 VARCHAR(128) ALLOCATE(10) CCSID 37 DEFAULT NULL ,
QVC1284 VARCHAR(128) ALLOCATE(10) CCSID 37 DEFAULT NULL ,
QVC3001 VARCHAR(300) ALLOCATE(32) CCSID 37 DEFAULT NULL ,
QVC3002 VARCHAR(300) ALLOCATE(32) CCSID 37 DEFAULT NULL ,
QVC3003 VARCHAR(300) ALLOCATE(32) CCSID 37 DEFAULT NULL ,
QVC3004 VARCHAR(300) ALLOCATE(32) CCSID 37 DEFAULT NULL ,
QVC3005 VARCHAR(300) ALLOCATE(32) CCSID 37 DEFAULT NULL ,
QVC3006 VARCHAR(300) ALLOCATE(32) CCSID 37 DEFAULT NULL ,
QVC3007 VARCHAR(300) ALLOCATE(32) CCSID 37 DEFAULT NULL ,
QVC3008 VARCHAR(300) ALLOCATE(32) CCSID 37 DEFAULT NULL ,
QVC5001 VARCHAR(500) ALLOCATE(32) CCSID 37 DEFAULT NULL ,
QVC5002 VARCHAR(500) ALLOCATE(32) CCSID 37 DEFAULT NULL ,
QVC1000 VARCHAR(1000) ALLOCATE(48) CCSID 37 DEFAULT NULL ,
QWC1000 VARCHAR(1000) ALLOCATE(48) CCSID 37 DEFAULT NULL ,
QQINT01 INTEGER DEFAULT NULL ,
QQINT02 INTEGER DEFAULT NULL ,
QQINT03 INTEGER DEFAULT NULL ,
QQINT04 INTEGER DEFAULT NULL ,
QQSMINT1 SMALLINT DEFAULT NULL ,
QQSMINT2 SMALLINT DEFAULT NULL ,
QQSMINT3 SMALLINT DEFAULT NULL ,
QQSMINT4 SMALLINT DEFAULT NULL ,
QQSMINT5 SMALLINT DEFAULT NULL ,
QQSMINT6 SMALLINT DEFAULT NULL ,
QQ1000L CLOB(2147483647) ALLOCATE(48) CCSID 37 DEFAULT NULL ,
QFC11 CHAR(1) CCSID 37 DEFAULT NULL ,
QFC12 CHAR(1) CCSID 37 DEFAULT NULL ,
QFC13 CHAR(1) CCSID 37 DEFAULT NULL ,
QQCLOB2 CLOB(2147483647) ALLOCATE(48) CCSID 37 DEFAULT NULL ,
QFC14 CHAR(1) CCSID 37 DEFAULT NULL ,
QFC15 CHAR(1) CCSID 37 DEFAULT NULL ,
QFC16 CHAR(1) CCSID 37 DEFAULT NULL ,
QQCLOB3 CLOB(2147483647) CCSID 37 DEFAULT NULL ,
QFC17 CHAR(1) CCSID 37 DEFAULT NULL ,
QFC18 CHAR(1) CCSID 37 DEFAULT NULL ,
QFC19 CHAR(1) CCSID 37 DEFAULT NULL ,
QQDBCLOB1 DBCLOB(1073741823) ALLOCATE(24) CCSID 1200 DEFAULT NULL ,
QFC1A CHAR(1) CCSID 37 DEFAULT NULL ,
QFC1B CHAR(1) CCSID 37 DEFAULT NULL ,
QFC1C CHAR(1) CCSID 37 DEFAULT NULL ,
QQDBCLOB2 DBCLOB(1073741823) CCSID 1200 DEFAULT NULL ,
QFC1D CHAR(1) CCSID 37 DEFAULT NULL ,
QFC1E CHAR(1) CCSID 37 DEFAULT NULL ,
QFC1F CHAR(1) CCSID 37 DEFAULT NULL ,
QQBLOB1 BLOB(2147483647) DEFAULT NULL ,
QXC11 CHAR(1) CCSID 37 DEFAULT NULL ,
QXC12 CHAR(1) CCSID 37 DEFAULT NULL ,
QXC13 CHAR(1) CCSID 37 DEFAULT NULL ,
QXC14 CHAR(1) CCSID 37 DEFAULT NULL ,
QXC15 CHAR(1) CCSID 37 DEFAULT NULL ,
QXC16 CHAR(1) CCSID 37 DEFAULT NULL ,
QXC17 CHAR(1) CCSID 37 DEFAULT NULL ,
QXC18 CHAR(1) CCSID 37 DEFAULT NULL ,
QXC19 CHAR(1) CCSID 37 DEFAULT NULL ,
QXC1A CHAR(1) CCSID 37 DEFAULT NULL ,
QXC1B CHAR(1) CCSID 37 DEFAULT NULL ,
QXC1C CHAR(1) CCSID 37 DEFAULT NULL ,
QXC1D CHAR(1) CCSID 37 DEFAULT NULL ,
QXC1E CHAR(1) CCSID 37 DEFAULT NULL ,
QXC21 CHAR(2) CCSID 37 DEFAULT NULL ,
QXC22 CHAR(2) CCSID 37 DEFAULT NULL ,
QXC23 CHAR(2) CCSID 37 DEFAULT NULL ,
QXC24 CHAR(2) CCSID 37 DEFAULT NULL ,
QXC25 CHAR(2) CCSID 37 DEFAULT NULL ,
QXC26 CHAR(2) CCSID 37 DEFAULT NULL ,
QXC27 CHAR(2) CCSID 37 DEFAULT NULL ,
QXC28 CHAR(2) CCSID 37 DEFAULT NULL ,
QXC29 CHAR(2) CCSID 37 DEFAULT NULL ,
QXC41 CHAR(4) CCSID 37 DEFAULT NULL ,
QXC42 CHAR(4) CCSID 37 DEFAULT NULL ,
QXC43 CHAR(4) CCSID 65535 DEFAULT NULL ,
QXC44 CHAR(4) CCSID 37 DEFAULT NULL ,
QQINT05 INTEGER DEFAULT NULL ,
QQINT06 INTEGER DEFAULT NULL ,
QQINT07 INTEGER DEFAULT NULL ,
QQINT08 INTEGER DEFAULT NULL ,
QQINT09 INTEGER DEFAULT NULL ,
QQINT0A INTEGER DEFAULT NULL ,
QQINT0B INTEGER DEFAULT NULL ,
QQINT0C INTEGER DEFAULT NULL ,
QQINT0D INTEGER DEFAULT NULL ,
QQINT0E INTEGER DEFAULT NULL ,
QQINT0F INTEGER DEFAULT NULL ,
QQSMINT7 SMALLINT DEFAULT NULL ,
QQSMINT8 SMALLINT DEFAULT NULL ,
QQSMINT9 SMALLINT DEFAULT NULL ,
QQSMINTA SMALLINT DEFAULT NULL ,
QQSMINTB SMALLINT DEFAULT NULL ,
QQSMINTC SMALLINT DEFAULT NULL ,
QQSMINTD SMALLINT DEFAULT NULL ,
QQSMINTE SMALLINT DEFAULT NULL ,
QQSMINTF SMALLINT DEFAULT NULL ,
QQTIM12A TIMESTAMP(32) DEFAULT NULL,
QQTIM12B TIMESTAMP(32) DEFAULT NULL,
QVP161 DECIMAL(15,0) DEFAULT NULL,
QVP162 DECIMAL(15,0) DEFAULT NULL,
QQBGINT1 BIGINT DEFAULT NULL,
QQBGINT2 BIGINT DEFAULT NULL)
RCDFMT QQQDBMN ;
RENAME QSYS/QQQDBMN TO SYSTEM NAME QAQQDBMN;
LABEL ON TABLE QSYS/QAQQDBMN
IS 'Database Monitor Physical File' ;
LABEL ON COLUMN QSYS.QAQQDBMN
( QQRID IS 'Record ID' ,
QQTIME IS 'Created Time' ,
QQJFLD IS 'Join Column' ,
QQRDBN IS 'Relational Database Name' ,
QQSYS IS 'System Name' ,
QQJOB IS 'Job Name' ,
QQUSER IS 'Job User' ,
QQJNUM IS 'Job Number' ,
QQUCNT IS 'Unique Counter' ,
QQUDEF IS 'User Defined Column' ,
QQSTN IS 'Statement Number' ,
QQQDTN IS 'Subselect Number' ,
QQQDTL IS 'Subselect Nested Level' ,
QQMATN IS 'Subselect Number of Materialized View' ,
QQMATL IS 'Subselect Level of Materialized View' ,
QQTLN IS 'Library of Table Queried' ,
QQTFN IS 'Name of Table Queried' ,
QQTMN IS 'Member of Table Queried' ,
QQPTLN IS 'Library of Base Table' ,
QQPTFN IS 'Name of Base Table' ,
QQPTMN IS 'Member of Base Table' ,
QQILNM IS 'Library of Index Used' ,
QQIFNM IS 'Name of Index Used' ,
QQIMNM IS 'Member of Index Used' ,
QQNTNM IS 'NLSS Table' ,
QQNLNM IS 'NLSS Library' ,
QQSTIM IS 'Start Time' ,
QQETIM IS 'End Time' ,
QQKP IS 'Key Positioning' ,
QQKS IS 'Key Selection' ,
QQTOTR IS 'Total Rows' ,
QQTMPR IS 'Number of Rows in Temporary' ,
QQJNP IS 'Join Position' ,
QQEPT IS 'Estimated Processing Time' ,
QQDSS IS 'Data Space Selection' ,
QQIDXA IS 'Index Advised' ,
QQORDG IS 'Ordering' ,
QQGRPG IS 'Grouping' ,
QQJNG IS 'Join' ,
QQUNIN IS 'Union' ,
QQSUBQ IS 'Subquery' ,
QQHSTV IS 'Host Variables' ,
QQRCDS IS 'Row Selection' ,
QQRCOD IS 'Reason Code' ,
QQRSS IS 'Number of Rows Selected' ,
QQREST IS 'Estimated Number of Rows Selected' ,
QQRIDX IS 'Number of Entries in Index Created' ,
QQFKEY IS 'Estimated Entries for Key Positioning' ,
QQKSEL IS 'Estimated Entries for Key Selection' ,
QQAJN IS 'Estimated Number of Joined Rows' ,
QQIDXD IS 'Advised Key Columns' ,
QQI9 IS 'Thread Identifier' ,
QVQTBL IS 'Queried Table Long Name' ,
QVQLIB IS 'Queried Library Long Name' ,
QVPTBL IS 'Base Table Long Name' ,
QVPLIB IS 'Base Library Long Name' ,
QVINAM IS 'Index Used Long Name' ,
QVILIB IS 'Index Used Library Name' ,
QVQTBLI IS 'Table Long Required' ,
QVPTBLI IS 'Base Long Required' ,
QVINAMI IS 'Index Long Required' ,
QVBNDY IS 'I/O or CPU Bound' ,
QVJFANO IS 'Join Fan Out' ,
QVPARPF IS 'Parallel Pre-Fetch' ,
QVPARPL IS 'Parallel Pre-Load' ,
QVCTIM IS 'Estimated Cumulative Time' ,
QVPARD IS 'Parallel Degree Requested' ,
QVPARU IS 'Parallel Degree Used' ,
QVPARRC IS 'Parallel Limited Reason Code' ,
QVRCNT IS 'Refresh Count' ,
QVFILES IS 'Number of Tables Joined' ) ;
LABEL ON COLUMN QSYS.QAQQDBMN
( QQRID TEXT IS 'Record ID' ,
QQTIME TEXT IS 'Time record was created' ,
QQJFLD TEXT IS 'Join Column' ,
QQRDBN TEXT IS 'Relational Database Name' ,
QQSYS TEXT IS 'System Name' ,
QQJOB TEXT IS 'Job Name' ,
QQUSER TEXT IS 'Job User' ,
QQJNUM TEXT IS 'Job Number' ,
QQUCNT TEXT IS 'Unique Counter' ,
QQUDEF TEXT IS 'User Defined Column' ,
QQSTN TEXT IS 'Statement Number' ,
QQQDTN TEXT IS 'Subselect Number' ,
QQQDTL TEXT IS 'Subselect Nested Level' ,
QQMATN TEXT IS 'Subselect Number of Materialized View' ,
QQMATL TEXT IS 'Subselect Level of Materialized View' ,
QQTLN TEXT IS 'Library of Table Queried' ,
QQTFN TEXT IS 'Name of Table Queried' ,
QQTMN TEXT IS 'Member of Table Queried' ,
QQPTLN TEXT IS 'Base Table Library' ,
QQPTFN TEXT IS 'Base Table' ,
QQPTMN TEXT IS 'Base Table Member' ,
QQILNM TEXT IS 'Library of Index Used' ,
QQIFNM TEXT IS 'Name of Index Used' ,
QQIMNM TEXT IS 'Member of Index Used' ,
QQNTNM TEXT IS 'NLSS Table' ,
QQNLNM TEXT IS 'NLSS Library' ,
QQSTIM TEXT IS 'Start timestamp' ,
QQETIM TEXT IS 'End timestamp' ,
QQKP TEXT IS 'Key positioning' ,
QQKS TEXT IS 'Key selection' ,
QQTOTR TEXT IS 'Total row in table' ,
QQTMPR TEXT IS 'Number of rows in temporary' ,
QQJNP TEXT IS 'Join Position' ,
QQEPT TEXT IS 'Estimated processing time' ,
QQDSS TEXT IS 'Data Space Selection' ,
QQIDXA TEXT IS 'Index advised' ,
QQORDG TEXT IS 'Ordering' ,
QQGRPG TEXT IS 'Grouping' ,
QQJNG TEXT IS 'Join' ,
QQUNIN TEXT IS 'Union' ,
QQSUBQ TEXT IS 'Subquery' ,
QQHSTV TEXT IS 'Host Variables' ,
QQRCDS TEXT IS 'Row Selection' ,
QQRCOD TEXT IS 'Reason Code' ,
QQRSS TEXT IS 'Number of rows selected or sorted' ,
QQREST TEXT IS 'Estimated number of rows selected' ,
QQRIDX TEXT IS 'Number of entries in index created' ,
QQFKEY TEXT IS 'Estimated keys for key positioning' ,
QQKSEL TEXT IS 'Estimated keys for key selection' ,
QQAJN TEXT IS 'Estimated number of joined rows' ,
QQIDXD TEXT IS 'Key columns for the index advised' ,
QQI9 TEXT IS 'Thread Identifier' ,
QVQTBL TEXT IS 'Queried Table, Long Name' ,
QVQLIB TEXT IS 'Queried Library, Long Name' ,
QVPTBL TEXT IS 'Base Table, Long Name' ,
QVPLIB TEXT IS 'Base Library, Long Name' ,
QVINAM TEXT IS 'Index Used, Long Name' ,
QVILIB TEXT IS 'Index Used, Libary Name' ,
QVQTBLI TEXT IS 'Table Long Required' ,
QVPTBLI TEXT IS 'Base Long Required' ,
QVINAMI TEXT IS 'Index Long Required' ,
QVBNDY TEXT IS 'I/O or CPU Bound' ,
QVJFANO TEXT IS 'Join Fan out' ,
QVPARPF TEXT IS 'Parallel Pre-Fetch' ,
QVPARPL TEXT IS 'Parallel Pre-Load' ,
QVCTIM TEXT IS 'Cumulative Time' ,
QVPARD TEXT IS 'Parallel Degree, Requested' ,
QVPARU TEXT IS 'Parallel Degree, Used' ,
QVPARRC TEXT IS 'Parallel Limited, Reason Code' ,
QVRCNT TEXT IS 'Refresh Count' ,
QVFILES TEXT IS 'Number of, Tables Joined' ) ;