Created:  | Updated: 


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.