Hi,

Can anyone help in using DB2 Trace. We have a performance issue, so we are planned to enable DB2 Trace.

1) What are the steps for enabling DB2 Trace?
2) What are the keys parameters that I need to check from DB2 Trace results?

Your Help is appreciated...

Thanks in advance...

Hi

Before you go and start a trace, you need to ask these questions:
1) do you have performance issues with a specific application or the entire system?
2) do you have performance issues with dynamic sql or static sql
3) do you have any monitoring tool such as omegamon ?

starting a trace is easy, but unless you have some tool that parses smf records, you will find it very difficult to extract the data from the trace files

The mechanics of the DB2 trace are quite straightforward. See the -START TRACE command in the DB2 Commands manual.

The tricky part gets into what data you want to collect. As a general practice, Accounting trace classes 1, 2 and 3 can be run. With these, you can establish a base-line of performance for your applications over time through whatever monitoring means you choose (through trend reports, exception reports, etc, depending on the tool(s) you choose to analyze this data).

If you are shooting a specific performance issue, and don't know how to start a trace, then I would suggest you find someone who is familiar with resolving performance problems via DB2 trace and work with them directly.

Hi , Thanks for reply.

Please find my answer below for your questions.

1) do you have performance issues with a specific application or the entire system?
*A) Entire system*
2) do you have performance issues with dynamic sql or static sql
*A) Both Dynamic & Static*
3) do you have any monitoring tool such as omegamon ?
*A) We dont have any monitoring tool*

Please give me a brief answers with example as I am very much new to this. Thanks alot for your time.

Hi,

How to run DB2 traces differs from installation to installation. In some shops the z/OS sysprog prefer that you use SMF. We I work we uses GTF.
This is my own short description what to do.
1) Allocate trace output data set for GTF
2) START GTFTRACE use command /S GTFDB2.GTFDB2,ID=CJ1
CJ1 is part of the dataset name I created a bow
3) Answer the question /nnU (TRACE=USRP and USR=(FB9) is in the GTF JCL)
4) Start your DB2 trace in you case -STA TRACE(STAT) CLASS(1,2,3) DEST(GTF) sounds as a good start (add class 5 if you are in a data sharing environment)
5) Run the system (/application)
6) Stop the DB2 trace
7) Stop GTF

And then the tricky part comes. What to do with the records. Most shops have DB2 PM (or what ever it's name is today) so I for example run a report like this

GLOBAL
INCLUDE (LOCATION (DSN0,DSN2,DSN4))
STATISTICS
REPORT
LAYOUT (SHORT)

The next tricky part is to interpret the data. It's a huge bunch of numbers to try to understand. I recommend that you Google some of John Campbellpressentation from various conferences.

Best Regards, Christer J