Db2 Deadlock trace attributes with OpenTelemetry
Created: | Updated:
z/IRIS creates spans (traces) that comply with OpenTelemetry's OTLP specification. Below is a list of all Db2 Deadlock related attributes created and used by z/IRIS for mainframe-related spans, as well as the IBM SMF record values that z/IRIS uses to populate the attribute values.
Refer to https://mainstorconcept.atlassian.net/wiki/spaces/PKB/pages/1121746973/Distributed+Db2+for+z+OS+Observability#Db2-Deadlock-span to find out more about Deadlock APM traces .
Attribute naming scheme
Attribute Prefix | Mainframe system context |
|---|---|
zos.** | IBM z/OS operating system-wide identifiers. For example, zos.subsystem.name identifies the z/OS LPAR subsystem that processed the request and can be found in all mainframe related spans to identify any request processed by the same zos.subsystem.name. |
zos.db2.** | IBM Db2 for z/OS specific attributes. |
host.** | Host attributes as defined in OpenTelemetry's resource semantic conventions. |
db.** | Database attributes as defined in OpenTelemetry's trace semantic conventions. |
net.** enduser.** | General attributes as defined in OpenTelemetry's trace semantic conventions. |
Trace Semantics
Deadlock Participant span
Refer to https://mainstorconcept.atlassian.net/wiki/spaces/PKB/pages/1121746973/Distributed+Db2+for+z+OS+Observability#Db2-Deadlock-participant for more information these traces.
| Deadlock Participant |
|---|---|
| 0 |
| db2 |
Tags
Name | IBM SMF source |
|---|---|
|
|
|
Constant value for Db2 traces. |
span links | Link to Deadlock span
Span links may be provided automatically via APM span linking or manually via trace tag: |
| Trace id of Deadlock span. This attribute is provided as an auxiliary attribute for APM tools that do not (yet) support span links. |
Deadlock span
Refer to https://mainstorconcept.atlassian.net/wiki/spaces/PKB/pages/1121746973/Distributed+Db2+for+z+OS+Observability#Db2-Deadlock-traces to find out more about these traces.
| deadlock |
|---|---|
| 0 |
| db2 |
Tags
Name | IBM SMF source |
|---|---|
|
Constant valkue for all Db2 traces |
|
|
|
Portion of this field |
|
Portion of this field |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
span links | Links to all Deadlock Participant spans
A Deadlock Participant span is created for requests that deadlocked with this span’s parent. The trace.ids for these requests can be found in the holder and waiter child spans. |
Db2 Resource name span
Refer to https://mainstorconcept.atlassian.net/wiki/spaces/PKB/pages/1121746973/Distributed+Db2+for+z+OS+Observability#Db2-deadlock-resource-name-span to find out more about the traces.
|
The value varies depending on the Db2 resource impacted by the deadlock |
|---|---|
| 0 |
| db2 |
Tags
Name | IBM SMF source |
|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Constant value for Db2 traces |
|
|
Waiter child span
Refer to https://mainstorconcept.atlassian.net/wiki/spaces/PKB/pages/1121746973/Distributed+Db2+for+z+OS+Observability#Holder-and-Waiter-child-spans to find out more about these traces.
| waiter |
|---|---|
| 0 |
| db2 |
Tags
Name | IBM SMF source |
|---|---|
|
|
|
|
|
|
|
Constant value for Db2 traces |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
*zos.db2.transaction.name and zos.db2.workstation.name will be replaced by waiter.trace_id if an APM trace id is present.
Holder child span
Refer to https://mainstorconcept.atlassian.net/wiki/spaces/PKB/pages/1121746973/Distributed+Db2+for+z+OS+Observability#Holder-and-Waiter-child-spans to find out more about these traces.
| holder |
|---|---|
| 0 |
| db2 |
Name | IBM SMF Source |
|---|---|
|
|
|
|
|
Constant value for Db2 traces |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
*zos.db2.transaction.name and zos.db2.workstation.name will be replaced by holder.trace_id if a trace id is present.