Re: Monitoring space
Well you can write a script to do this. You can get the information
either by running onstat -d or by querying the sysmaster database.
If you run onstat you need to parse the output. If you read the
systmaster database no parsing is needed.
The sysmaster tables you will be interested in are sysdbspaces and
syschunks.
-Bill
>
> I am curious if anyone can suggest to me a way to monitor available
> space in dbspaces automatically and warn when it drops to a critical
> level. We currently have a space with several chunks totally 100M.
> It ran out of space this morning, and we had to add another chunk.
> I would like to be wraned of this so I could correct it before we
> actually run out.
>
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> | Elizabeth Finson efinson@uswest.com|
> | Web Site/Systems Administrator (206) 345-2751|
> | U S WEST Creative Services |
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> | Look: trees do exist; the houses that we live in still |
> | stand. We alone fly past all things, as fugitive as the |
> | wind. -- Rainer Maria Rilke |
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>
>
>
--
Bill Ennis Voice: 312-474-7516
SSA Fax: 312-474-7460
500 W. Madison emails: ennis@ssax.com ennis@starnetusa.com