CA Datacom/DB SQL
CA Datacom/AD SQL
CA Datacom Server
Datacom Support may request Datacom SQL trace(s) to analyze based on a situation your SQL query is experiencing.
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.
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)"