Re: logical logs full

Hi, If you don't need the logical logs on tape, you can just set the LTAPEDEV parameter to /dev/null. In that case, if the logical log is full the server just marks it as backed up. You don't need to run any command to back up or clear. In your specific case, if the current log(i.e., last log) is full, then the server uses the first log because it is backed up(see the flags U-B---- where 'B' is for back up). Answers specifically to your questions. 1. Should I be worried, or is it ok ? It's perfectly ok. 2. Is it that last one (now at 63%) fills up , will they all be reset to 0% ? No. they will not be reset to 0%. But will be marked as backed up in flags. 3. How do I cleanup these logic. logs. ? No need to cleanup. 4. How automatically setup so they get cleaned up themselves ? Setting LTAPEDEV to /dev/null -ramana In article <7276po$afb@cnj.digex.net>, hashmi@cnj.digex.net (Atiqullah Hashmi) wrote: > Hi, > > I have informix7.3 on a test machine, and we don't archive data to tapes etc. > Here is my config. file info: > > # Physical Log Configuration > PHYSDBS rootdbs # Location (dbspace) of physical log > PHYSFILE 1000 # Physical log file size (Kbytes)> # Logical Log Configuration > LOGFILES 6 # Number of logical log files > LOGSIZE 500 # Logical log size (Kbytes)> # Log Archive Tape Device > LTAPEDEV /dev/null # Log tape device path > LTAPEBLK 16 # Log tape block size (Kbytes) > LTAPESIZE 10240 # Max amount of data to put on log tape (Kbytes) > PHYSBUFF 32 # Physical log buffer size (Kbytes) > LOGBUFF 32 # Logical log buffer size (Kbytes)> LOGSMAX 6 # Maximum number of logical log files > LBU_PRESERVE 0 # Preserve last log for log backup > > Here is onstat -l output(partial): > > address number flags uniqid begin size used %used > a039378 1 U-B---- 13 100233 250 250 100.00 > a039394 2 U-B---- 14 10032d 250 250 100.00 > a0393b0 3 U-B---- 15 100427 250 250 100.00 > a0393cc 4 U-B---- 16 100521 250 250 100.00 > a0393e8 5 U-B---- 17 10061b 250 250 100.00 > a039404 6 U---C-L 18 100715 250 158 63.20 > > I need to cleanup these logs (they show as 100%). I ran ontape -s but > it didn't cleanup these logs. When I run 'ontape -a' or 'ontape -l', it says: > > Logbackup failed - Log backup to device '/dev/null' not allowed > > Questions: > 1. Should I be worried, or is it ok ? > 2. Is it that last one (now at 63%) fills up , will they all be reset to 0% ? > 3. How do I cleanup these logic. logs. ? > 4. How automatically setup so they get cleaned up themselves ? > > Please copy me in your reply. > Thanks for info. > > AH > > -----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own