Overhead for audit trace

John W Amsden

Overhead for audit trace
We are DB2 V7 - Z/OS

We are considering starting an audit trace to track the "SET CURRENT SQLID = 'xxxxxxxx' "
statement. We do not do very many of these. Would anybody hazard a guess as to the
CPU overhead this trace would cause?

Thanks!

---------------------------------------------------------------------------------
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

Dewey Meeks

Re: Overhead for audit trace
(in response to John W Amsden)
If you need to see the catalog on DB2S, I can make you SYSADM for a while.

-----Original Message-----
From: Amsden, John W
Sent: Tuesday, December 21, 2004 2:12 PM
To: [login to unmask email]
Subject: Overhead for audit trace


We are DB2 V7 - Z/OS

We are considering starting an audit trace to track the "SET CURRENT SQLID = 'xxxxxxxx' "
statement. We do not do very many of these. Would anybody hazard a guess as to the
CPU overhead this trace would cause?

Thanks!
--------------------------------------------------------------------------------- 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


---------------------------------------------------------------------------------
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