Db2 Deadlock Spans

Created: 25 May 2021 | Updated: 19 May 2022

Below is a list of all Db2 Deadlock related tags 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 tag values.

Refer to Db2 Deadlock span to find out more about Deadlock APM spans.

Tag 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 semantic conventions for resources.
db.**	Database attributes as defined in OpenTelemetry's semantic conventions for traces.
net. enduser.	General attributes as defined in OpenTelemetry's semantic conventions for traces.

Span Semantics

Deadlock Participant span

Refer to Db2 Deadlock Participant for more information about these spans.

`span.name`	`Deadlock Participant` Constant value
`duration`	`0`
`service.name`	`db2` Constant value

Tags

Name	IBM SMF source
`db.db2.instance_name`	`QW0172WI` \| `QW0172HI`
`db.system`	`db2` Constant value
span links	Link to Deadlock span Span links may be provided automatically via APM span linking or manually via trace tag `zos.db2.deadlock.event.trace_id`
`zos.db2.deadlock.event.trace_id`	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 Db2 Deadlock Traces to find out more about these spans.

`span.name`	`deadlock` Constant value
`duration`	`0` Constant value
`service.name`	`db2` Constant value

Tags

Name	IBM SMF source
`db.system`	`db2` Constant value
`host.name`	`SMFxSID`
`net.peer.ip`	`QWHSLWID` Derived from this field
`net.peer.port`	`QWHSLWID` Derived from this field
`zos.db2.ace`	`QWHSACE`
`zos.db2.deadlock.resources`	`QW0172NR`
`zos.db2.location.name`	`QWHSLOCN`
`zos.db2.luw.id`	`QWHSLWID`
`zos.db2.uniqueness.value`	`QWHSLUUV`
`zos.db2.version`	`QWHSRN`
`zos.network.id`	`QWHSNID`
`zos.subsystem.name`	`SMFxSSI`
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 Db2 Deadlock Resource Name span to find out more about the spans.

`span.name`	`QW0172PN` The value varies depending on the Db2 resource impacted by the deadlock.
`duration`	`0` Constant value
`service.name`	`db2` Constant value

Tags

Name	IBM SMF source
`zos.db2.consistency.token`	`QW0172PN`
`zos.db2.dbid`	`QW0172PN`
`zos.db2.lob.row.id`	`QW0172PN`
`zos.db2.lob.version`	`QW0172PN`
`zos.db2.lock.type`	`QW0172FR`
`zos.db2.obid`	`QW0172PN`
`zos.db2.plan.name`	`QW0172PN`
`zos.db2.stabilization.group`	`QW0172PN`
`zos.db2.urid`	`QW0172PN`
`zos.db2.xml.doc.id`	`QW0172PN`
`db.db2.collection.id`	`QW0172PN`
`db.system`	`db2` Constant value
`db.db2.instance_name`	`QWHSSSID`

Waiter child span

Refer to Holder and Waiter child spans to find out more about these spans.

`span.name`	`waiter` Constant value
`duration`	`0` Constant value
`service.name`	`db2` Constant value

Tags

Name	IBM SMF source
`db.db2.collection.id`	`QW0172Q6`
`db.db2.instance_name`	`QW0172WI`
`db.user`	`QW0172WC`
`db.system`	`db2` Constant value for Db2 spans
`net.peer.ip`	`QW0172WL`
`net.peer.port`	`QW0172WL`
`zos.db2.ace`	`QW0172WO`
`zos.correlation.id`	`QW0172WR`
`zos.db2.connection.id`	`QW0172WN`
`zos.db2.consistency.token`	`QW0172Q8`
`zos.db2.lock.duration`	`QW0172WD`
`zos.db2.lock.request`	`QW0172WF`
`zos.db2.lock.state`	`QW0172WS`
`zos.db2.luw.id`	`QW0172WL`
`zos.db2.plan.name`	`QW0172WP`
`zos.db2.program.name`	`QW0172Q5`
`zos.db2.statement.id`	`QW0172WZ`
`zos.db2.statement.type`	`QW0172WY`
`zos.db2.thread.token`	`QW0172WT`
`zos.db2.transaction.name`*	`QW0172WJ`
`zos.db2.workstation.name` *	`QW0172WK`
`zos.uow`	`QW0172WU`
`waiter.trace_id` *	`QW0172WJ` \| `QW0172WK`

*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 Holder and Waiter child spans to find out more about these spans.

`span.name`	`holder` Constant value
`duration`	`0` Constant value
`service.name`	`db2` Constant value

Name	IBM SMF Source
`db.db2.collection.id`	`QW0172Q2`
`db.db2.instance_name`	`QW0172HI`
`db.system`	`db2` Constant value
`db.user`	`QW0172HC`
`enduser.id`	`QW0172HB`
`holder.trace_id` *	`QW0172HJ` \| `QW0172HK`
`net.peer.ip`	`QW0172HL`
`net.peer.port`	`QW0172HL`
`zos.db2.ace`	`QW0172HO`
`zos.db2.connection.id`	`QW0172HN`
`zos.db2.consistency.token`	`QW0172Q4`
`zos.correlation.id`	`QW0172HR`
`zos.db2.lock.duration`	`QW0172HD`
`zos.db2.lock.state`	`QW0172HS`
`zos.db2.luw.id`	`QW0172HL`
`zos.db2.plan.name`	`QW0172HP`
`zos.db2.program.name`	`QW0172Q1`
`zos.db2.statement.id`	`QW0172HZ`
`zos.db2.statement.type`	`QW0172HY`
`zos.db2.thread.token`	`QW0172HT`
`zos.db2.transaction.name` *	`QW0172HJ`
`zos.db2.workstation.name` *	`QW0172HK`
`zos.uow`	`QW0172HU`

*zos.db2.transaction.name and zos.db2.workstation.name will be replaced by holder.trace_id if a trace id is present.