Table record count record (DTBC)
Record status: Db2 specific
Field name | Offset | Definition | Description | |
|---|---|---|---|---|
Dec | Hex | |||
CNTLRECORDTYPE | 00 | 00 | CHAR(4) | Control record type: DTBC - Table Record Count Record |
SYSID | 04 | 04 | CHAR(4) | Originating SYSID |
DBID | 08 | 08 | CHAR(4) | Originating Database ID (Hex) |
TBOBID | 12 | 0C | CHAR(4) | Originating Table ID (Hex) |
SQLTYPE | 16 | 10 | CHAR(1) | U - UNDO R - REDO |
INSERTCOUNT | 17 | 11 | CHAR(10) | Number of nonRI insert records |
DELETECOUNT | 27 | 1B | CHAR(10) | Number of nonRI delete records |
UPDATECOUNT | 37 | 25 | CHAR(10) | Number of nonRI update records |
RIDELETECOUNT | 47 | 2F | CHAR(10) | Number of delete records due to RI |
RIUPDATECOUNT | 57 | 39 | CHAR(10) | Number of update records due to RI |
TRIGINSERTCOUNT | 67 | 43 | CHAR(10) | Number of insert records due to trigger activity |
TRIGDELETECOUNT | 77 | 4D | CHAR(10) | Number of delete records due to trigger activity |
TRIGUPDATECOUNT | 87 | 57 | CHAR(10) | Number of update records due to trigger activity |
(Total Length) | 97 | 61 | Not applicable | Not applicable |