how to reduce accounting trace to the minimum

Billy Larsen

how to reduce accounting trace to the minimum
Our MVS/MICS team is overflowed with the SMF records produced by our
production DB2, i want to reduce the accounting trace to minimum, but want
to keep tracks of the programs executed .
I've stopped the accounting trace and do this :
Start trace(acctg) class(30) ifcid(239)

can i reduce more ?

class 1 accounting starts ifcid 3,106,239
with ifcid 3 only started i have elapsed ,sql counters info, locks counters
and bufferpool accounting
ifcid 106 seems to be associated with zparms parameters
ifcid 239 seems to give the same info as ifcid 3 , but without bufferpool
info.

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

nguyen duc tuan

Re: how to reduce accounting trace to the minimum
(in response to Billy Larsen)
be careful, ifcid 239 is ifcid 003 overflow, i've tried the same as you the
long time ago, and i remeber that i have nothing in SMF 101 when only ifcid
239 is active

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Roland Schiradin

Re: how to reduce accounting trace to the minimum
(in response to nguyen duc tuan)
DB2 V8 will helps to reduce the number of SMF101 records using accumulation.

We have the same problem with huge SMF101 and I code an IEFU84 exit
to suppress records for some application (e.g. CICS-Threads, Batch-Threads, TSO).

Most accounting info for these application are in SMF110 for CICS or other SMF records.
For accounting we need the records from xxxxDIST Plan DISTSERV.

Our DB2 monitor didn't relay on SMF records it starts his own trace to OP6.

Regards
Roland

-----Original Message-----
From: DB2 Data Base Discussion List
[mailto:[login to unmask email] On Behalf Of Billy Larsen
Sent: Thursday, December 23, 2004 1:05 PM
To: [login to unmask email]
Subject: how to reduce accounting trace to the minimum


Our MVS/MICS team is overflowed with the SMF records produced
by our production DB2, i want to reduce the accounting trace to
minimum, but want to keep tracks of the programs executed .
I've stopped the accounting trace and do this : Start
trace(acctg) class(30) ifcid(239)

can i reduce more ?

class 1 accounting starts ifcid 3,106,239
with ifcid 3 only started i have elapsed ,sql counters info,
locks counters and bufferpool accounting ifcid 106 seems to be
associated with zparms parameters ifcid 239 seems to give the
same info as ifcid 3 , but without bufferpool info.

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm