Created:  | Updated: 

Below is a list of all Db2 Accounting 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 Distributed Db2 for z/OS Observability for more information about tracing JDBC requests processed on Db2 for z/OS servers.

Tag Naming Scheme

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

General attributes as defined in OpenTelemetry's semantic conventions for traces.

Span Semantics

span.name

Db2 Accounting

Constant value

duration

zos.db2.end.timestamp - zos.db2.start.timestamp

service.name

db2

Constant value

Resource Tags

Name

IBM SMF source

host.name

SMFxSID

host.arch

z/Architecture

os.type

z/OS

zos.db2.ace

QWHSACE

zos.db2.location.name

QWHSLOCN

zos.db2.luw.id

QWHSLWID

zos.db2.uniqueness.value

QWHSLUUV

zos.db2.version

QWHSRN

zos.lu.name

QWHSLUNM

zos.network.id

QWHSNID

zos.subsystem.name

SMFxSSI

Span Tags

Name

IBM SMF Source

db.system

db2

Constant value for Db2 traces

net.peer.ip

QWHSLWID

Derived from this field

net.peer.port

QWHSLWID

Derived from this field

zos.db2.abort.requests

QWACABRT

zos.db2.cpu.time_ms

QWACAJST

zos.db2.client.application.name

QMDAAPPL

zos.db2.elapsed.time_ms

QWACASC

zos.db2.end.timestamp

QWACESC

zos.db2.remote.location.name

QLACLOCN

zos.db2.sent.bytes

QLACBYTS

zos.db2.start.timestamp

QWACBSC

zos.db2.client.platform

QMDAPLAT

zos.db2.sql.lock.statements

QXLOCK

zos.db2.sql.open.statements

QXOPEN

zos.db2.sql.prepare.statements

QXPREP

zos.db2.sql.storedprocedure.statements

true | false

True if at least one of the following fields is not zero 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

zos.db2.su.factor

QWACSUCV

zos.db2.client.auth.id

QMDAATID

zos.db2.product.id

QLACPRID

zos.db2.received.bytes

QLACBYTR

zos.db2.response.time_ms

QWACESC - QWACBSC

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 various wait times.

zos.db2.workload.service.class.name

QWACWLME

zos.db2.ziip.time_ms

QWACCLS2_ZIIP

zos.cpu.time_ms

QWACEJST - QWACBJST + QWACSPCP - QWACUDCP

zos.ziip.time_ms

QWACCLS1_ZIIP