Skip to main content
Skip table of contents

Db2 Spans

Created:  | Updated: 


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

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.