Db2 Spans

Created: 14 Jul 2021 | Updated: 13 Jul 2023

Db2 for z/OS spans that are sourced from the following Db2 trace data:

DRDA and SQL spans:
SMF Type 101 containing accounting information in IFCID 3 records

If ACCUMACC is active, accounting information will generate a Db2 span.

Deadlock and Deadlock Participant:
SMF Type 102 containing deadlock information in IFCID 172 records

Refer to Distributed Db2 for z/OS Observability for more information about tracing distributed allied threads on Db2 for z/OS servers.

Refer to Tag Semantics for more information about the naming conventions and mainframe context.

Common Db2 Resource Tags

Refer to Common Resource Tags for attributes available in all z/IRIS spans.

Name	IBM SMF source
`service.name`	`db2`
`db.db2.instance_name`	`SMFxSSI`
`db.system`	`db2`
`enduser.id`	`QWHCEUID`
`net.sock.peer.addr`	`QWHSLWID`
`net.sock.peer.port`	`QWHSLWID`
`resource.name`	`db2`
`zos.db2.ace`	`QWHSACE`
`zos.db2.correlation_id`	`QWHCCV`
`zos.db2.location.name`	`QWHSLOCN`
`zos.db2.luw.id`	`QWHSLWID`
`zos.db2.transaction.name`	`QWHCEUTN`
`zos.db2.uniqueness_value`	`QWHSLUUV`
`zos.db2.version`	`QWHSRN`
`zos.db2.workstation.name`	`QWHCEUWN`
`zos.lu.name`	`QWHSLUNM`
`zos.network.id`	`QWHSNID`

DRDA and SQL Spans

Span Semantics

`name`	Either: `DRDA zos.db2.location.name` When db2 product name is `JCC`,`HTP` or `HTS` `SQL zos.db2.location.name` When db2 product name is `SQL` Example: DRDA DALLASC
`duration`	`zos.db2.end.timestamp - zos.db2.start.timestamp`
`service.name`	`db2`
`timestamp`	`zos.db2.start.timestamp`

Span Tags

Name	IBM SMF Source
`zos.cpu.time_ms`	`QWACEJST - QWACBJST + QWACSPCP - QWACUDCP` Calculated as above
`zos.db2.abort.requests`	`QWACABRT`
`zos.db2.client.application.name`	`QMDAAPPL`
`zos.db2.client.auth.id`	`QMDAATID`
`zos.db2.client.platform`	`QMDAPLAT`
`zos.db2.cpu.time_ms`	`QWACAJST`
`zos.db2.elapsed.time_ms`	`QWACASC`
`zos.db2.end.timestamp`	`QWACESC`
`zos.db2.product.id`	`QLACPRID`
`zos.db2.received.bytes`	`QLACBYTR`
`zos.db2.remote.location.name`	`QLACLOCN`
`zos.db2.response.time_ms`	`QWACESC - QWACBSC` Calculated as above
`zos.db2.sent.bytes`	`QLACBYTS`
`zos.db2.sql.lock.statements`	`QXLOCK`
`zos.db2.sql.open.statements`	`QXOPEN`
`zos.db2.sql.prepare.statements`	`QXPREP`
`zos.db2.sql.storedprocedure.statements`	`QWACSPEA, QWACSPEB, QWACCAST, QWACSPNF_ELAP, QWACSPNE, QWACSPCP, QWACUDCP, QWACAJST, QWACUDTT, QWACTRTT, QWACTRTE_SE, QWACTRTT_ZIIP, QWACZIIP_ELIGIBLE, QWACSPNF_CP, QWACUDFNF_CP, QWACSP_CLS1SE, QWACSP_CLS2SE, QWACUDF_CLS1SE, QWACUDF_CLS2SE, QWAC_ACCEL_ELIG_CP, QWAC_ACCEL_ELIG_SE, QWACSPTT, QWACCLS1_ZIIP, QWACCLS2_zIIP, QWACSPNF_ZIIP, QWACUDFNF_zIIP, QWACCANM` True if at least one of the following fields is not zero
`zos.db2.start.timestamp`	`QWACBSC`
`zos.db2.su.factor`	`QWACSUCV`
`zos.db2.unlock.requests`	`QTXAUNLK`
`zos.db2.wait.time_ms`	`QWAC_AT_WAIT, QWAC_PQS_WAIT, QWACAACW, QWACALBW, QWACAWLG, QWACAWLH, QWACAWTE, QWACAWTG, QWACAWTI, QWACAWTJ, QWACAWTK, QWACAWTL, QWACAWTM, QWACAWTN, QWACAWTO, QWACAWTP, QWACAWTQ, QWACAWTR, QWACAWTW, QWAXALOG, QWAXAWAR, QWAXAWCL, QWAXAWDR, QWAXAWFC, QWAXDSSE, QWAXIXLT, QWAXOCSE, QWAXOTSE, QWAX_PIPE_WAIT, QWAX_LOBCOMP_WAIT, QWAXSLSE` Sum of above wait times
`zos.db2.workload.service.class.name`	`QWACWLME`
`zos.db2.ziip.time_ms`	`QWACCLS2_ZIIP`
`zos.ziip.time_ms`	`QWACCLS1_ZIIP`

Deadlock Participant span

Span Semantics

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

`span.name`	`Deadlock Participant`
`duration`	`0`

Span Tags

Name	IBM SMF source
span links	Hyperlink 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`	W3C trace id for a related Deadlock span in seperate, otherwise unrelated, trace. This attribute is provided to cater for APM tools that do not (yet) support span links.

Deadlock span

Span Semantics

Refer to Db2 Deadlock Traces to find out more about these spans.

`span.name`	`deadlock`
`duration`	`0`

Span Tags

Name	IBM SMF source
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.
`zos.db2.deadlock.resources`	`QW0172NR`
`zos.db2.uniqueness.value`	`QWHSLUUV`
`zos.subsystem.name`	`SMFxSSI`

Db2 Resource name span

Refer to Db2 Deadlock Resource Name span to find out more about the spans.

Span Semantics

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

Span 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`

Waiter child span

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

Span Semantics

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

Span Tags

Name	IBM SMF source
`db.db2.collection.id`	`QW0172Q6`
`db.user`	`QW0172WC`
`net.sock.peer.addr`	`QW0172WL` Overwrites the Common Db2 Resource Tag value
`net.sock.peer.port`	`QW0172WL` Overwrites the Common Db2 Resource Tag value
`waiter.trace_id *`	`QW0172WJ \| QW0172WK`
`zos.correlation.id`	`QW0172WR`
`zos.db2.ace`	`QW0172WO` Overwrites the Common Db2 Resource Tag value
`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` Overwrites the Common Db2 Resource Tag value
`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` Overwrites the Common Db2 Resource Tag value
`zos.db2.workstation.name *`	`QW0172WK` Overwrites the Common Db2 Resource Tag value
`zos.uow`	`QW0172WU`

* 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 Semantics

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

Span Tags

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` Overwrites the Common Db2 Resource Tag value
`holder.trace_id` *	`QW0172HJ` \| `QW0172HK`
`net.sock.peer.addr`	`QW0172HL`
`net.sock.peer.port`	`QW0172HL`
`zos.db2.ace`	`QW0172HO` Overwrites the Common Db2 Resource Tag value
`zos.db2.connection.id`	`QW0172HN` Overwrites the Common Db2 Resource Tag value
`zos.db2.consistency.token`	`QW0172Q4`
`zos.correlation.id`	`QW0172HR`
`zos.db2.lock.duration`	`QW0172HD`
`zos.db2.lock.state`	`QW0172HS`
`zos.db2.luw.id`	`QW0172HL` Overwrites the Common Db2 Resource Tag value
`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` Overwrites the Common Db2 Resource Tag value
`zos.db2.workstation.name` *	`QW0172HK` Overwrites the Common Db2 Resource Tag value
`zos.uow`	`QW0172HU`