Re: Stopping Log Files

> Paul Salter wrote: > > > > I am trying to drop my old database and start from scratch. I have > > dropped the data dbspace. But i cannot drop the log dbspace. It states > > the space is not empty. > > > > How do i clear the log dbspace. I have used both archiving and > > chk-point. But i keep moving onto the next log id, which then becomes > > the current log. > > > > Any suggestions on how i might stop this? > > > > Thank you in advance > > > > -- > > Paul Salter > > > > MOCOM Corporation, PO Box 10-278, Wellington, New Zealand > > Phone +64-4-473 1480 Fax +64-4-473 1515 > > email paul.salter@mocom.co.nz > > Informix Online requires 3 logical-logs to be up.Hence you should > move atleast 3 logs to rootdbs before Online can allow you to drop > logdbs. > > Regards, > > Girish > > email:girishpunjabi@hotmail.com As is stated above, you have to have at least three logical logs for Informix to work. Create three new logs (using onspaces or onmonitor) in the root dbspace (they don't have to be very big - try 500 kb each), then take a level 0 archive. This is required before you can use the new logical logs you just added. You may want to point TAPEDEV to /dev/null while you do the level 0 so that it runs faster. Next, use onstat -l and find which logical log is currently being used. Use onmode -l repeatedly to switch to one of the new logical logs, then use onmode -c to force a checkpoint. This will free all of the old logical logs. Now you will have to drop each of the old logical logs, again using either onspaces or onmonitor. Finally, you can drop the dbspace. A related question: Where is your physical log? Frequently when someone moves the logical logs into a separate dbspace they also move the physical log. If it's in the same dbspace as the logical logs, you will have to use onparams to move the physical log back to the root dbspace before you can drop the dbspace. Mark Collins mcollins@us.dhl.com People who have no clear idea what they mean by information or why they should want so much of it are nonetheless prepared to believe that we live in an Information Age, which makes every computer around us what the relics of the True Cross were in the Age of Faith: emblems of salvation.