Logical log problem.
Informix Dynamic Server 7.23 on a UNIX box.
On system console, received message saying the logical logs were full.
We have 20 logical logs of 1 meg each. When looking on onstat -l, 16
logs are flagged 'U B', and the other 4 are flagged 'U C'. Tried to
perform a ontape -a which backs up the current logical log, but does
not touch the other logs marked 'C'.
1. Any idea on how to clear the log files out without restoring from
the last level 0 archive?
2. Any idea why there would be multiple log files marked 'C'
(current).
TIA.
----------------------------------------------------------------
Larry M. Ray U. S. District Court
PC Systems Administrator 106 Gene Snyder U. S. Courthouse
Phone: 502-625-3574 601 West Broadway
Fax: 502-625-3884 Louisville, KY 40202
Email: Larry_M._Ray@kywd.uscourts.gov
----------------------------------------------------------------
larry_m._ray@ck6.uscourts.gov wrote:
>
> Informix Dynamic Server 7.23 on a UNIX box.
>
>
> On system console, received message saying the logical logs were full.
> We have 20 logical logs of 1 meg each. When looking on onstat -l, 16
> logs are flagged 'U B', and the other 4 are flagged 'U C'. Tried to
> perform a ontape -a which backs up the current logical log, but does
> not touch the other logs marked 'C'.
>
> 1. Any idea on how to clear the log files out without restoring from
> the last level 0 archive?
Yes call tech support and have them dial in and repair the reserved
pages.
> 2. Any idea why there would be multiple log files marked 'C'
> (current).
Yes, very old bug that is corrected in later versions. Upgrade 7.23 is
a REALLY bad version.
Art S. Kagel