Trace Destination Datasets

Lockwood Lyon

Trace Destination Datasets
Dear List,

We have the need to -Start some traces, including Performance traces. Where do I look to associate my own dataset with a specific trace destination?

Yes, I know that I can use DEST(SMF); however, I want to avoid any delays in processing the trace data, and don't really want to use additional resources extracting our (DB2) data from the general-purpose SMF files. I also checked the Admin Guide--it tells about traces in general, but I couldn't find a reference to what destinations correspond to what.

Thanks in advance for any advice or pointers to the correct FMs.

- Lockwood Lyon
Meijer Stores

Lance Jackson

Re: Trace Destination Datasets
(in response to Joel Goldstein)
Lockwood,

Create a GTF proc which will start GTF (generalized trace facility) and
allocate a user dataset. An example of the JCL is:
//GTF EXEC PGM=AHLGTF,PARM='MODE=EXT,DEBUG=NO,TIME=YES',

// TIME=1440,REGION=2880K

//IEFRDER DD DSNAME=&SYSUID..DB2.TRACE,UNIT=CART,

// DISP=(,KEEP),LABEL=RETPD=30,VOL=(,,,8)

//SYSLIB DD DSNAME=SYS1.PARMLIB(GTFPDB2),DISP=SHR

Next, start the performance trace using DEST(GTF). The output trace
dataset can be used as input to DB2PM (or your trace reporting tool of
choice).

Regards,
Lance Jackson
Pandrue Associates, Inc.
215.295.5561


-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email]
On Behalf Of Lockwood Lyon
Sent: Tuesday, January 14, 2003 13:17
To: [login to unmask email]
Subject: Trace Destination Datasets

Dear List,
 
We have the need to -Start some traces, including Performance traces. 
Where do I look to associate my own dataset with a specific trace
destination?
 
Yes, I know that I can use DEST(SMF); however, I want to avoid any
delays in processing the trace data, and don't really want to use
additional resources extracting our (DB2) data from the general-purpose
SMF files.  I also checked the Admin Guide--it tells about traces in
general, but I couldn't find a reference to what destinations correspond
to what.
 
Thanks in advance for any advice or pointers to the correct FMs.
 
- Lockwood Lyon
  Meijer Stores



Joel Goldstein

Re: Trace Destination Datasets
(in response to Lockwood Lyon)
Lockwood,

There are only three possible destinations, SMF, GTF, and IFI.

SMF might cause a problem if you generate large volumes of records - you
can lose data(yours & other System Perf data), or even abend SMF,
However, if you know which SMF dataset is active, you can dump it, or even
extract the records (100, 101, 102) at any time.
Using SMF may cause a lot of overhead.

GTF requires you to have authorization to start it, and you have to know
how to use it. The record headers will be different on GTF, so
may something you don't have in order to process the data. There can only
be ONE GTF trace in your LPAR at a time, and your
Systems programmers mat resist the idea of letting you use it, if you can
get authorization.

IFI requires you to write a program to get the data from the IFI buffers. A
stub example is provided in the DB2 Admin guide.

OR... you can probably use your online monitor do it for you. They all
use IFI as the dest, write the data to their dataset, and probably provide
a utulity to format & print the data.

Regards,
Joel


Message text written by DB2 Data Base Discussion List
>We have the need to -Start some traces, including Performance traces.
Where do I look to associate my own dataset with a specific trace
destination?

Yes, I know that I can use DEST(SMF); however, I want to avoid any delays
in processing the trace data, and don't really want to use additional
resources extracting our (DB2) data from the general-purpose SMF files. I
also checked the Admin Guide--it tells about traces in general, but I
couldn't find a reference to what destinations correspond to what.

Thanks in advance for any advice or pointers to the correct FMs.

- Lockwood Lyon
Meijer Stores<



James Campbell

Re: Trace Destination Datasets
(in response to Lance Jackson)
Another possibilty is to use DSN1SDMP - which copies trace output from an
IFI destination to a dataset. As the output comes without SMF headers,
your print/report program might have difficulties with it.

James Campbell


On Tue, 14 Jan 2003 14:49:02 -0500, Joel Goldstein
<[login to unmask email]> wrote:

>Lockwood,
>
>There are only three possible destinations, SMF, GTF, and IFI.
>
>SMF might cause a problem if you generate large volumes of records - you
>can lose data(yours & other System Perf data), or even abend SMF,
>However, if you know which SMF dataset is active, you can dump it, or even
>extract the records (100, 101, 102) at any time.
>Using SMF may cause a lot of overhead.
>
>GTF requires you to have authorization to start it, and you have to know
>how to use it. The record headers will be different on GTF, so
>may something you don't have in order to process the data. There can only
>be ONE GTF trace in your LPAR at a time, and your
>Systems programmers mat resist the idea of letting you use it, if you can
>get authorization.
>
>IFI requires you to write a program to get the data from the IFI buffers. A
>stub example is provided in the DB2 Admin guide.
>
>OR... you can probably use your online monitor do it for you. They all
>use IFI as the dest, write the data to their dataset, and probably provide
>a utulity to format & print the data.
>
>Regards,
>Joel
>
>
>Message text written by DB2 Data Base Discussion List
>>We have the need to -Start some traces, including Performance traces.
>Where do I look to associate my own dataset with a specific trace
>destination?
>
>Yes, I know that I can use DEST(SMF); however, I want to avoid any delays
>in processing the trace data, and don't really want to use additional
>resources extracting our (DB2) data from the general-purpose SMF files. I
>also checked the Admin Guide--it tells about traces in general, but I
>couldn't find a reference to what destinations correspond to what.
>
>Thanks in advance for any advice or pointers to the correct FMs.
>
>- Lockwood Lyon
> Meijer Stores<
>
>

http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-
[login to unmask email]