DDF statistics table (DMRSTDF)
The following table describes the columns in the DMRSTDF and DRMSDSUM tables.
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 |
SYSTEMID | SM100SID | YES | Char(4) | System ID (SMF ID) |
Subsystem | SM100SSI | YES | Char(4) | Subsystem ID - name of Db2 subsystem |
QWHS - Standard Header | ||||
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 yet defined. |
INTERVAL | None | YES | Integer | Interval for the summary accounting table |
TRANSCNT | QWACPCNT for rollup records, otherwise, see description | YES | Integer | Transaction thread count For summary tables, this field contains the number of transactions that were used to calculate the column values. |
IFCIDSEQ# | QWHSISEQ | NO | Integer | IFCID sequence number |
DateTIME | QWHSSTCK | YES | Time stamp | Date and time record was created |
Date | QWHSSTCK | YES | Date | Date record was created |
YEAR | QWHSSTCK | YES | Char(4) | Year record was created |
MONTH | QWHSSTCK | YES | Char(2) | Month record was created |
DAY | QWHSSTCK | YES | Char(2) | Day record was created |
Time | QWHSSTCK | YES | Time | Time record was created |
HOUR | QWHSSTCK | YES | Char(2) | Hour record was created |
DAYOFWEEK# | QWHSSTCK | NO | Smallint | Relative day of week, 1 to 7, where Monday=1 and Sunday=7 |
DAYOFWEEK | QWHSSTCK | NO | Char(3) | MON, TUE, WED, THU, FRI, SAT, SUN |
WEEK# | QWHSSTCK | 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) |
QWHA - Data Sharing | ||||
GROUPNAME | QWHADSGN | YES | Char(8) | Data sharing group name |
MEMBERNAME | QWHAMEMN | YES | Char(8) | Data sharing member name |
QLST - Distributed Data Facility | ||||
DDFLOCATION | QLSTLOCN | YES | Char(16) | Name of the remote location |
SQLSENT | QLSTSQLS | YES | Integer | SQL statements sent |
SQLRECV | QLSTSQLR | YES | Integer | SQL statements received |
RowsENT | QLSTROWS | YES | Integer | Rows sent |
ROWRECV | QLSTROWR | YES | Integer | Rows received |
BYTESENT | QLSTBYTS | NO | Integer | Bytes sent |
BYTERECV | QLSTBYTR | NO | Integer | Bytes received |
CONVSENT | QLSTCNVS | YES | Integer | Conversations initiated from this site |
CONVRECV | QLSTCNVR | YES | Integer | Conversations initiated to this site |
MSGSSENT | QLSTMSGS | NO | Integer | Messages sent |
MSGSRECV | QLSTMSGR | NO | Integer | Messages received |
TRANSENT | QLSTTRNS | YES | Integer | Transactions migrated to remote |
TRANRECV | QLSTTRNR | YES | Integer | Transactions migrated from remote |
COMMITSENT | QLSTCOMS | NO | Integer | Commits sent |
COMMITRECV | QLSTCOMR | NO | Integer | Commits received |
ABORTSENT | QLSTABRS | NO | Integer | Rollbacks sent |
ABORTRECV | QLSTABRR | NO | Integer | Rollbacks received |
CONVQUED | QLSTCNVQ | YES | Integer | Conversation requests queued |
SWLIMBLK | QLSTCBLB | NO | Integer | Switch to limited block protocol |
SQLBOUND | QLSTRBND | NO | Integer | SQL bound for remote access |
RowsBUFF | QLSTBROW | NO | Integer | Number of rows in buffer |
BLKSENT | QLSTBTBF | YES | Integer | Blocks sent using block fetch |
BLKRECV | QLSTBRBF | YES | Integer | Blocks received using block fetch |
PREPAREQSENT | QLSTPRSE | YES | Integer | Number of PREPARE requests sent to participant |
PREPAREQSREC | QLSTPRRC | YES | Integer | Number of PREPARE requests received from coordinator |
LASTAGNTSENT | QLSTLASE | YES | Integer | Number of LAST AGENT requests sent to coordinator |
LASTAGENTREC | QLSTLARC | YES | Integer | Number of LAST AGENT requests received from initiator |
COMMITRQSENT | QLSTCRSE | YES | Integer | Number of COMMIT requests sent to participant |
COMMITREQREC | QLSTCRRC | YES | Integer | Number of COMMIT requests received from coordinator |
BACKOUTSSENT | QLSTBKSE | YES | Integer | Number of BACKOUT requests sent to participant |
BACKOUTRQREC | QLSTBKRC | YES | Integer | Number of BACKOUT requests received from coordinator |
FORGETRPSENT | QLSTRRSE | NO | Integer | Number of FORGET responses sent to coordinator |
FORGETRESREC | QLSTRRRC | NO | Integer | Number of FORGET responses received from participant |
RQCOMMITSENT | QLSTVYSE | YES | Integer | Number of request COMMIT responses sent to coordinator |
REQCOMMITREC | QLSTVYRC | YES | Integer | Number of request COMMIT responses received from participant |
BKOUTRSPSENT | QLSTVNSE | NO | Integer | Number of BACKOUT responses sent to coordinator |
BKOUTRESPREC | QLSTVNRC | NO | Integer | Number of BACKOUT responses received from participant |
INDOUBTREMCO | QLSTINDT | YES | Integer | Number of threads indoubt with remote location as coordinator |
COMMITREMTCO | QLSTCPTR | YES | Integer | Number of COMMIT operations with remote location as coordinator |
ROLLBKREMTCO | QLSTRBTR | YES | Integer | Number of ROLLBACK operations with remote location as coordinator |
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 |
LOCATION_L | QWHSLOCN | NO | Varchar(128) | Long name version of the local location (Db2 subsystem ID if not defined) |
DDFLOCATION_L | QLSTLOCN | NO | Varchar(128) | Long name version of the remote location |
NBRCONVDEALLOC | QLSTCNVT | NO | Bigint | Number of conversations deallocated |