Re: Stopping Log Files

Posted in 1998

colin quadros — Wed, 27 May 1998 15:37:17 -0700 — source: Informix-list mailing list archive (1991-1998)

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