Record format: DB2 variable segment (optional)
The following tables describes the DB2 variable segment of the MainView for IMS transaction log record:
Element label | Element name and description | Format | Length | Offset | |
|---|---|---|---|---|---|
DEC | HEX | ||||
-- | DB2 SEGMENT Redefines the DBD SEGMENT If DBTDBTYP for the DBD is DB2 (X'80'), there is only one record per transaction. | Group | 48 | 000 | 000 |
DBTPLAN | DB2 PLAN NAME DB2 plan name for this transaction | Group | 8 | 000 | 000 |
-- | ORGANIZATION TYPE FOR DB2 Adds X'80' to indicate this is a special segment for DB2 calls | Display | 1 | 008 | 008 |
-- | RESERVED | Binary | 3 | 009 | 009 |
DB2SEL | # SELECT/FETCH CALLS Number of SQL SELECT and FETCH calls made to DB2 | Binary | 4 | 012 | 00C |
DB2OPEN | # OPEN CALLS Number of SQL OPEN calls made to DB2 | Binary | 4 | 016 | 010 |
DB2ISRT | # INSERT CALLS Number of SQL INSERT calls made to DB2 | Binary | 4 | 020 | 014 |
DB2DLET | # DELETE CALLS Number of SQL DELETE calls made to DB2 | Binary | 4 | 024 | 018 |
DB2UPD | # UPDATE CALLS Number of SQL UPDATE calls made to DB2 | Binary | 4 | 028 | 01C |
DB2DDL | # DATA DEF LANG CALLS Number of SQL Data Definition Language calls made to DB2 (CREATE, DROP, ALTER, COMMENT and LABEL) | Binary | 2 | 032 | 020 |
DB2DYN | # DYNAMIC SQL CALLS Number of SQL dynamic calls made to DB2 (PREPARE, DESCRIBE and EXECUTE) | Binary | 2 | 034 | 022 |
DB2CTRL | # DB2 CONTROL CALLS Number of SQL control type calls made to DB2 (GRANT, REVOKE) | Binary | 2 | 036 | 024 |
DB2OTHER | # OTHER CALLS TO DB2 Number of other SQL control type calls made to DB2 (EXPLAIN, LOCK, LABEL, CLOSE) | Binary | 2 | 038 | 026 |
DB2SSID | DB2SSID DB2 subsystem ID | Display | 4 | 040 | 028 |
-- | RESERVED | Binary | 12 | 044 | 02C |