DDL access table (DMRAUDDL)
The DDL access table (DMRAUDDL) is used to produce the DDL Access Report.
It requires audit class 3 and defines all the fields in IFCID 142.
The following table describes the columns in the DMRAUDDL table.
Performance Report Column Name | SMF Field Name | Used in Report | Field Type | Description |
|---|---|---|---|---|
DMRTABLEVERSION | Not applicable | NO | Char(8) | Version of MainView for DB2 Performance Reporter that created or modified the table definition |
DMRVERSION | Not applicable | NO | Char(8) | Version of MainView for DB2 Performance Reporter that created or modified the row |
DB2VERSION | QWHSRN QWHSSUBV | NO | Char(6) | Version of DB2 that created the record For versions of DB2 before 8.1, a value of 0000 is used for QWHSSUBV because the field was not defined. |
SYSTEMID | SM102SID | YES | Char(4) | System ID (SMF ID) |
SUBSYSTEM | SM102SSI | YES | Char(4) | Subsystem ID (DB2 subsystem name) |
PLAN | QWHCPLAN | YES | Char(8) | Plan name |
AUTHID | QWHCAID | YES | Char(8) | Primary authorization ID |
CONNECTION | QWHCCN | NO | Char(8) | Connection name |
DATETIME | QWACESC | YES | Time stamp | Date/time stamp - end thread time |
DATE | QWACESC | YES | Date | Date from datetime |
YEAR | QWACESC | YES | Char(4) | Year from datetime |
MONTH | QWACESC | NO | Char(2) | Month from datetime |
DAY | QWACESC | NO | Char(2) | Day from datetime |
TIME | QWACESC | YES | Time | Time from datetime |
HOUR | QWACESC | NO | Char(2) | Hour from datetime |
DAYOFWEEK# | QWACESC | NO | Smallint | Relative day of week, 1 to 7, where Monday=1 and Sunday=7 |
DAYOFWEEK | QWACESC | NO | Char(3) | MON, TUE, WED, THU, FRI, SAT, SUN |
WEEK# | QWACESC | NO | Integer | Week number relative to the 1 January 1900 epoch |
LOCATION | QWHSLOCN | YES | Char(16) | Local location name (DB2 subsystem ID if not defined) |
GROUPNAME | QWHADSGN | YES | Char(8) | Data sharing group name |
MEMBERNAME | QWHAMEMN | YES | Char(8) | Data sharing member name |
ACCTTOKN | QWHCTOKN | NO | Char(22) | Accounting token for CICS |
PSTNUMBR | QWHCCV | NO | Char(4) | PST number - IMS only |
PSBNAME | QWHCCV | NO | Char(8) | PSB name - IMS only |
CICSTRAN | QWHCCV | NO | Char(4) | Transaction code - CICS only |
CORRID | QWHCCV | NO | Char(12) | Correlation ID |
ORIGPRIMID | QWHCOPID | NO | Char(8) | Original primary ID |
CONNTYPE | QWHCATYP | NO | Char(8) | Connection type, based on the value in QWHCATYP For a list of connection types, see the description of CONNTYPE in Accounting-detail-and-summary-tables-DMRACxxx. |
REQLOCATION | QWHDRQNM | NO | Char(16) | Requestor location name |
DBID | QW0142DB | YES | Smallint | Database ID |
TABLEID | QW0142OB | YES | Smallint | Table object ID |
DBNAME | QW0142DB | YES | Char(8) | Database name |
TABLENAME | QW0142TN | YES | Char(18) | Table name |
TABLEOWNER | QW0142OW | YES | Char(8) | Table owner |
TABLECREATOR | QW0142CR | YES | Char(8) | Table creator |
STMTTYPE | QW0142AC | YES | Char(8) | SQL statement type |
IDTYPE | QW0142OR | NO | Char(1) | One of the following identifier types:
|
LUWIDNID | QWHSNID | NO | Char(8) | LU of Work - network ID |
LUWIDLUNM | QWHSLUNM | NO | Char(8) | LU of Work - logical unit name |
LUWIDINST | QWHSLUUV | NO | Char(6) | LU of Work - instance value |
LUWIDCOMIT | QWHSLUCC | NO | Smallint | LU of Work - COMMIT count |
TRACEMASK | QWHSMTN | NO | Integer | Active trace mask |
IFCIDSEQ# | QWHSISEQ | NO | Integer | IFCID sequence number |
SQLTEXTLEN | QW0142TX | NO | Integer | SQL text length |
SQLTEXT | QW0142TX | YES | Varchar(4000) | SQL text |
SECLABEL | QW0142SL | NO | Char(8) | Security label |
MULTISEC | QW0142ML | NO | Char(1) | Multilevel security |
DMRACSHARE | None | NO | Integer | DMR column used only as a marker during MainView customization to delete data sharing columns, if requested |
DMRAUTOCUST | None | NO | Integer | DMR column used only as a marker during MainView customization; all columns following this one (up to DMRAUTOLONG) in the create table member are not used in the reports (NO in Used in Report column) and can be deleted as a group as a MainView customization option |
DMRAUTOLONG | None | NO | Integer | DMR column used only as a marker during MainView customization; all columns following this one in the create table member are long name versions of the corresponding fields and can be deleted as a group as a MainView customization option |
AUTHID_L | QWHCAID | NO | Varchar(128) | Long name version of the authorization ID |
LOCATION_L | QWHSLOCN | NO | Varchar(128) | Long name version of the local location (DB2 subsystem ID if not defined) |
ORIGPRIMID_L | QWHCOPID | NO | Varchar(128) | Long name version of the original primary ID |
REQLOCATION_L | QWHDRQNM | NO | Varchar(128) | Long name version of the distributed transaction requestor location |
TABLENAME_L | QW0142TN | NO | Varchar(128) | Long name version of the table name |
TABLEOWNER_L | QW0142OW | NO | Varchar(128) | Long name version of the table owner |
Related topic