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.

span.name

Deadlock Participant

duration

0

service.name

db2

Tags

Name

IBM SMF source

db.db2.instance_name

QW0172WI | QW0172HI

db.system

db2

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: 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 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.

span.name

deadlock

duration

0

service.name

db2

Tags

Name

IBM SMF source

db.system

db2

Constant valkue for all Db2 traces

host.name

SMFxSID

net.peer.ip

QWHSLWID

Portion of this field

net.peer.port

QWHSLWID

Portion of 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 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.

span.name

QW0172PN

The value varies depending on the Db2 resource impacted by the deadlock

duration

0

service.name

db2

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 for Db2 traces

db.db2.instance_name

QWHSSSID

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.

span.name

waiter

duration

0

service.name

db2

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 traces

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 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.

span.name

holder

duration

0

service.name

db2

Name

IBM SMF Source

db.db2.collection.id

QW0172Q2

db.db2.instance_name

QW0172HI

db.system

db2

Constant value for Db2 traces

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.