Printing all data per traced thread
On the HT view, type P (Print) in the CM field for a trace.The Batch Trace Print dialog is displayed.
BMC Software ------------ BATCH TRACE PRINT ---------------- PERFORMANCE MGMT
COMMAND ===> TIME --- 15:00
Update job ==> N (Y/N - update job statement) (END to edit JCL)
Title line 1 ==>
Title line 2 ==>
Data Selection:
From date ==> 16SEP2003 Time ==> 1125
To date ==> 17SEP2003 Time ==> 1412
PLAN ==>
AUTHID ==>
CONNECT ==>
CORR ==>
LOC ==>
DB2PKG ==>
REPORT SELECTION:
LTRAC ==> NO (YES/NO)
STRAC ==> NO (NO,ALL,SUMMARY,section1,section2..)
DTRAC ==> NO (YES/NO)
POPUP ==> NO (NO/ALL/SQL/event1,event2,....)
TSUM ==> (A/C/L/P/T) SORT ==> (for any TSUMx)
TSTAT ==> NO (SUMMARY/ALL/NO) INTERVAL ==> 1H (for TSUMT only)- If you are using this option for the first time, you must update your job statements. Specify:Update Job ==> Y
- Press Enter to display a job statement data entry panel.Fill in the required information and return using F3 when you are finished.
- Set the Update job option to N.
Fill in the options for a report.
Option
Description
TITLE1 ==> any title
Optional. Centered in first report header.
TITLE2 ==> any title
Optional. Centered in second report header.
Data Selection is optional. The selection fields can be used to reduce the amount printed from a long trace. The date and time fields are primed with the start and end date-time of the trace.
There are many different reports that can be generated, either singly or in combination. For a full explanation of the options and to see sample reports, browse the printing a trace section in Using. You can also use the sample JCL member DZTBPRNT to generate multiple reports, or to print reports from SMF data. The control statements for several sample reports are provided in BBSAMP member DZJPnnnn, with comments to point out some of the most useful variations.
The reports are based on printouts of the online displays, so the options are selected using the names of these displays, like LTRAC, STRAC, DTRAC. In this tutorial you have chosen STRAC=ALL as the most useful report for application tuning. It shows the following for each thread traced:
- Basic Db2 accounting record data
- Environmental Indicators section
- Elapsed Time Analysis section
- SQL Statement Execution Counts section
- Buffer Pool Usage Analysis section, including Global Buffer Pools
- Lock Activity section, including Global Locks
- I/O Parallelism section
- Routines section (stored procedures and user-defined functions)
- DDF Summary section (if distributed work was done)
- Package/DBRM Overview section (if accounting trace 7 is active)
These sections are included for detail traces:
- SQL Summary section with summary statistics per SQL statement
- Database Summary section with scans per page set
- Database Lock and I/O section with locks and/or I/O data per page set
- Sort Summary section (if any sorts were performed)
- Press Enter to validate your specifications.These options are saved in your profile and used to initialize the fields the next time this panel is requested.
- Press F3 to review the generated JCL in edit mode.The options that you specified are inserted into a pattern job DZJPTRAC in BBPROF. You might want to copy this JCL into your own UBBPROF profile data set and modify it.
- Check the rest of the options.There are many more print options than can be shown on the panel. The sample job contains a short description of these options. Scroll to the bottom to review them.
Submit the job.COMMAND ===> SUB
You can also SAVE the JCL for later execution, or CANCEL it completely.
- Press F3 until you return to the Batch Trace Print dialog.