SEO

I've got this in online.log:

Mon Feb 14 10:12:40 2005

10:12:40 Event alarms enabled. ALARMPROG =
'/opt/informix/etc/log_full.sh'
10:12:46 DR: DRAUTO is 0 (Off)
10:12:46 Informix Dynamic Server Version 7.30.U Software Serial
Number AAC#A404657
10:12:46 Informix Dynamic Server Initialized -- Shared Memory
Initialized.
10:12:46 Physical Recovery Started.
10:12:46 Physical Recovery Complete: 131 Pages Restored.
10:12:46 Logical Recovery Started.
10:13:21 Logical Log Files are Full -- Backup is Needed

I can't seem to figure out what to do to just get rid of this condition
-- I don't care if the data base gets blown away (it's backed up), I
don't care about recovering what's in the logs, I just want to get the
engine back so I can use the thing.

Can somebody please tell me what the magic incantation is?

Thanks.

Thomas Ronayne wrote:
> I've got this in online.log:
>
> Mon Feb 14 10:12:40 2005
>
> 10:12:40 Event alarms enabled. ALARMPROG =
> '/opt/informix/etc/log_full.sh'
> 10:12:46 DR: DRAUTO is 0 (Off)
> 10:12:46 Informix Dynamic Server Version 7.30.U Software Serial
> Number AAC#A404657
> 10:12:46 Informix Dynamic Server Initialized -- Shared Memory
> Initialized.
> 10:12:46 Physical Recovery Started.
> 10:12:46 Physical Recovery Complete: 131 Pages Restored.
> 10:12:46 Logical Recovery Started.
> 10:13:21 Logical Log Files are Full -- Backup is Needed
>
> I can't seem to figure out what to do to just get rid of this condition
> -- I don't care if the data base gets blown away (it's backed up), I
> don't care about recovering what's in the logs, I just want to get the
> engine back so I can use the thing.
>
> Can somebody please tell me what the magic incantation is?
>
> Thanks.

Humm, well post an onstat -l, and an onstat -x

And / or try

LTAPEDEV /dev/null and try restarting the engine

Also, look to upgrade

--
"I have enough problems remembering my opinions, let alone justifying them."

"Sorry, I thought you tapped me."

TBP wrote:

> Humm, well post an onstat -l, and an onstat -x
>
> And / or try
>
> LTAPEDEV /dev/null and try restarting the engine
>
> Also, look to upgrade
>
OK, onstat -l:

Informix Dynamic Server Version 7.30.U -- Fast Recovery -- Up
02:24:46 -- 8888 Kbytes

Physical Logging
Buffer bufused bufsize numpages numwrits pages/io
P-1 0 16 0 0 0.00%
phybegin physize phypos phyused %used
10003f 500 280 0 0.00

Logical Logging
Buffer bufused bufsize numrecs numpages numwrits recs/pages pages/io
L-1 4 16 0 0 0 0.0 0.0
Subsystem numrecs Log Space used

Buffer Waiting
Buffer ioproc flags
L-1 101212e4 0x1 0

address number flags uniqid begin size used %used
10039324 1 U-B---- 37 100233 250 250 100.00%
10039340 2 U---C-L 38 10032d 250 250 100.00%
1003935c 3 U-B---- 33 100427 250 250 100.00%
10039378 4 U-B---- 34 100521 250 250 100.00%
10039394 5 U-B---- 35 10061b 250 250 100.00%
100393b0 6 U-B---- 36 100715 250 250 100.00%

and onstat -x:

Informix Dynamic Server Version 7.30.U -- Fast Recovery -- Up
02:25:44 -- 8888 Kbytes

Transactions
address flags userthread locks log begin isolation retrys coordinator
10146014 A---- 10120014 0 0 COMMIT 0
10146164 A---- 101204c8 0 0 COMMIT 0
101462b4 A---- 1012097c 0 0 COMMIT 0
10146404 A---- 10120e30 0 0 COMMIT 0
10146554 A---- 101212e4 0 0 COMMIT 0
101466a4 A-R-- 101212e4 0 33 COMMIT 0
6 active, 128 total, 0 maximum concurrent

And LTAPEDEV already is /dev/null in onconfig.

Frankly, I don't know what any of the above means, so I am a lost lamb
in the electronic woods.

Thanks.

On Mon, 14 Feb 2005 17:40:12 GMT, Thomas Ronayne
<trona@REMOVETHISameritech.net> wrote:

What is LBUPRESERVE set to?


JWC

It's set:

onconfig:LBU_PRESERVE 0 # Preserve last log for log backup

Actually, a support guy at work had the answer:

onmode -l

seems to do the trick.

John Carlson wrote:

>On Mon, 14 Feb 2005 17:40:12 GMT, Thomas Ronayne
><trona@REMOVETHISameritech.net> wrote:
>
>What is LBUPRESERVE set to?
>
>
>JWC
>
>
>

On Sat, 19 Feb 2005 13:59:09 GMT, Thomas Ronayne
<trona@REMOVETHISameritech.net> wrote:

>It's set:
>
> onconfig:LBU_PRESERVE 0 # Preserve last log for log backup
>

.. . . which means (if I remember correctly) that Informix will not
preserve the last log for adding additional logs.

>Actually, a support guy at work had the answer:
>
> onmode -l
>
>seems to do the trick.
>
>John Carlson wrote:
>
>>On Mon, 14 Feb 2005 17:40:12 GMT, Thomas Ronayne
>><trona@REMOVETHISameritech.net> wrote:
>>
>>What is LBUPRESERVE set to?
>>
>>
>>JWC
>>
>>
>>