Created: 14 Jul 2021 | Updated: 13 Jul 2023
Db2 for z/OS spans that are sourced from the following Db2 trace data:
If ACCUMACC is active, accounting information will generate a Db2 span.
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.
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
duration
zos.db2.end.timestamp - zos.db2.start.timestamp
service.name
db2
timestamp
zos.db2.start.timestamp
Name
IBM SMF Source
zos.cpu.time_ms
QWACEJST - QWACBJST + QWACSPCP - QWACUDCP
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
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
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
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
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
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
duration
0
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
duration
0
Name
IBM SMF Source
db.db2.collection.id
QW0172Q2
db.db2.instance_name
QW0172HI
db.system
db2
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