Erik,
sybase.monitor is written for Adaptive Server Enterprise (v10 and up),
not SQL Anywhere, which is a fundamentally different product that was
developed out of Watcom SQL. (I think they don't even use the
"Adaptive" term in its product name anymore). They're different in the
system table schema etc.
The monitor runs a (rather arcane) query on some system tables to
determine free space, which would have to be different for SQL Anywhere.
Since I don't have access to one of these, I'd be grateful if you could
contribute an equivalent query.
Just look at the SQL text starting at line 72; it returns a table of
(database name, usage, free_megabytes), where usage refers to a segment
being allocated to data and/or log.
The second query looks for deadlocked or otherwise unhealthy processes
and needs similar adjustment.
Thanks
--Peter
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, August 30, 2001 5:17 PM
> To: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
> Subject: sybase.monitor in contrib
>
>
> Greets.
>
> I'm trying to get sybase.monitor v1.1.0 from contrib to work
> here in our
> setup.
>
> We have a number of Sybase Adaptive Server Anywhere 6.x
> databases running,
> that need to be monitored. I found the sybase.monitor from 1999 in
> contrib/ , and have spent quite a bit of the day collecting and
> installing the necessary pieces for DBI connectivity to
> Sybase. Now I can
> connect to the database and run queries and updates, no problem.
>
> Now, the monitor runs, but exits quite quickly with the
> following error -
> leads me to suspect the script was written for some other
> Sybase database
> product.
>
> Detailed text (if any) follows:
> -------------------------------
>
> could not execute query on erik: Server message number=2706
> severity=11
> state=0 line=0
> text=ASA Error -141: Table 'spt_values' not found
>
>
>
> Any Sybase gurus out there that could help me adapt the script to work
> with our database?
>
> --
> Erik I. Bols�, Triangel Maritech Software AS
> Tlf: 712 41 694 Mobil: 915 79 512
>
>
