Product section
The product section for all record types contains the standard header. The other headers (correlation, CPU, distributed, and data sharing data) might also be present.
The following table shows
the contents of the product section standard header.
| Hex Offset | Macro DSNDQWHS field | Description |
|---|---|---|
| 0 | QWHSLEN | Length of standard header |
| 2 | QWHSTYP | Header type |
| 3 | QWHSRMID | RMID |
| 4 | QWHSIID | IFCID |
| 6 | QWHSRELN | Release number section |
| 6 | QWHSNSDA | Number of self-defining sections |
| 7 | QWHSRN | Db2 release identifier |
| 8 | QWHSACE | ACE address |
| C | QWHSSSID | Subsystem ID |
| 10 | QWHSSTCK | Timestamp—STORE CLOCK value assigned by Db2 |
| 18 | QWHSISEQ | IFCID sequence number |
| 1C | QWHSWSEQ | Destination sequence number |
| 20 | QWHSMTN | Active trace number mask |
| 24 | QWHSLOCN | Local location Name |
| 34 | QWHSLWID | Logical unit of work ID |
| 34 | QWHSNID | Network ID |
| 3C | QWHSLUNM | LU name |
| 44 | QWHSLUUV | Uniqueness value |
| 4A | QWHSLUCC | Commit count |
| 4C | QWHSFLAG | Flags |
| 4E | QWHSLOCN_Off | If QWHSLOCN is truncated, this is the offset from the beginning of QWHS to QWHSLOCN_LEN. If the value is zero, refer to QWHSLOCN. |
| Defined by QWHSLOCN_Off | QWHSLOCN_D | This field contains both QWHSLOCN_Len and QWHSLOCN_Var. This element is only present if QWHSLOCN_Off is greater than 0. |
| Defined by QWHSLOCN_Off | QWHSLOCN_Len | The length of the field. This element is only present if QWHSLOCN_Off is greater than 0. |
| Defined by QWHSLOCN_Off | QWHSLOCN_Var | The local location name. This element is only present if QWHSLOCN_Off is greater than 0. |
| 50 | QWHSSUBV | The sub-version for the base release. |
| 52 | QWHSEND | End of product section standard header |
The following table shows the contents of the product
section correlation header.
| Hex Offset | Macro DSNDQWHC field | Description |
|---|---|---|
| 0 | QWHCLEN | Length of correlation header |
| 2 | QWHCTYP | Header type |
| 3 | Reserved | |
| 4 | QWHCAID | Authorization ID |
| C | QWHCCV | Correlation ID |
| 18 | QWHCCN | Connection name |
| 20 | QWHCPLAN | Plan name |
| 28 | QWHCOPID | Original operator ID |
| 30 | QWHCATYP | The type of system that is connecting |
| 34 | QWHCTOKN | Trace accounting token field |
| 4A | Reserved | |
| 4C | QWHCEUID | User ID at the workstation for the user |
| 5C | QWHCEUTX | Transaction name for the user |
| 7C | QWHCEUWN | Workstation name for the user |
| 8E | QWHCAID_Off | If QWHCAID is truncated, this is the offset from the beginning of QWHC to QWHCAID_LEN. If the value is zero, refer to QWHCAID. |
| Defined by QWHCAID_Off | QWHCAID_D | This field contains both QWHCAID_Len and QWHCAID_Var. |
| Defined by QWHCAID_Off | QWHCAID_Len | Length of the field |
| Defined by QWHCAID_Off | QWHCAID_Var | Authorization ID |
| 90 | QWHCOPID_Off | If QWHCOPID is truncated, this is the offset from the beginning of QWHC to QWHCAID_LEN. If the value is zero, refer to QWHCOPID. |
| Defined by QWHCOPID_Off | QWHCOPID_D | This field contains both QWHCOPID_Len and QWHCOPID_Var. |
| Defined by QWHCOPID_Off | QWHCOPID_Len | Length of the field |
| Defined by QWHCOPID_Off | QWHCOPID_Var | Original operator ID |
| 92 | QWHCEUID_Off | If QWHCEUID is truncated, this is the offset from the beginning of QWHC to QWHCEUID_LEN. If the value is zero, refer to QWHCEUID. Trusted context and role data is present if an agent running under a trusted context writes the record and the trusted context data can be accessed. |
| Defined by QWHCEUID_Off | QWHCEUID_D | This field contains both QWHCEUID_Len and QWHCEUID_Var. |
| Defined by QWHCEUID_Off | QWHCEUID_Len | Length of the field |
| Defined by QWHCEUID_Off | QWHCEUID_Var | User's USERID |
| 94 | QWHCTCXT_Off | If QWHCTCXT is truncated, this is the offset from the beginning of QWHC to QWHCTCXT_LEN. If the value is zero, refer to QWHCTCXT. |
| Defined by QWHCTCXT_Off | QWHCTCXT_D | This field contains both QWHCTCXT_Len and QWHCTCXT_Var. |
| Defined by QWHCTCXT_Off | QWHCTCXT_Len | Length of the field |
| Defined by QWHCTCXT_Off | QWHCTCXT_Var | Trusted Context name |
| 96 | QWHCROLE_Off | If QWHCROLE is truncated, this is the offset from the beginning of QWHC to QWHCROLE_LEN. If the value is zero, refer to QWHCROLE. |
| Defined by QWHCROLE_Off | QWHCROLE_D | This field contains both QWHCROLE_Len and QWHCROLE_Var. |
| Defined by QWHCROLE_Off | QWHCROLE_Len | Length of the field |
| Defined by QWHCROLE_Off | QWHCROLE_Var | Role name associated with authid |
| 98 | QWHCOAUD_Off | Offset from QWHC to the original application USERID. |
| Defined by QWHCOAUD_Off | QWHCOAUD_D | This field contains both QWHCOAUD_Len and QWHCOAUD_Var. |
| Defined by QWHCOAUD_Off | QWHCOAUD_Len | Length of the field |
| Defined by QWHCOAUD_Off | QWHCOAUD_Var | Original application USERID. |
| 9A | QWHCCTKN_Off | Offset from QWHC to the correlation token. This element is only present if QWHSSUBV is greater than 0. |
| Defined by QWHCCTKN_Off | QWHCCTKN_D | This field contains both QWHCCTKN_Len and QWHCCTKN_Var. |
| Defined by QWHCCTKN_Off | QWHCCTKN_Len | Length of the field |
| Defined by QWHCCTKN_Off | QWHCCTKN_Var | Correlation token. |
| 9C | QWHCEUTX_Off | Offset from QWHC to the client application name if QWHCEUTX is truncated. If the value is zero, refer to QWHCEUTX. |
| Defined by QWHCEUTX_Off | QWHCEUTX_D | This field contains both QWHCEUTX_Len and QWHCEUTX_Var. |
| Defined by QWHCEUTX_Off | QWHCEUTX_Len | Length of the field. |
| Defined by QWHCEUTX_Off | QWHCEUTX_Var | Client application name. |
| 9E | QWHCEUWN_Off | Offset from QWHC to the client workstation name if QWHCEUWN is truncated. If the value is zero, refer to QWHCEUWN. |
| Defined by QWHCEUWN_Off | QWHCEUWN_D | This field contains both QWHCEUWN_Len and QWHCEUWN_Var. |
| Defined by QWHCEUWN_Off | QWHCEUWN_Len | Length of the field. |
| Defined by QWHCEUWN_Off | QWHCEUWN_Var | Client workstation name. |
| 100 | QWHCEND | End of product section correlation header |
The following table shows the contents of the CPU header.
| Hex Offset | Macro DSNDQWHU field | Description |
|---|---|---|
| 0 | QWHULEN | Length of CPU header |
| 2 | QWHUTYP | Header type |
| 3 | Reserved | |
| 4 | QWHUCPU | CPU time of the currently dispatched execution unit (TCB or SRB). This time includes CPU time that was consumed on an IBM® specialty engine. If this value is binary 0, the CPU is was not available. A given ACE token might run under one or more z/OS® dispatchable execution units. Therefore, the CPU time for a given ACE might decrease between events. |
| C | QWHUCNT | Count field reserved |
| D | QWHUSE | CPU time of the currently dispatched execution unit (TCB or SRB) that was consumed on an IBM specialty engine. A given ACE token might run under one or more z/OS dispatchable execution units. Therefore, the CPU time for a given ACE might decrease between events. |
| E | QWHUEND | End of header |
The following table shows the contents of the distributed
data header.
| Hex Offset | Macro DSNDQWHD field | Description |
|---|---|---|
| 0 | QWHDLEN | Length of the distributed header |
| 2 | QWHDTYP | Header type |
| 3 | Reserved | |
| 4 | QWHDRQNM | Requester location name |
| 14 | QWHDTSTP | Timestamp for DBAT trace record |
| 1C | QWHDSVNM | EXCSAT SRVNAM parameter |
| 2C | QWHDPRID | The ACCRDB PRDID parameter. This is the product ID of the application requester. Private protocols will set this field to an appropriate product ID value. These ID values are zero if the header is written at the application requester site. |
| 34 | QWHDRQNM_Off | If QWHDRQNM is truncated, this is the offset from the beginning of QWHD to QWHDRQNM_LEN. If zero, refer to QWHDRQNM. |
| Defined by QWHDRQNM_Off | QWHDRQNM_D | This field contains both QWHDRQNM_Len and QWHDRQNM_Var. |
| Defined by QWHDRQNM_Off | QWHDRQNM_Len | Length of the field |
| Defined by QWHDRQNM_Off | QWHDRQNM_Var | The requester location name. |
| 36 | QWHDSVNM_Off | If QWHDSVNM is truncated, this is the offset from the beginning of QWHD to QWHDSVNM_LEN. If zero, refer to QWHDSVNM |
| Defined by QWHDSVNM_Off | QWHDSVNM_D | This field contains both QWHDSVNM_Len and QWHDSVNM_Var. |
| Defined by QWHDSVNM_Off | QWHDSVNM_Len | Length of the field |
| Defined by QWHDSVNM_Off | QWHDSVNM_Var | The SRVNAM parameter of the DRDA EXCSAT command. |
| 38 | QWHDEND | End of distributed header |
The following table shows the contents of the trace header.
| Hex Offset | Macro DSNDQWHT field | Description |
|---|---|---|
| 0 | QWHTLEN | Length of the trace header |
| 2 | QWHTTYP | Header type |
| 3 | QWHTFLG0 | Flags. |
| 4 | QWHTTID | Event ID |
| 6 | QWHTTAG | ID specified on DSNWTRC macro |
| 7 | QWHTFUNC | Reserved. |
| 8 | QWHTEB | Execution block address |
| C | QWHTPASI | Primary address space ID - EPAR |
| E | QWHTR14A | Register 14 address space ID |
| 10 | QWHTR14 | Contents of register 14 |
| 14 | QWHTR15 | Contents of register 15 |
| 18 | QWHTR0 | Contents of register 0 |
| 1C | QWHTR1 | Contents of register 1 |
| 20 | QWHTEXU | Address of MVS execution unit |
| 24 | QWHTDIM | Number of data items |
| 26 | QWHTHASI | Home address space ID |
| 28 | QWHTFUNCG | The trace function that is set by the DSNWTRC macro. |
| 2C | QWHTDATA | Address of the data |
| 30 | QWHTFLAG | Flags in the trace list |
| 32 | QWHTDATL | Length of the data list |
| 34 | QWHTEND | End of header |
The following table shows the contents of the data sharing
header.
| Hex Offset | Macro DSNDQWHA field | Description |
|---|---|---|
| 0 | QWHALEN | Length of the data sharing header |
| 2 | QWHATYP | Header type |
| 3 | Reserved | |
| 4 | QWHAMEMN | Db2 member name |
| C | QWHADSGN | Db2 data sharing group name |
| 14 | QWHAEND | End of header |
Figure 1 is a sample accounting trace for a distributed transaction sent to SMF.
A
+0000 093E0000 5E650080 B3FE0108 289FF3F0 F9F0E5F9 F1C20000 00000000 00000818
B C D E F G H I
+0020 01260001 00000084 02680001 000005A4 01F40001 00000798 00400002 0000054C
J K L M
+0040 00580001 00000360 00000001 0000044A 01020001 00000000 00000000 00000000
N
+0060 00000000 00000000 00000000 00000000 00000000 00000000 00000000 000002EC
+0080 00740001 C3269340 28190511 C3269340 EC195F5C 00000000 00888EA0 00000000
+00A0 038D7340 00000000 00000000 00000000 00000000 0000000C 40404040 40404040
+00C0 00000000 00000000 00000001 00000001 00000000 9822C7F8 00000000 02C55F40
+00E0 00000000 00000000 00000000 144C65E3 00000000 00000000 0000001A 0000002A
+0100 00000000 00000000 00000000 00000000 00000000 01190F81 00000000 00000000
+0120 00000000 00000000 00000000 00000002 00000000 00000000 00000000 00000000
+0140 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
+0160 00000000 003F0001 00000000 00000000 00000000 00000000 00000000 00000000
+0180 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
+01A0 00000000 00000000 000017CF C1D3D3E3 E2D64040 00000000 00000000 00000000
+01C0 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
+01E0 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
+0200 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
+0220 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
+0240 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
+0260 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
+0280 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
+02A0 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
+02C0 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
+02E0 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
+0300 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
+0320 1AE7A27D 00000000 00BAFCAB 00000000 0A492E01 00000000 00000000 0000000C
+0340 00000004 0000000C 00000000 00000000 00000000 00000000 00000000 00000000
O
+0360 00E8E2E3 D3C5C3F1 40404040 40404040 40400000 00000000 00080000 00040000
+0380 00000000 0B950000 06090000 00000000 00010000 000A0000 000A0000 00000000
+03A0 00010000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
+03C0 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00060000
+03E0 00000000 00000000 00000000 00008000 00000000 00000000 00010000 00000000
+0400 00010000 00000000 00000000 00000000 00000000 00010000 00000000 00000000
+0420 00000000 00000000 00000000 00000000 00010000 0001C4E2 D5F0F9F0 F1F00000
P
+0440 00000000 00000000 00005FC4 E2D5F0F9 F0F1F5E2 E3D3C5C3 F1404040 40404040
+0460 404040E4 E2C9C2D4 E2E840E2 E8C5C3F1 C4C2F2C2 C1E3C3C8 404040C2 C1E3C3C8
+0480 404040E3 C5D7F440 40404040 404040E2 E8E2C1C4 D44040C4 E2D5E3C5 D7F340E4
+04A0 E2C5D97E E2E8E2C1 C4D44040 40404040 40404040 40404040 40404040 40404040
+04C0 40404040 40404040 40404040 40404040 40404040 40404040 40404040 40404040
+04E0 40404040 40404040 40404040 40404040 40404040 40404040 40404040 40404040
+0500 40404040 40404040 40404040 40404040 40404040 40404040 40404040 40404040
+0520 40404040 40404040 40404040 40404040 40404040 40404040 40404040 40404040
Q
+0540 40404040 40404040 40400000 00000000 00000000 00000000 00000000 00000000
+0560 00000003 00000000 00000000 00000000 00000000 00000000 00000000 00000000
+0580 0000001C 00000016 00000000 00000001 00000000 00000008 00000000 00000000
R
+05A0 00000000 209501F4 D8E7E2E3 00000000 00000000 00000000 00000000 00000001
+05C0 00000001 00000001 00000000 00000000 00000000 00000000 00000000 00000000
+05E0 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
+0600 00000000 00000000 00000005 00000000 00000000 00000000 00000000 00000000
+0620 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
+0640 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
+0660 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
+0680 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
+06A0 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
+06C0 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
+06E0 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
+0700 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
+0720 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
+0740 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
+0760 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
S
+0780 00000000 00000000 00000000 00000000 00000000 00000000 00000000 0000001A
+07A0 00000000 00000000 0000000F 00000002 00000000 00000000 00000000 00000000
+07C0 00000000 00000000 00000000 00000000 00000001 00000000 00000064 0000000F
+07E0 00000000 00000000 00000007 00000000 00000000 00000000 00000000 00000000
T
+0800 00000000 00000000 00000000 00000000 00000000 00000000 0052011A 00030D91
+0820 16258770 E5F9F1C2 C3269340 EC55F159 00000001 00000007 00000004 E2E3D3C5
+0840 C3F1C240 40404040 40404040 E4E2C9C2 D4E2E840 E2E8C5C3 F1C4C2F2 C326933F
U
+0860 0F3E0003 00000000 0001009C 0200E2E8 E2C1C4D4 4040E3C5 D7F44040 40404040
+0880 4040C2C1 E3C3C840 4040C4E2 D5E3C5D7 F340E2E8 E2C1C4D4 40400000 0008E4E2
+08A0 C9C2D4E2 E84BE2E8 C5C3F1C4 C2F2C326 933F0F3E 00004040 40404040 40404040
+08C0 40404040 40404040 40404040 40404040 40404040 40404040 40404040 40404040
+08E0 40404040 40404040 40404040 40404040 40404040 40404040 00000000 00000000
V
+0900 00000000 00000038 1000E2E3 D3C5C3F1 40404040 40404040 4040C326 9340D6D7
+0920 C790E2E3 D3C5C3F1 40404040 40404040 4040C4E2 D5F0F9F0 F1F00000 0000| Key to Figure 1 | Description |
|---|---|
| A 00000818 | Offset to product section; beginning of self-defining section |
| B 0126 | Length of product section |
| C 0001 | Number of times product section is repeated |
| D 00000084 | Offset to accounting section |
| E 0268 | Length of accounting section |
| F 0001 | Number of times accounting section is repeated |
| G 000005A4 | Offset to SQL accounting section |
| H 00000798 | Offset to buffer manager accounting section |
| I 0000054C | Offset to locking accounting section |
| J 00000360 | Offset to distributed section |
| K 0000044A | Offset to MVS/DDF accounting section |
| L 00000000 | Offset to IFI accounting section |
| M 00000000 | Offset to package accounting section |
| N 00000000 | Beginning of accounting section (DSNDQWAC) |
| O 00E8E2E3 | Beginning of distributed section (DSNDQLAC) |
| P 00005FC4 | Beginning of MVS/DDF accounting section (DSNDQMDA) |
| Q 00000000 | Beginning of locking accounting section (DSNDQTXA) |
| R 209501F4 | Beginning of SQL accounting section (DSNDQXST) |
| S 00000000 | Beginning of buffer manager accounting section (DSNDQBAC) |
| T 0052011A | Beginning of product section (DSNDQWHS); beginning of standard header |
| U 0001009C | Beginning of correlation header (DSNDQWHC) |
| V 00000038 | Beginning of distributed header (DSNDQWHD) |
