What is the best practice to collect stats on sybase 12.5 on HP-UX ?
How can I run sp_sysmon? Do you have a small scripts for helping me?

#!/bin/ksh

if [ -z $1 ]

then

TIMELIMIT="'00:10:00'"

else

TIMELIMIT="'$1'"

fi

if [ -z "$SYBASE_OCS" ]

then

SYBPATH="$SYBASE"

else

SYBPATH="$SYBASE/$SYBASE_OCS"

fi

$SYBPATH/bin/isql -Usa -Pxxxxxxxxxx \

-o $SYBASE/statistics/${DSQUERY}_sp_sysmon_`date +%m-%d-%y`_`date
+%H:%M:%S`\

-e <<END

sp_sysmon $TIMELIMIT

go

END

cd $SYBASE/statistics

find . -name ${DSQUERY}_sp_sysmon\* -mtime +30 -exec rm {} \;

exit 0

"David McGeorge" <soalvajavab1 (AT) yahoo (DOT) com> wrote

How can I redirect the output to a log file. basically my goal is to
create a nice formatted historical trend for our prod database

"Willie Kraatz" <wkraatz (AT) csc (DOT) com> wrote

David McGeorge wrote:

At the Unix shell? With ">" or ">>". See your OS docs.

I ended up hacking the code of sp_sysmon to write the stats
I care about (avg cpu busy, opened connections, committed
transactions) to a file. I then have a cron job that runs
my proc periodically. All my stats are then in a Sybase
table where they can be queried easily.


Larry Coon
University of California

On Wed, 21 Jul 2004 13:40:45 -0700, David McGeorge wrote:

The script below *does* output to a file (see the -o option).

Me I run a perl script to generate the sysmon data, which lets me parse
and reformat the output as necessary.

Michael

--
Michael Peppler Data Migrations, Inc.
mpeppler (AT) peppler (DOT) org http://www.peppler.org/
Sybase T-SQL/OpenClient/OpenServer/C/Perl developer available for short or
long term contract positions - http://www.peppler.org/resume.html