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.

Attribute context

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.

Attributes list

z/IRIS / OpenTelemetry attributes

IBM SMF source

Deadlock span

Resource attributes

zos.db2.ace

QWHSACE

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

OpenTelemetry resource attributes

host.name

SMFxSID

Span links

Links to all Deadlock Participant spans

A Participant span is created for each trace id that is being found in the holder and waiter sections of the participating resources.

Custom attributes

zos.db2.deadlock.resources

QW0172NR

OpenTelemetry attributes

db.system

-

net.peer.ip

QWHSLWID

net.peer.port

Resource child of deadlock span

Custom attributes

zos.db2.lock.type

QW0172FR

zos.db2.obid

QW0172PN

(Which attributes are set varies depending on the deadlock type)

zos.db2.dbid

zos.db2.xml.doc.id

zos.db2.lob.row.id

zos.db2.lob.version

zos.db2.consistency.token

zos.db2.plan.name

zos.db2.urid

zos.db2.stabilization.group

OpenTelemetry attributes

db.db2.collection.id

Waiter child of resource span

Custom attributes

zos.db2.lock.duration

QW0172WD

zos.db2.ace

QW0172WO

zos.db2.connection.id

QW0172WN

zos.db2.consistency.token

QW0172Q8

zos.correlation.id

QW0172WR

zos.db2.luw.id

QW0172WL

zos.db2.plan.name

QW0172WP

zos.db2.program.name

QW0172Q5

zos.db2.lock.state

QW0172WS

zos.db2.statement.id

QW0172WZ

zos.db2.statement.type

QW0172WY

zos.db2.thread.token

QW0172WT

zos.uow

QW0172WU

zos.db2.transaction.name*

QW0172WJ

waiter.trace_id*

QW0172WJ/QW0172WK

zos.db2.workstation.name*

QW0172WK

zos.db2.lock.request

QW0172WF

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

OpenTelemetry attributes

enduser.id

QW0172WB

db.db2.collection.id

QW0172Q6

db.db2.instance_name

QW0172WI

net.peer.ip

QW0172WL

net.peer.port

db.user

QW0172WC

Holder child of resource span

Custom attributes

zos.db2.lock.duration

QW0172HD

zos.db2.ace

QW0172HO

zos.db2.connection.id

QW0172HN

zos.db2.consistency.token

QW0172Q4

zos.correlation.id

QW0172HR

zos.db2.luw.id

QW0172HL

zos.db2.plan.name

QW0172HP

zos.db2.program.name

QW0172Q1

zos.db2.lock.state

QW0172HS

zos.db2.statement.id

QW0172HZ

zos.db2.statement.type

QW0172HY

zos.db2.thread.token

QW0172HT

zos.uow

QW0172HU

zos.db2.transaction.name*

QW0172HJ

zos.db2.workstation.name*

QW0172HK

holder.trace_id*

QW0172HJ/QW0172HK

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

OpenTelemetry attributes

enduser.id

QW0172HB

db.db2.collection.id

QW0172Q2

db.db2.instance_name

QW0172HI

net.peer.ip

QW0172HL

net.peer.port

db.user

QW0172HC

z/IRIS / OpenTelemetry attributes

IBM SMF source

Deadlock Participant span

Resource attributes

db.db2.instance_name

QW0172WI/QW0172HI

Span links

Link to Deadlock span.

Custom attributes

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.