Created:  | Updated: 


Summary

Overview of all custom tags created by z/IRIS for mainframe-related Instana APM traces.


Analyze mainframe calls in Instana APM

All Instana APM traces or calls created by z/IRIS are annotated with tags that can be used to search and filter mainframe related traces in the Instana Analyze Dashboard. z/IRIS custom tags are accessible under call.tag.

Click on the image to enlarge


z/IRIS generated custom tags for mainframe traces

When the SMF field appears in multiple SMF records, the IBM SMF sources contain "x" as a placeholder for the SMF record type. For example, SMFxSSI is found in the SMF Header for all SMF record types.


Instana custom Tag

IBM SMF source

endpoint

SMF30JBN - Jobname (z/OS work)
SMFxSSI - SubsystemID (Db2 Accounting, Db2 Deadlock and child spans, Db2 Deadlock participant)

zos.address.space.cpu.serviceunits

SMF30CSU

zos.address.space.cpu.time

SMF30CPT + SMF30CPS + SMF30ICU + SMF30ISB +SMF30IIP + SMF30RCT + SMF30HPT

zos.address.space.id

SMF30ASI

zos.address.space.name

SMF30JBN

zos.address.space.start.timestamp

SMF30TME + SMF30DTE

zos.address.space.tape.mounts

SMF30PTM + SMF30TPR

zos.address.space.ziip.time

SMF30_TIME_ON_ZIIP + SMF30_TIME_ON_IFA

zos.cpu.time

(QWACEJST - QWACBJST) + QWACSPCP + QWACUDCP

zos.db2.abort.requests

QWACABRT

zos.db2.ace

QWHSACE

zos.db2.client.application.name

QMDAAPPL

zos.db2.client.auth.id

QMDAATID

zos.db2.client.platform

QMDAPLAT

zos.db2.collection.id

Source depends on the IFCID:
QW0058PC, QW0059PC, QW0060PC, QW0061PC, QW0062PC, QW0063PC, QW0064PC,QW0065PC,QW0066PC

zos.db2.consistency.token

Source depends on the IFCID:

QW0058TS, QW0059TS, QW0060TS, QW0061TS, QW0062TS, QW0063TS, QW0064TS, QW0065TS, QW0066TS

zos.db2.cpu.time

QWACAJST,QW0058CP

zos.db2.cursor.name

Source depends on the IFCID:

QW0059CN, QW0061TS, QW0064TS, QW0065TS, QW0066TS

zos.db2.dbid

QW0172KD

zos.db2.deadlock.event.trace.id

z/IRIS partner APM trace id

zos.db2.deadlock.event.trace.spanId

z/IRIS partner APM trace id

zos.db2.deadlock.holder.ace

QW0172HO (last 4 bytes)

zos.db2.deadlock.holder.auth.id

QW0172HB

zos.db2.deadlock.holder.collection.id

QW0172Q2

zos.db2.deadlock.holder.connection.id

QW0172HN

zos.db2.deadlock.holder.consistency.token

QW0172Q4

zos.db2.deadlock.holder.correlation.id

QW0172HR

zos.db2.deadlock.holder.dbms.id

QW0172HI

zos.db2.deadlock.holder.duration

QW0172HD

zos.db2.deadlock.holder.luw.id

Derived from QW0172HL in the format: "String(<Network ID>).String(<LU Name>).HexString(<Uniqueness Value>)=String(<Commit Count>)"

zos.db2.deadlock.holder.network.address

Derived from QW0172HL for IPV4 addresses

zos.db2.deadlock.holder.plan.name

QW0172HP

zos.db2.deadlock.holder.program.name

QW0172Q1

zos.db2.deadlock.holder.state

QW0172HS

zos.db2.deadlock.holder.statement.id

QW0172HZ

zos.db2.deadlock.holder.statement.type

QW0172HY

zos.db2.deadlock.holder.thread.token

QW0172HT

zos.db2.deadlock.holder.trace.id

z/IRIS partner APM trace id

zos.db2.deadlock.holder.transaction.name

QW0172HJ

zos.db2.deadlock.holder.uow

QW0172HO (first 4 bytes)

zos.db2.deadlock.holder.user.id

QW0172HC

zos.db2.deadlock.resources

QW0172NR

zos.db2.deadlock.timestamp

QW0172TD

zos.db2.deadlock.waiter.ace

QW0172WO (last 4 bytes)

zos.db2.deadlock.waiter.auth.id

QW0172WB

zos.db2.deadlock.waiter.collection.id

QW0172Q6

zos.db2.deadlock.waiter.connection.id

QW0172WN

zos.db2.deadlock.waiter.consistency.token

QW0172Q8

zos.db2.deadlock.waiter.correlation.id

QW0172WR

zos.db2.deadlock.waiter.dbms.id

QW0172WI

zos.db2.deadlock.waiter.duration

QW0172WD

zos.db2.deadlock.waiter.luw.id

Derived from QW0172HL in the format: "String(<Network ID>).String(<LU Name>).HexString(<Uniqueness Value>)=String(<Commit Count>)"

zos.db2.deadlock.waiter.network.address

Derived from QW0172WL for IPV4 addresses

zos.db2.deadlock.waiter.plan.name

QW0172WP

zos.db2.deadlock.waiter.program.name

QW0172Q5

zos.db2.deadlock.waiter.request

QW0172WF

zos.db2.deadlock.waiter.state

QW0172WS

zos.db2.deadlock.waiter.statement.id

QW0172WZ

zos.db2.deadlock.waiter.statement.type

QW0172WY

zos.db2.deadlock.waiter.thread.token

QW0172WT

zos.db2.deadlock.waiter.trace.id

z/IRIS partner APM trace id

zos.db2.deadlock.waiter.transaction.name

QW0172WJ

zos.db2.deadlock.waiter.uow

QW0172UW

zos.db2.deadlock.waiter.user.id

QW0172WC

zos.db2.elapsed.time

QWACASC,QW0058ET

zos.db2.end.time

QWACESC

zos.db2.fetch.orientation

QW0059FO

zos.db2.fetch.sensitivity

QW0059FS

zos.db2.instance

QWHSLOCN

zos.db2.instance.name

QWHSLOCN

zos.db2.location.name

Sources depends on the IFCID:

QW0058LN, QW0059LN, QW0060LN, QW0061LN, QW0062LN, QW0063LN, QW0064LN, QW0065LN, QW0066LN

zos.db2.lock.id

Derived of QW0172PN

zos.db2.lock.type

Flags for QW0172FR

zos.db2.luw.id

Derived from QWHSLWID in the format: "String(<Network ID>).String(<LU Name>).HexString(<Uniqueness Value>)=String(<Commit Count>)"

zos.db2.network.address

Derived from QWHSLWID for IPv4 addresses

zos.db2.object.name

QW0062ON

zos.db2.object.type

QW0062OT

zos.db2.obid

QW0172KP

zos.db2.product.id

QLACPRID

zos.db2.program.name

Source depends on the IFCID:

QW0058PN, QW0059PN, QW0060PN, QW0061LN, QW0064LN, QW0065LN, QW0066LN

zos.db2.received.bytes

QLACBYTR

zos.db2.remote.location.name

QLACLOCN

zos.db2.response.time

QWACESC - QWACBSC

zos.db2.rows.deleted

QW0058DE

zos.db2.rows.inserted

QW0058IN

zos.db2.rows.returned

QW0058RQ

zos.db2.rows.scanned

QW0058RP

zos.db2.rows.updated

QW0058UP

zos.db2.scan.type.id

QW0058ID

zos.db2.select.isolationlevel 

QW0060I

zos.db2.select.reoptimized

QW0060RO

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.statement.query

QW0063ST

zos.db2.statement.type

Source depends on the IFCID:

QW0058TY, QW0059ST, QW0060ST, QW0061ST, QW0062ST,QW0063ST, QW0064ST, QW0065ST

QW0063ST values are Dynamic or Static

all other IFCIDs provide the SQL statement type. E.g. Select or Insert


zos.db2.statement.id

Source depends on the IFCID:

QW0058TK,QW0063SI

zos.db2.query.command.id

Source depends on the IFCID:

QW0058CID, QW0059CID, QW0060CID, QW0061CID, QW0064CID,QW0065CID,QW0066CID

zos.db2.query.instance.id

Source depends on the IFCID:

QW0058QID, QW0059QID, QW0060QID, QW0061QID, QW0064QID,QW0065CID,QW0066CID

zos.db2.QW0061ST.isolationlevel

QW0061I

zos.db2.QW0061ST.reoptimize

QW0061RO

zos.db2.request.type

QW0058TOS

zos.db2.sql.storedprocedure.statements

Returns 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.start.time

QWACBSC

zos.db2.statement.number

Source depends on the IFCID:

QW0058SN, QW0059SN, QW0060SN, QW0061SN, QW0064SN,QW0065SN,QW0066SN

zos.db2.su.factor

QWACSUCV

zos.db2.uniqueness.value

QWHSLUUV (Part of QWHSLWID)

zos.db2.unlock.requests

QTXAUNLK

zos.db2.version

QWHSRN

zos.db2.wait.time

sum of all available class 3 suspension times for accounting records

sum of all wait times in ifcid 058 for performance records

zos.db2.workload.service.class.name

QWACWLME

zos.db2.ziip.time

QWACCLS2_zIIP

zos.job.class

SMF30CL8

zos.job.cpu.serviceunits

SMF30CSU

zos.job.duration

(SMF30TME + SMF30DTE) - (SMF30SIT + SMF30STD)

zos.job.end.timestamp

SMF30TME + SMF30DTE

zos.job.ended

TRUE

zos.job.exec.program.name

SMF3OPGM

zos.job.id

SMF30JNM

zos.job.name

SMF30JBN

zos.job.returncode

SMF30SCC (when subtype is 5)

zos.job.start.timestamp

SMF30SIT + SMF30STD

zos.job.step.cpu.serviceunits

SMF30CSU

zos.job.step.cpu.time

SMF30CPT + SMF30CPS + SMF30ICU + SMF30ISB + SMF30IIP + SMF30RCT + SMF30HPT

zos.job.step.duration

(SMF30TME + SMF30DTE) - (SMF30SIT + SMF30STD)

zos.job.step.end.timestamp

SMF30TME + SMF30DTE

zos.job.step.ended

TRUE

zos.job.step.name

SMF30STM

zos.job.step.number

SMF30STN

zos.job.step.returncode

SMF30SCC (when SMF Type 30 subtype 4)

zos.job.step.tape.mounts

SMF30PTM + SMF30TPR

zos.job.step.ziip.time

SMF30_TIME_ON_IFA + SMF30_TIME_ON_ZIIP

zos.job.tape.mounts

SMF30PTM + SMF30TPR

zos.job.type

SMF30WID

zos.job.user.id

SMF30UIF

zos.job.user.name

SMF30USR

zos.lu.name

QWHSLUNM

zos.network.address

Derived from QWHSLWID for IPv4 addresses

zos.network.id

QWHSNID

zos.racf.group.id

SMF30GRP

zos.racf.user.id

SMF30RUD

zos.subsystem.name

SMFHDR_WID

zos.sysplex.name

SMF30SYP

zos.system.name

SMFHDR_SID

zos.workload.name

SMF30WLM

zos.workload.service.class.name

SMF30SCN

zos.ziip.time

QWACCLS1_zIIP