Re: logical logs full

Hello, Basically you shouldn't have anything to worry about. This is a change in logical log behavior from 5.x to 7.x for various reasons (mostly to do with HDR and now ER). But in 7.x logical logs are almost never marked as just "F" (free) like they were in 5.x. So as long as the logs are backup (marked with the "B" flag in onstat -l) and an onstat -x doesn't have a transaction that has a beginning logical log unique id that is equal to the lowest logid you currently have, then when the current logical log fills (the one with the "C" flag), online will automatically free the oldest log and switch into it. So that sorta answers 1,2, and 3. With your LTAPEDEV set to /dev/null the logs will automatically be marked as Backed up as soon as they are full, so that is the answer to 4. Atiqullah Hashmi wrote: > Hi,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 -- ******************************************************************** * Jacques P. Renaut "I'd dazzle you with brilliance * * Informix Advanced Support if I only had the knack..." * * email: jrenaut@informix.com #include <disclamier.h> * ********************************************************************