Record format: DBD variable segment
The following table describes the DBD variable segment of the transaction log record.
Element label | Element name and description | Format | Length | Offset | |
|---|---|---|---|---|---|
Dec | Hex | ||||
-- | DBD SEGMENT Database segments are maintained for each DBD referenced in processing this transaction The maximum number of segments is defined by the DBT parameter in BBPARM. | Group | 62 | 000 | 000 |
DBTDBNAM | DATA BASE NAME FROM PCB Name of the database If the maximum number of segments is exceeded, an overflow segment is created with OTHERS in this field. If the Event Collector DBIO data collection parameter is set to IOWAITS, a special segment, ALLDBS, can be created to account for sync point write activity. | Display | 8 | 000 | 000 |
DBTDBTYP | DB ORGANIZATION Code that identifies the type of organization used for this database:
| Binary | 1 | 008 | 008 |
DBTFLAG1 | FLAG BYTE 1 Special database flag:
| Binary | 1 | 009 | 009 |
DBTDMBSZ | TOTAL DMB SPACE FOR DATA BASE Amount of DMB buffer pool space required by this database, expressed in units of 8 bytes If the database is DEDB with more than 2048 areas, then it is expressed in units of 32 bytes. | Binary | 2 | 010 | 00A |
DBTFLAG2 | FLAG BYTE 2 Special database flag:
| Binary | 1 | 012 | 00C |
DBTFLAG3 | FLAG BYTE 3 Special database flag:
| Binary | 1 | 013 | 00D |
DBTDDNNO | DDN-DBTNO Chain of pointers for the DD segments for this database If the X'04' bit in DBTFLAG3 is set, X'100' is added to this value. | Binary | 1 | 014 | 00E |
DBTSECNO | SEC-DBTNO (OVERFLOW) Overflow pointer to next overflow segment If the X'02' bit in DBTFLAG3 is set, X'100'is added to this value. | Binary | 1 | 015 | 00F |
The element at this position varies based on the setting of DBTFLAG1:
| The bytes at this position vary based on the setting of DBTFLAG1:
| Binary | 4 | 016 | 010 |
The element at this position varies based on the setting of DBTFLAG1:
| The bytes at this position vary based on the setting of DBTFLAG1:
| Binary | 4 | 020 | 014 |
DBTREPL | REPLACE COUNT Number of times a replace was requested in processing this transaction | Binary | 2 | 024 | 018 |
DBTOTHER | OTHER COUNT Number of system service calls issued against this database by the transaction | Binary | 2 | 026 | 01A |
DBTKEYR | KEY READ COUNT Number of reads issued to the key sequence data area in satisfying the DL/I requests | Binary | 2 | 028 | 01C |
DBTKEYW | KEY WRITE COUNT Number of writes issued to the key sequence data area in satisfying the DL/I requests | Binary | 2 | 030 | 01E |
DBTNKEYR | NONKEY READ COUNT Number of reads issued to the OSAM or entry sequence data area in satisfying the DL/I requests | Binary | 2 | 032 | 020 |
DBTNKEYW | NONKEY WRITE COUNT Number of writes issued to the OSAM or entry sequence data area in satisfying the DL/I requests | Binary | 2 | 034 | 022 |
The element at this position varies based on the setting of BHTO:
| The bytes at this position vary based on the setting of BHTO:
| Binary | 2 | 036 | 024 |
The element at this position varies based on the setting of BHTO:
| The bytes at this position vary based on the setting of BHTO:
| Binary | 2 | 038 | 026 |
DBTCTLIO | NO OF I/O IN CTL RGN Number of I/Os that occurred under a serialized IMS task (in the control region or DLISAS region) instead of under the dependent region task | Binary | 2 | 040 | 028 |
DBTFWX | FULL WORD COUNTER INDEX If a counter overflow occurred, this element is the index to the counter affected (hexadecimal offset of the elements in the DBD variable segment that overflowed into the overflow fullword counter at decimal offset 054) | Binary | 2 | 042 | 02A |
DBTFWC | FULL WORD COUNTER If a counter overflow occurred, this fullword is used to hold this larger value | Binary | 4 | 044 | 02C |
DBTDBVER | DBTDBVER IMS database version number | Binary | 4 | 48 | 030 |
-- | RESERVED | Binary | 4 | 52 | 034 |
Related topic