DPMOUT Record

The externalized DPMOUT data is a sequential data set with variable-length records. The following table outlines the format of the DPMOUT record.

Note: Do not use this record as a programming interface.
The DPMOUT record consists of the following sections:
  • Header
  • Product data section showing:
    • Instrumentation data
    • CPU data
    • DDF data
    • Data sharing information
  • Repeating section information
  • DBID and OBID translation information
The following tables show the layout of the DPMOUT record:
  • DPMOUT header
    Table 1. Layout of the DPMOUT Record (DPMOUT header)
    Offset Length Data Type Field Description
    0 2 FIXED Record length
    2 2 FIXED Reserved (zeros)
    4 3 CHAR 'DPM'
    7 1 FIXED DB2PM version release flag
    8 4 FIXED Full record length
    12 60 CHAR SORT Key
    12 16 CHAR Location (EBCDIC)
    28 8 CHAR Group name
    36 4 CHAR Subsystem identifier
    40 8 CHAR Member
    48 8 CHAR SORT timestamp
    56 1 CHAR Destination code
    57 4 CHAR Destination sequence number
    61 2 CHAR Split record sequence no.
    63 9 CHAR Reserved
    72 1 BIT 0 Record processing flags
    73 3 CHAR Reserved
    76 8 CHAR TIMEZONE adjusted timestamp
    84 12 CHAR Correlation name (translated)
    96 8 CHAR Correlation number (translated)
    104 8 CHAR Connecting system type
    112 1 BIT 0 Record type flag
    113 1 CHAR Correlation data present
    114 1 CHAR CPU data present
    115 1 CHAR DDF data present
    116 4 PTR Offset to DBID/OBID section
    120 2 FIXED Length to DBID/OBID section
    122 2 FIXED Number to DBID/OBID section
    124 2 FIXED Offset to DBID/OBID strings
    126 2 FIXED length of DBID/OBID strings
    128 2 FIXED Total no. of split records
    130 2 FIXED Offset to long identifier
    132 2 FIXED Length of DPM0 header and
    134 2 FIXED Reserved
  • Product Data, Instrumentation Data
    Table 2. Layout of the DPMOUT Record (Product Data, Instrumentation Data)
    Offset Length Data Type Field Description
    136 3 CHAR Reserved
    139 1 FIXED Resource manager id
    140 2 FIXED IFCID
    142 1 FIXED Self defining area count
    143 1 FIXED Db2® version/release
    144 4 PTR ACE address
    148 4 CHAR Subsystem name
    152 8 CHAR Store clock value of header
    160 4 FIXED IFCID sequence number
    164 4 FIXED Destination sequence number
    168 4 FIXED Active trace number mask
    172 16 CHAR Local location name
    188 24 CHAR Logical unit of work ID (LUWID)
    188 8 CHAR Net id
    196 8 CHAR LU name
    204 6 CHAR Instance number
    210 2 CHAR Commit count
    212 1 BIT 0 QWHS_Flags
    212 1 BIT 1 Reserved
    213 1 BIT 0 Reserved
    214 2 FIXED Offset to long location
    216 2 FIXED Record sub-version
    218 2 CHAR Reserved
  • Product Data, Correlation Data
    Table 3. Layout of the DPMOUT Record (Product Data, Correlation Data)
    Offset Length Data Type Field Description
    220 8 CHAR Authorization id
    228 12 CHAR Correlation id
    240 8 CHAR Connection id
    248 8 CHAR Plan name
    256 8 CHAR Original operator id
    264 4 FIXED Connecting system type code
    268 22 CHAR Accounting token
    290 2 CHAR Reserved
    292 66 CHAR End user workstation data
    292 16 CHAR End user workstation userID
    308 32 CHAR End user workstation trans.
    340 18 CHAR End user workstation name
    358 2 FIXED Offset to long auth id
    360 2 FIXED Offset to long oper id
    362 2 FIXED Offset to long euser id
  • Product Data, CPU Data
    Table 4. Layout of the DPMOUT Record (Product Data, CPU Data)
    Offset Length Data Type Field Description
    364 8 CHAR CPU time
    372 2 FIXED Count field reserved (s)
    374 2 FIXED Reserved
  • Product Data, DDF Data
    Table 5. Layout of the DPMOUT Record (Product Data, DDF Data)
    Offset Length Data Type Field Description
    376 16 CHAR Requester location name
    392 8 CHAR STCK for DBAT trace records
    400 16 CHAR Server name
    416 8 CHAR PRDID parm (Db2 2.3)
    424 2 FIXED Offset to requester name
    426 2 FIXED Offset to server name
  • Product Data, Data Sharing
    Table 6. Layout of the DPMOUT Record (Product Data, Data Sharing)
    Offset Length Data Type Field Description
    428 8 CHAR Db2 Member name
    436 8 CHAR Db2 data sharing group
  • Self-Defining Sections
    Table 7. Layout of the DPMOUT Record (Self-Defining Sections)
    Offset Length Data Type Field Description
    444 4 PTR Data section 1 offset
    448 2 FIXED Data section 1 length
    450 2 FIXED Data section 1 count
    452 4 PTR Data section 2 offset
    456 2 FIXED Data section 2 length
    458 2 FIXED Data section 2 count
    460 4 PTR Data section 3 offset
    464 2 FIXED Data section 3 length
    466 2 FIXED Data section 3 count
    468 4 PTR Data section 4 offset
    472 2 FIXED Data section 4 length
    474 2 FIXED Data section 4 count
    476 4 PTR Data section 5 offset
    480 2 FIXED Data section 5 length
    482 2 FIXED Data section 5 count
    484 4 PTR Data section 6 offset
    488 2 FIXED Data section 6 length
    490 2 FIXED Data section 6 count
    492 4 PTR Data section 7 offset
    496 2 FIXED Data section 7 length
    498 2 FIXED Data section 7 count
    500 4 PTR Data section 8 offset
    504 2 FIXED Data section 8 length
    506 2 FIXED Data section 8 count
    508 4 PTR Data section 9 offset
    512 2 FIXED Data section 9 length
    514 2 FIXED Data section 9 count
    516 4 PTR Data section 10 offset
    520 2 FIXED Data section 10 length
    522 2 FIXED Data section 10 count
    524 4 PTR Data section 11 offset
    528 2 FIXED Data section 11 length
    530 2 FIXED Data section 11 count
    532 4 PTR Data section 12 offset
    536 2 FIXED Data section 12 length
    538 2 FIXED Data section 12 count
    540 4 PTR Data section 13 offset
    544 2 FIXED Data section 13 length
    546 2 FIXED Data section 13 count
    548 4 PTR Data section 14 offset
    552 2 FIXED Data section 14 length
    554 2 FIXED Data section 14 count
    556 4 PTR Data section 15 offset
    560 2 FIXED Data section 15 length
    562 2 FIXED Data section 15 count
    564 4 PTR Data section 16 offset
    568 2 FIXED Data section 16 length
    570 2 FIXED Data section 16 count
    572 2 FIXED Reserved
  • DBID/OBID Translation
    Table 8. Layout of the DPMOUT Record (DBID/OBID Translation)
    Offset Length Data Type Field Description
    0 2 FIXED Offset to DBID/OBID section
    2 2 FIXED OBID number
    4 8 CHAR Database name
    12 8 CHAR Table or index space name
    20 2 FIXED Offset to index name
    22 1 CHAR Pageset type: I,T,U
    23 1 CHAR Reserved
    24 4 FIXED Object size in pages