Skip to end of metadata
Go to start of metadata
 Click to expand table of contents...

Content



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

Please note:

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 TagIBM SMF source
endpointSMF30JBN - Jobname (z/OS work)
SMFxSSI - SubsystemID (Db2 Accounting, Db2 Deadlock and child spans, Db2 Deadlock participant)
zos.address.space.cpu.serviceunitsSMF30CSU
zos.address.space.cpu.timeSMF30CPT + SMF30CPS + SMF30ICU + SMF30ISB +SMF30IIP + SMF30RCT + SMF30HPT
zos.address.space.idSMF30ASI
zos.address.space.nameSMF30JBN
zos.address.space.start.timestampSMF30TME + SMF30DTE
zos.address.space.tape.mountsSMF30PTM + SMF30TPR
zos.address.space.ziip.timeSMF30_TIME_ON_ZIIP + SMF30_TIME_ON_IFA
zos.cpu.time(QWACEJST - QWACBJST) + QWACSPCP + QWACUDCP
zos.db2.abort.requestsQWACABRT
zos.db2.aceQWHSACE
zos.db2.client.application.nameQMDAAPPL
zos.db2.client.auth.idQMDAATID
zos.db2.client.platformQMDAPLAT

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.timeQWACAJST,QW0058CP

zos.db2.cursor.name

Source depends on the IFCID:

QW0059CN, QW0061TS, QW0064TS, QW0065TS, QW0066TS

zos.db2.dbidQW0172KD
zos.db2.deadlock.event.trace.idz/IRIS partner APM trace id
zos.db2.deadlock.event.trace.spanIdz/IRIS partner APM trace id
zos.db2.deadlock.holder.aceQW0172HO (last 4 bytes)
zos.db2.deadlock.holder.auth.idQW0172HB
zos.db2.deadlock.holder.collection.idQW0172Q2
zos.db2.deadlock.holder.connection.idQW0172HN
zos.db2.deadlock.holder.consistency.tokenQW0172Q4
zos.db2.deadlock.holder.correlation.idQW0172HR
zos.db2.deadlock.holder.dbms.idQW0172HI
zos.db2.deadlock.holder.durationQW0172HD
zos.db2.deadlock.holder.luw.idDerived from QW0172HL in the format: "String(<Network ID>).String(<LU Name>).HexString(<Uniqueness Value>)=String(<Commit Count>)"
zos.db2.deadlock.holder.network.addressDerived from QW0172HL for IPV4 addresses
zos.db2.deadlock.holder.plan.nameQW0172HP
zos.db2.deadlock.holder.program.nameQW0172Q1
zos.db2.deadlock.holder.stateQW0172HS
zos.db2.deadlock.holder.statement.idQW0172HZ
zos.db2.deadlock.holder.statement.typeQW0172HY
zos.db2.deadlock.holder.thread.tokenQW0172HT
zos.db2.deadlock.holder.trace.idz/IRIS partner APM trace id
zos.db2.deadlock.holder.transaction.nameQW0172HJ
zos.db2.deadlock.holder.uowQW0172HO (first 4 bytes)
zos.db2.deadlock.holder.user.idQW0172HC
zos.db2.deadlock.resourcesQW0172NR
zos.db2.deadlock.timestampQW0172TD
zos.db2.deadlock.waiter.aceQW0172WO (last 4 bytes)
zos.db2.deadlock.waiter.auth.idQW0172WB
zos.db2.deadlock.waiter.collection.idQW0172Q6
zos.db2.deadlock.waiter.connection.idQW0172WN
zos.db2.deadlock.waiter.consistency.tokenQW0172Q8
zos.db2.deadlock.waiter.correlation.idQW0172WR
zos.db2.deadlock.waiter.dbms.idQW0172WI
zos.db2.deadlock.waiter.durationQW0172WD
zos.db2.deadlock.waiter.luw.idDerived from QW0172HL in the format: "String(<Network ID>).String(<LU Name>).HexString(<Uniqueness Value>)=String(<Commit Count>)"
zos.db2.deadlock.waiter.network.addressDerived from QW0172WL for IPV4 addresses
zos.db2.deadlock.waiter.plan.nameQW0172WP
zos.db2.deadlock.waiter.program.nameQW0172Q5
zos.db2.deadlock.waiter.requestQW0172WF
zos.db2.deadlock.waiter.stateQW0172WS
zos.db2.deadlock.waiter.statement.idQW0172WZ
zos.db2.deadlock.waiter.statement.typeQW0172WY
zos.db2.deadlock.waiter.thread.tokenQW0172WT
zos.db2.deadlock.waiter.trace.idz/IRIS partner APM trace id
zos.db2.deadlock.waiter.transaction.nameQW0172WJ
zos.db2.deadlock.waiter.uowQW0172UW
zos.db2.deadlock.waiter.user.idQW0172WC
zos.db2.elapsed.timeQWACASC,QW0058ET
zos.db2.end.timeQWACESC

zos.db2.fetch.orientation

QW0059FO

zos.db2.fetch.sensitivity

QW0059FS

zos.db2.instanceQWHSLOCN
zos.db2.instance.nameQWHSLOCN

zos.db2.location.name

Sources depends on the IFCID:

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

zos.db2.lock.idDerived of QW0172PN
zos.db2.lock.typeFlags for QW0172FR
zos.db2.luw.idDerived from QWHSLWID in the format: "String(<Network ID>).String(<LU Name>).HexString(<Uniqueness Value>)=String(<Commit Count>)"
zos.db2.network.addressDerived from QWHSLWID for IPv4 addresses
zos.db2.object.nameQW0062ON
zos.db2.object.typeQW0062OT
zos.db2.obidQW0172KP
zos.db2.product.idQLACPRID

zos.db2.program.name

Source depends on the IFCID:

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

zos.db2.received.bytesQLACBYTR
zos.db2.remote.location.nameQLACLOCN
zos.db2.response.timeQWACESC - 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.bytesQLACBYTS
zos.db2.sql.lock.statementsQXLOCK
zos.db2.sql.open.statementsQXOPEN
zos.db2.sql.prepare.statementsQXPREP
zos.db2.statement.queryQW0063ST
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.isolationlevelQW0061I
zos.db2.QW0061ST.reoptimizeQW0061RO

zos.db2.request.type

QW0058TOS

zos.db2.sql.storedprocedure.statementsReturns 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.timeQWACBSC
zos.db2.statement.number

Source depends on the IFCID:

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

zos.db2.su.factorQWACSUCV
zos.db2.uniqueness.valueQWHSLUUV (Part of QWHSLWID)
zos.db2.unlock.requestsQTXAUNLK
zos.db2.versionQWHSRN
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.nameQWACWLME
zos.db2.ziip.timeQWACCLS2_zIIP
zos.job.classSMF30CL8
zos.job.cpu.serviceunitsSMF30CSU
zos.job.duration(SMF30TME + SMF30DTE) - (SMF30SIT + SMF30STD)
zos.job.end.timestampSMF30TME + SMF30DTE
zos.job.endedTRUE
zos.job.exec.program.nameSMF3OPGM
zos.job.idSMF30JNM
zos.job.nameSMF30JBN
zos.job.returncodeSMF30SCC (when subtype is 5)
zos.job.start.timestampSMF30SIT + SMF30STD
zos.job.step.cpu.serviceunitsSMF30CSU
zos.job.step.cpu.timeSMF30CPT + SMF30CPS + SMF30ICU + SMF30ISB + SMF30IIP + SMF30RCT + SMF30HPT
zos.job.step.duration(SMF30TME + SMF30DTE) - (SMF30SIT + SMF30STD)
zos.job.step.end.timestampSMF30TME + SMF30DTE
zos.job.step.endedTRUE
zos.job.step.nameSMF30STM
zos.job.step.numberSMF30STN
zos.job.step.returncodeSMF30SCC (when SMF Type 30 subtype 4)
zos.job.step.tape.mountsSMF30PTM + SMF30TPR
zos.job.step.ziip.timeSMF30_TIME_ON_IFA + SMF30_TIME_ON_ZIIP
zos.job.tape.mountsSMF30PTM + SMF30TPR
zos.job.typeSMF30WID
zos.job.user.idSMF30UIF
zos.job.user.nameSMF30USR
zos.lu.nameQWHSLUNM
zos.network.addressDerived from QWHSLWID for IPv4 addresses
zos.network.idQWHSNID
zos.racf.group.idSMF30GRP
zos.racf.user.idSMF30RUD
zos.subsystem.nameSMFHDR_WID
zos.sysplex.nameSMF30SYP
zos.system.nameSMFHDR_SID
zos.workload.nameSMF30WLM
zos.workload.service.class.nameSMF30SCN
zos.ziip.timeQWACCLS1_zIIP