View Single Post

   
  #3 (permalink)  
Old 04-20-2008, 07:39 AM
Thomas Ronayne
 
Posts: n/a
Default Re: Logical Log Files are Full -- Backup is Needed



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.
Reply With Quote