Re: Logical logs full

On Thu, 18 Jan 2001, Duncan Kinnear wrote: > Madison Pruet wrote: > > > While I would not recommend this for any system in production, you can set > > your logical log device to /dev/null (on UNIX - NUL on NT). This will cause > > the logical logs not to be backed up, but will simply flush them. You can > > still have a logged database with transaction, but you will not be able to > > fully restore the database to the point of a failure. This works fine for > > test systems (or for 'play' systems) ;-) > > We've set up /dev/null in the config.arc file. Then we used onarchive to set > up a VSET, but defining a volume as per the manual gives us an error saying: > > ARC-E-01165, Undefined device (see CONFIGURATION file) > > Here's the entry in the config.arc file: > > ! Device available for onarchive. > DEVICE HO = /home > DEVICE ho = /home > DEVICE DISK = /disk/path > DEVICE disk = /disk/path > DEVICE TAPE = /dev/tapedev, /dev/tapedev2 > DEVICE tape = /dev/tapedev, /dev/tapedev2 > DEVICE TAPE_VOP = /dev/tapedev > DEVICE tape_vop = /dev/tapedev > DEVICE del = /dev/null > DEVICE DEL = /dev/null > > and here's the onarchive command and it's output: > > ON-Archive Version 7.30 > Copyright (c) 1993,1994 - Informix Software, Inc. > > Onarchive> DEFINE/VOLUME/VSET=devnull/MAX_SPACE=10000- > _Onarchive> /VIRTUAL=(/) > > ARC-E-01165, Undefined device (see CONFIGURATION file). > > Any ideas? > > Cheers, > > Duncan Kinnear. > I haven't used onarchive, but the /dev/null setting has to be set in the Informix config file usually. Either that, or it points to a literal tape device like /dev/rmt/0c, or it has a link like /informix/TAPEDEV that points to a literal device. John