Created:  | Updated: 


z/IRIS creates spans (traces) that comply with OpenTelemetry's OTLP specification. Below is a list of all Db2 Accounting related attributes 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 attribute values.


Attribute context

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 on the same zos.subsystem.name.

zos.db2.**

IBM Db2 for z/OS specific attributes.

host.**

Host attributes as defined in OpenTelemetry's resource semantic conventions.

db.**

Database attributes as defined in OpenTelemetry's trace semantic conventions.

net.**

General attributes as defined in OpenTelemetry's trace semantic conventions.

Attributes list

z/IRIS / OpenTelemetry attributes

IBM SMF source

Accounting span

Resource attributes

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

OpenTelemetry resource attributes

host.name

SMFxSID

Custom attributes

zos.db2.wait.time_ms

Sum of various wait times:

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.unlock.requests

QTXAUNLK

zos.db2.sql.storedprocedure.statements

Check if at least one of the following fields is not zero to determine if a stored procedure was used:

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.start.timestamp

QWACBSC

zos.db2.end.timestamp

QWACESC

zos.db2.response.time_ms

QWACESC - QWACBSC

zos.db2.elapsed.time_ms

QWACASC

zos.cpu.time_ms

QWACEJST - QWACBJST + QWACSPCP - QWACUDCP

zos.db2.abort.requests

QWACABRT

zos.db2.su.factor

QWACSUCV

zos.db2.workload.service.class.name

QWACWLME

zos.db2.cpu.time_ms

QWACAJST

zos.ziip.time_ms

QWACCLS1_ZIIP

zos.db2.ziip.time_ms

QWACCLS2_ZIIP

zos.db2.remote.location.name

QLACLOCN

zos.db2.product.id

QLACPRID

zos.db2.sent.bytes

QLACBYTS

zos.db2.received.bytes

QLACBYTR

zos.db2.client.application.name

QMDAAPPL

zos.db2.client.platform

QMDAPLAT

zos.db2.client.auth.id

QMDAATID

zos.db2.sql.prepare.statements

QXPREP

zos.db2.sql.open.statements

QXOPEN

zos.db2.sql.lock.statements

QXLOCK

OpenTelemetry attributes

db.system

-

net.peer.ip

QWHSLWID

net.peer.port