Datacom Support may request Datacom SQL trace(s) to analyze based on a situation your SQL query is experiencing.
CA Datacom/DB SQL
CA Datacom/AD SQL
CA Datacom Server
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:
To provide the trace, provide the entire Datacom MUF jes log when SYSOUT startup option is used.
If no SYSOUT, run DBUTLTY with SYSIN:
Provide the Datacom MUF jes log and the PXX trace output to Support.
For more information on CA Datacom PXX dumps and TRACEs, refer to CA Datacom Core 15.1 section "COMM ALTER (Modify Error Table)"