Printing Db2 Trace Reports

This article describes RIFTF which is a trace formatter.
The
RLX
/IFI program RIFTF (Trace Formatter) formats Db2 IFI Trace data that is collected by the RIFTC utility. The following JCL (in member RIFJREP of the CRAIJCL library) is used to run the RIFTF program in batch.
//RIFJREP JOB (XXXX,1234) //* //* //* (c) Copyright Relational Architects Intl. //* Licensed material - Program property Relational Architects //* //* Print report from collected trace records //* Following DD names must be specified: //* //* RIFTRACE - An output of Trace Collector job (RIFTC) //* RIFCNTL - Control cards used for report selection //* RIFSUMM - An output for Trace Summary Report //* SYSTSPRT - An output for report options, SQLTRACE report and //* information messages //* //* Notes: //* - Verify names of the CRAILOAD and CRAIEXEC libraries //* - Specify the RIFTRACE dataset which was used in the RIFJMON job //* - Review and specify desired RIFCNTL parameters //* //* //REPORT EXEC PGM=IRXJCL,PARM='RIFTF',REGION=4M //STEPLIB DD DSN=RAI.Rvrm.CRAILRAI,DISP=SHR // DD DSN=RAI.Rvrm.CRAILOAD,DISO=SHR //SYSEXEC DD DSN=RAI.Rvrm.CRAIEXEC,DISP=SHR //RIFTRACE DD DSN=RLX.RIFTRACE,DISP=SHR //SYSTSIN DD DUMMY //RIFPRINT DD SYSOUT=* //RIFSUMM DD SYSOUT=* //SYSTSPRT DD SYSOUT=* //SYSUDUMP DD SYSOUT=* //RIFCNTL DD * MAXREC(10) /* Number of trace blocks to read from the /* RIFTRACE file. This option limits the amount of input /* to be processed since it can be voluminous SUMMARY(YES) /* Print Trace Summary report to RIFSUMM DD name SQLTRACE(YES) /* Print SQLTRACE report to the SYSTSPRT DD name EXCLUDE_DUMP(QWHT) /* Exclude dump of the Trace Header EXCLUDE_MAP(QWHT) /* Exclude print of the map of Trace Header //
The job prints TRACE records from the RIFTRACE DD name that were collected by the RIFTC utility.
A maximum of 10 records are processed to avoid voluminous report output. SUMMARY and SQLTRACE reports are printed. The formatting of Trace Headers (in DUMP and MAP form) is suppressed.