Find the message number associated with all the select statements and any
responses you  don't want in the actlog and then at the start of your script
DISABLE EVENT ACTLOG xxxx, then re-ENABLE them when you're done.

Bill Boyer
"My problem was caused by a loose screw at the keyboard" - ??

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU]On Behalf Of
Stef Coene
Sent: Saturday, December 04, 2004 11:22 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: REAL TIME STATS


On Saturday 04 December 2004 14:33, Cain, Jason (Corporate) wrote:
> Are you running SQL statement against the DB,  what kind of data are you
> actually pulling, and from what tables.  I can get real time stats from
> sessions currently running from the sessions table, but that is as far as
I
> have gotten.  We are looking for a way to get real time stats on disk
> util., and bytes backed up per 30 min for an overall TSM healthcheck.
The stats we are making is information about the storage pools (usage in MB,
usage in %, ...), number of sessions that's running (client + SAN), db and
recovery log usage (MB en %).  All this info is stored with rrd so this info
can be used for long term monitoring.
And we do this each 5 minutes, not 15 like I said before.

The tables we use depends on what you want to check.  But with information
found with the "select * from tables "and some sql knowledge, you can do a
lot.

For real time monitoring, we have some havy sql statements to view the
running
sessions and processes.  We also query and show information about processes
that have run (so you can see when a migration kicked in at night).  This
information is not stored wih rrd.

Example of showing running sessions:
select client_name,BYTES_RECEIVED,BYTES_SENT, cast(bytes_received as
decimal(30,0))/cast((current_timestamp-start_time)seconds as decimal(30,0))
as BYTES_REC_PER_SEC, cast(bytes_sent as
decimal(30,0)) /cast((current_timestamp-start_time)seconds as decimal(30,0))
as BYTES_SENT_PER_SEC, cast((current_timestamp-start_time) as varchar(18))
as
elapsed,SESSION_TYPE,CLIENT_PLATFORM from sessions where current_timestamp
!=
start_time and SESSION_TYPE != 'Server'

One problem is that all these selects statements show up in the activity
log.
So it can be dificult to use the activity log to find out what happened on
the server.

Btw, all these scripts are only available to our customers :(
If you are interested in these scripts and/or want to see a demo, you can
mail
me in private.  If there is enough interest, I can, maybe, release the
scripts.

Stef

--
stef.coene AT docum DOT org
 "Using Linux as bandwidth manager"
     http://www.docum.org/