Created:  | Updated: 


z/IRIS enables the JDBC observability for JDBC calls processed by IBM Db2 for z/OS systems Instana APM. Refer to Distributed Db2 for z/OS observability for more information about how z/IRIS traces JDBC requests.


Requirements

z/IRIS instrumentation should be activated with Instana Java agents to that have been configured to enable z/IRIS related JDBC instrumentation.

Refer to How to Enable system-wide Instana instrumentation for more information about activating z/IRIS instrumentation.

Db2 Accounting span

Unless otherwise specified below, the tags in Instana Db2 Accounting traces are the same as the tags in Db2 Accounting traces for OpenTelemetry

Instana Tag

OpenTelemetry Tag Name

Notes

endpoint.name

host.name

The z/OS LPAR which hosts the Db2 server that processed the JDBC request.

service

service.name

Click on the image to enlarge

>> Distributed Db2 for z/OS observability
>> Db2 Accounting trace tags

Db2 Deadlock span

Unless otherwise specified below, the tags in Instana Deadlock traces are the same as the tags in https://mainstorconcept.atlassian.net/wiki/spaces/PKB/pages/949092405/Db2+Deadlock+trace+attributes+with+OpenTelemetry#Deadlock-span .

Instana Tag

OpenTelemetry Tag Name

Notes

endpoint.name

host.name

The z/OS LPAR which hosts the Db2 server that processed the JDBC request.

service

service.name

Click on the image to enlarge

>> Db2 Deadlock trace attributes
>> Distributed Db2 for z/OS observability

Db2 deadlock resource name (RNA) child spans

Unless otherwise specified below, the tags in Instana Deadlock traces are the same as the tags in https://mainstorconcept.atlassian.net/wiki/spaces/PKB/pages/949092405/Db2+Deadlock+trace+attributes+with+OpenTelemetry#Db2-Resource-name-span .

Instana Tag

OpenTelemetry Tag Name

Notes

endpoint.name

host.name

The z/OS LPAR which hosts the Db2 server that processed the JDBC request.

service

service.name


Click on the image to enlarge

>> Db2 Deadlock trace attributes with OpenTelemetry
>> Distributed Db2 for z/OS observability

Db2 deadlock waiter and holder child spans

Instana Tag

OpenTelemetry Tag Name

Notes

endpoint.name

host.name

The z/OS LPAR which hosts the Db2 server that processed the JDBC request.

service

service.name

Click on the image to enlarge

Db2 Deadlock Participant span

For more information about Db2 Deadlock Participant traces, click here.

Unless otherwise specified below, the tags in Instana Deadlock traces are the same as the tags in https://mainstorconcept.atlassian.net/wiki/spaces/PKB/pages/949092405/Db2+Deadlock+trace+attributes+with+OpenTelemetry#Deadlock-Participant-span .

Instana Tag

OpenTelemetry Tag Name

Notes

endpoint.name

host.name

The z/OS LPAR which hosts the Db2 server that processed the JDBC request.

service

service.name

Click on the image to enlarge

Deadlock APM events

z/IRIS will also create an Instana event for each Db2 z/OS deadlock trace (IFCID 172). See https://mainstorconcept.atlassian.net/wiki/spaces/PKB/pages/1333428231/OpenTelemetry+events#Db2-Deadlock-events for details about the event data.

Click on the image to enlarge

Use the Instana Analyze dashboard to search for traces with the Trace ID provided in the deadlock event details.

>> https://mainstorconcept.atlassian.net/wiki/spaces/PKB/pages/1333428231/OpenTelemetry+events#Db2-Deadlock-events

>> OpenTelemetry To Instana Trace SDK Web service Transformation