Re: Logical log backup problem
David Williams wrote:
>
> In article <662009$f12$1@arctic.discover.net>, "Eric R. Gavin"
> <Eric_Gavin@maf.org> writes
> >Hello,
> >
> >I'm attempting to back up my logical logs, using ontape, and I'm
> coming
> >across a few problems.
> >
> >We've had ODS7.23 up and running for a while and, regrettably,
didn't
> >realize we needed to back the things up until just yesterday.
> >
> >We have about 70 logical log files, each 5MB big contributing to the
> logical
> >log, and when I ran onstat -l, they were ALL 100% full except for
the
> last
> >one which was around 86% full.
> >
> >All preceeding logs had the status of U---B---- while the last one
> was U-C-L
> >(dashes, not to scale)
> >
> >Since then, I've discovered that it continues to add logical log
> files
> >because our LOGSMAX parameter is set to 95. But I am worried. It's
> going
> >to run out soon, and I don't want to keep upping the LOGSMAX
> parameter.
> >
> >Why are the log files not being freed? The documentation says to
> just
>
> There was a change in Online 7.10.UD1, logical logs are no longer
> freed until the moment there are reused. Also long as they are (U)sed
> and (B)acked up and do not contain any open transactions they will be
> reused.
>
> This changes was so that you can use onlog to still examine them.
> This also helps Informix Technical Support.
>
> >shutdown to quiescent mode to roll back any transactions that would
> keep
> >them from being freed, but this does not work. Even a cold reboot
of
> the
> >machine will not free these logs. Can somebody help me with this?
You can get this information from SMI as follows:
SELECT uniqid, (used/size*100)
FROM sysmaster:syslogs
WHERE uniqid >= (
SELECT MIN(tx_loguniq)
FROM sysmaster:systrans
WHERE tx_loguniq > 0
)
UNION
SELECT uniqid, 0.00
FROM sysmaster:syslogs
WHERE uniqid < (
SELECT MIN(tx_loguniq)
FROM sysmaster:systrans
WHERE tx_loguniq > 0
)
[ Should this go in the FAQ David? ]
Cheers,
--
Mark.
+----------------------------------------------------------+-----------+
|Mark D. Stock - Informix SA http://www.informix.com |//////// /|
|mailto:mdstock@informix.com FAQ http://www.iiug.org |///// / //|
| +-----------------------------------+//// / ///|
| Tel: +27 11 807 0313 |If it's slow, the users complain. |/// / ////|
| Fax: +27 11 807 2594 |If it's fast, the users keep quiet.|// / /////|
|Cell: +27 83 250 2325 |Therefore, "No news: travels fast"!|/ ////////|
+----------------------+-----------------------------------+-----------+