.
Fast index traversal block table (DMRAUFTB)
The fast index traversal block table (DMRAUFTB) defines all the fields in IFCID 389.
The following table describes the columns in the DMRAUFTB table.
Performance Report Column Name | SMF Field Name | Used in Report | Field Type | Description |
|---|---|---|---|---|
DMRTABLEVERSION | Not applicable | NO | Char(8) | Version of BMC AMI Ops Monitor for Db2 Performance Reporter that created or modified the table definition |
DMRVERSION | Not applicable | NO | Char(8) | Version of BMC AMI OpsM 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) |
PLANNAME | 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 |
MONTH | QWACESC | NO | Char(2) | Month from datetime |
DAY | QWACESC | NO | Char(2) | Day from datetime |
YEAR | QWACESC | YES | Char(4) | Year 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 |
IFCIDSEQ# | QWHSISEQ | NO | Integer | IFCID sequence number |
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 |
PSTNUMBER | 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 |
DMRACSHARE | None | NO | Integer | DMR column used only as a marker during BMC AMI Ops configuration to delete data sharing columns, if requested |
DMRAUTOCUST | None | NO | Integer | DMR column used only as a marker during BMC AMI Ops configuration; 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 BMC AMI Ops configuration option |
DMRAUTOLONG | None | NO | Integer | DMR column used only as a marker during BMC AMI Ops configuration; 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 BMC AMI Ops configuration option |
AUTHID_L | QWHCAID | NO | Varchar(128) | Long name version of the authorization ID |
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 |
LOCATION_L | QWHSLOCN | NO | Varchar(128) | Long name version of the local location (Db2 subsystem ID if not defined) |
CONTEXTNAME_L | QWHCTCXT | NO | Varchar(128) | Trusted context name |
ROLENAME_L | QWHCROLE | NO | Varchar(128) | Associated role name |
ORIGAPPLUSER_L | QWHCOAUD | NO | Varchar(128) | Original application user ID |
NUMFTBINDEX | QW0389NU | NO | Smallint | Number of indexes with FTBs |
DATABASEID | QW0389DB | NO | Char(6) | Database ID |
INXPGSETID | QW0389OB | NO | Char(6) | Index Pageset ID |
PARTITIONNUM | QW0389PT | NO | Char(6) | Partition Number |
INXLVLFTB | QW0389LV | NO | Char(6) | Number of index levels in FTB |
FTBSIZEBYT | QW0389SZ | NO | Integer | Size of FTB in bytes |
(PTF BPD5063 applied) INDEXNUMBER | None | NO | Integer | Index number |