Traces doubt...

ritu zee

Traces doubt...
Thank you very much James and Michael, I really
appreciate the very basic information you provided me
with regarding buffer pools.
In my efforts to enhance familiarity with DB2, I have
some doubts regarding traces. When I do a -DISPLAY
TRACE(*), I see some traces which are active here in
our shop. But how do I see the output of the traces?
It shows DEST as SMF and OP2. What is SMF and OP2? Are
these some kind off ddnames for some datasets which I
can open and take a look at?

Also, in our installation, we have a performance
monitor and it shows INDB2_TIME for various plans
which I believe is the time spent for actual plan
execution (of course including processing + wait
times). But, my question is….where is the monitor
getting this information from? Here Class 2 for
Accounting trace is not active. I was under the
impression you need Accounting Class 2 trace up and
running for plan specific information. Here only Class
1 and 3 in accounting traces are running.

As always, appreciate your inputs.

Ritu.


__________________________________________________
Do You Yahoo!?
Yahoo! Shopping - Thousands of Stores. Millions of Products.
http://shopping.yahoo.com/



HARBRY ARIZA

Re: Traces doubt...
(in response to ritu zee)
Ritu:

When you do a -DISPLAY TRACE(*) command, It shows DEST for yours db2
traces. DEST SMF means that db2 trace records will be filled in the smf
datasets and SMF OP2 means that your records will be filled in differents
trace datasets rather than SMF.(most of the cases OPX , where x can be from
1 to 7 , is used by third party monitors like BMC Activity Monitor, CA
Insight, Omegamon and that is why is preety handy read those small datasets
to get a trace information rather read the SMF dataset where all the system
trace record are recorded.



>From: ritu zee <[login to unmask email]>
>Reply-To: DB2 Data Base Discussion List <[login to unmask email]>
>To: [login to unmask email]
>Subject: Traces doubt...
>Date: Fri, 22 Dec 2000 15:50:29 -0800
>
>Thank you very much James and Michael, I really
>appreciate the very basic information you provided me
>with regarding buffer pools.
>In my efforts to enhance familiarity with DB2, I have
>some doubts regarding traces. When I do a -DISPLAY
>TRACE(*), I see some traces which are active here in
>our shop. But how do I see the output of the traces?
>It shows DEST as SMF and OP2. What is SMF and OP2? Are
>these some kind off ddnames for some datasets which I
>can open and take a look at?
>
> Also, in our installation, we have a performance
>monitor and it shows INDB2_TIME for various plans
>which I believe is the time spent for actual plan
>execution (of course including processing + wait
>times). But, my question is….where is the monitor
>getting this information from? Here Class 2 for
>Accounting trace is not active. I was under the
>impression you need Accounting Class 2 trace up and
>running for plan specific information. Here only Class
>1 and 3 in accounting traces are running.
>
> As always, appreciate your inputs.
>
>Ritu.
>
>
>__________________________________________________
>Do You Yahoo!?
>Yahoo! Shopping - Thousands of Stores. Millions of Products.
>http://shopping.yahoo.com/
>
>
>
>
>

_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.



Joel Goldstein

Re: Traces doubt...
(in response to HARBRY ARIZA)
The OPx destinations are not datasets. These are memory
buffers used by the IFI interface, and the only way to get data
from them is to to have a program running using IFI.
When a program starts a trace, it is assigned an OPx buffer.
I don't think you can read from a buffer that is not assigned
to your IFI program (never tried to do this).
Regards,
Joel

>Message text written by DB2 Data Base Discussion List
>From: HARBRY ARIZA <[login to unmask email]>
>Subject: Re: Traces doubt...
>To: [login to unmask email]

Ritu:

When you do a -DISPLAY TRACE(*) command, It shows DEST for yours db2
traces. DEST SMF means that db2 trace records will be filled in the smf
datasets and SMF OP2 means that your records will be filled in differents
trace datasets rather than SMF.(most of the cases OPX , where x can be from
1 to 7 , is used by third party monitors like BMC Activity Monitor, CA
Insight, Omegamon and that is why is preety handy read those small datasets
to get a trace information rather read the SMF dataset where all the system
trace record are recorded.<



HARBRY ARIZA

Re: Traces doubt...
(in response to Joel Goldstein)
Joel:


I know that opx are not datasets. They are just buffers that drive your
trace records to be recorded in a partitular dataset depending on your IFI
Program. Here we have Activity Monitor and it used DEST OP7 and it own trace
datasets. It means we don't need to read SMF or any different datasets
because all the db2 trace record will be filled in the Activity Monitor
trace datasets. Thanks for your email,

Regards,

Merry Christmas

Harbry


>From: Joel Goldstein <[login to unmask email]>
>Reply-To: DB2 Data Base Discussion List <[login to unmask email]>
>To: [login to unmask email]
>Subject: Re: Traces doubt...
>Date: Sat, 23 Dec 2000 14:17:12 -0500
>
>The OPx destinations are not datasets. These are memory
>buffers used by the IFI interface, and the only way to get data
>from them is to to have a program running using IFI.
>When a program starts a trace, it is assigned an OPx buffer.
>I don't think you can read from a buffer that is not assigned
>to your IFI program (never tried to do this).
>Regards,
>Joel
>
> >Message text written by DB2 Data Base Discussion List
> >From: HARBRY ARIZA <[login to unmask email]>
> >Subject: Re: Traces doubt...
> >To: [login to unmask email]
>
> Ritu:
>
> When you do a -DISPLAY TRACE(*) command, It shows DEST for yours
>db2
>traces. DEST SMF means that db2 trace records will be filled in the smf
>datasets and SMF OP2 means that your records will be filled in differents
>trace datasets rather than SMF.(most of the cases OPX , where x can be from
>1 to 7 , is used by third party monitors like BMC Activity Monitor, CA
>Insight, Omegamon and that is why is preety handy read those small datasets
>to get a trace information rather read the SMF dataset where all the system
>trace record are recorded.<
>
>
>
>http://www.ryci.com/db2-l. The owners of the list can be reached at
>[login to unmask email]

_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.



Joel Goldstein

Re: Traces doubt...
(in response to HARBRY ARIZA)
Harbry,
Maybe we are just into semantics..... but the opx buffers do not
"....drive trace records to be recorded......"
It's up to the ifi program to specifically write the records out.
In your specific case, AM retrieves the data from the opx buffer and writes
the data to its own datasets.
If an ifi program does not get dispatched quickly enough during a high
trace period,
there will be buffer over-runs and data will be lost.

Merry Christmas,
Joel


Message text written by DB2 Data Base Discussion List
> I know that opx are not datasets. They are just buffers that drive your
trace records to be recorded in a partitular dataset depending on your IFI
Program. Here we have Activity Monitor and it used DEST OP7 and it own
trace
datasets. It means we don't need to read SMF or any different datasets
because all the db2 trace record will be filled in the Activity Monitor
trace datasets. Thanks for your email,

Regards,

Merry Christmas

Harbry<



ritu zee

Re: Traces doubt...
(in response to Joel Goldstein)
Thanks Joel and Harby,

But i still didn't get an answer to
my original question...How do i 'read' trace records
which have gone to SMF? Is SMF a dataset which I can
browse? If yes, how do i know which dataset it is?

Also, my second question was that
if Accounting trace class 2 is not up and running, how
is my monitor showing me 'plan level details' (like
elapsed time, CPU time etc. for the plan).

Thanks.

Ritu.


--- Joel Goldstein <[login to unmask email]>
wrote:
> Harbry,
> Maybe we are just into semantics..... but the opx
> buffers do not
> "....drive trace records to be recorded......"
> It's up to the ifi program to specifically write the
> records out.
> In your specific case, AM retrieves the data from
> the opx buffer and writes
> the data to its own datasets.
> If an ifi program does not get dispatched quickly
> enough during a high
> trace period,
> there will be buffer over-runs and data will be
> lost.
>
> Merry Christmas,
> Joel
>
>
> Message text written by DB2 Data Base Discussion
> List
> > I know that opx are not datasets. They are just
> buffers that drive your
> trace records to be recorded in a partitular dataset
> depending on your IFI
> Program. Here we have Activity Monitor and it used
> DEST OP7 and it own
> trace
> datasets. It means we don't need to read SMF or any
> different datasets
> because all the db2 trace record will be filled in
> the Activity Monitor
> trace datasets. Thanks for your email,
>
> Regards,
>
> Merry Christmas
>
> Harbry<
>
> =======================To
> change your subscription options or to cancel your
> subscription visit the DB2-L webpage at
> http://www.ryci.com/db2-l. The owners of the list
> can


__________________________________________________
Do You Yahoo!?
Yahoo! Shopping - Thousands of Stores. Millions of Products.
http://shopping.yahoo.com/



Joel Goldstein

Re: Traces doubt...
(in response to ritu zee)
SMF is an operating system recording medium for performance data.
The data is written to datasets SYS1.MANx.
These are dumped periodically, and usually accumulated... you'll have
to talk to your MVS folks on where to get at the data.
As far as the actual data. you need a program that can read the
records you want, and format them.... like DB2PM, or the batch
facilities of most of the other online monitors.
You can't browse the data records,as this will be meaningless to you.
Re: class 2 time... it depends. Most online monitors turn this on by
default unles the parameters are changed. Data can also be obtained
by chasing the DB2 internal control block.....

Regards,
Joel

essage text written by DB2 Data Base Discussion List
> But i still didn't get an answer to
my original question...How do i 'read' trace records
which have gone to SMF? Is SMF a dataset which I can
browse? If yes, how do i know which dataset it is?

Also, my second question was that
if Accounting trace class 2 is not up and running, how
is my monitor showing me 'plan level details' (like
elapsed time, CPU time etc. for the plan).

Thanks.

Ritu.<