Re: Delete Logical Logs
Posted in 1998
Neil Truby — — source: Informix-list mailing list archive (1991-1998)
jlsmith269@my-dejanews.com wrote:
>
> I am trying to delete some logical logs that are sitting in my rootdbs. When
> I use the onparams -d -l 1 command to remove log 1, I get "Can only drop an
> unused logical log". I am running version 7.3. When I look at my
> logs(onstat - l), They show U_B, which is used and backed up. How do I get
> them marked as "F" to delete them?
You don't. U_B is fine. There's a minimum number you have to have,
three I think. Are you sure you're not trying to slip beneath this
minimum? Or that your logs don't contain long transactions or most
recent checkpoints (flags L and C respectively)?
Neil Truby
aracnet Limited
Weybridge, UK