Hello
A company I work for uses INFORMIX Vn. 7.23. As one of
its future administrators, I have a problem with checking
how full the logical logs are, since {onstat -l} now says
all logs but the current one are "used" (and 100% "full"),
once they have been used at all since the initialisation
of the server. Under previous versions {tbstat -l} spoke of
"free" and "used" logs, and we could prevent problems by
occasionally checking how many logs were still free at any
given time.
I've searched the descriptions I have of the "sysmaster"
database, tried a few SELECTs on "syslogs", but I don't get
any information on which logs are truly free - there is a
column called "is_backed_up", but it gets set for logs that
are still in transaction, too, so it doesn't seem to be
any help...
INFORMIX Germany has said "it's a feature not a bug" at
some earlier stage. Before we ask them again (which costs
money since we're not on a hot-line contract), can anyone
help?
Thanks for your time...
-------------------==== Posted via Deja News ====-----------------------
http://www.dejanews.com/ Search, Read, Post to Usenet