Datacom SQL traces how to turn on/off

book

Article ID: 192919

calendar_today

Updated On:

Products

CA Datacom CA Datacom - AD CA Datacom/DB CA Datacom/AD CA Datacom/Server

Issue/Introduction

How to turn on and turn off Datacom SQL TRACE?

Cause

Datacom Support may request Datacom SQL trace(s) to analyze based on a situation your SQL query is experiencing. 

Environment

CA Datacom/DB SQL
CA Datacom/AD SQL
CA Datacom Server

Resolution

To turn on the traces run the batch DBUTLTY utility with SYSIN:

COMM OPTION=ALTER,TRACE=NONE                                 <--turn off any existing activated traces.
COMM OPTION=CLRPXX                                                        <-- clears the existing PXX SYSOUT or PXX dump.
COMM OPTION=ALTER,TRACE=trace,JOBNAME=jobname <-- turn on trace for specific jobname. Use multiple statements for additional traces.

 

Run the application or run the query with the DBSQLPR utility to produce the trace.

Then turn off the trace by running the batch DBUTLTY utility with SYSIN:

COMM OPTION=ALTER,TRACE=NONE

To provide the trace, provide the entire Datacom MUF jes log when SYSOUT startup option is used.
If no SYSOUT, run DBUTLTY with SYSIN:

REPORT AREA=PXX,DUMPS=TRACE

Provide the Datacom MUF jes log and the PXX trace output to Support.

Additional Information

For example:

COMM OPTION=ALTER,TRACE=trace1,JOBNAME=jobname
COMM OPTION=ALTER,TRACE=trace2,JOBNAME=jobname

For more information on CA Datacom PXX dumps and TRACEs, refer to CA Datacom Core 15.1 section "COMM ALTER (Modify Error Table)" 

https://techdocs.broadcom.com/content/broadcom/techdocs/us/en/ca-mainframe-software/database-management/ca-datacom/15-1/reference/dbutlty-reference/utility-function-summary/comm-communicate-with-muf/comm-alter-modify-error-table.html#concept.dita_a88de43f9a9654cf8b0dcca801fd83aa35957210_SampleReportCOMMALTER