Re: Log file full, no tape backup to reset it

It can be done - BUT VERY CAREFULLY !!! I don't think that setting the LTAPEDEV to /dev/null will help you (well, I could be wrong if I didn't understand the question). You have to now the rootdbs reserved pages structure - look at them in Informix Administrator Guide. You could approach this issue in two ways: 1. By editing the PAGE_1CKPT & PAGE_2CKPT and then by modifiying the log pages (this is not a very easy way) 2. By creating another Informix instance with the same number (and size) of logical logs as in your old instance and then: a. Copying the PAGE1_CKPT and PAGE_2CKPT from your new instance into your old instance chunk. b. Copying the CURRENT log (well, you could copy just the pages used in this log) from your new instance to your old instance chunk. The number and the position of your current log you can find using "oncheck -pr" command. Best Regards, Octav On Mon, Mar 15, 1999 at 07:57:43AM -0600, Madison Pruet wrote: > Set your LTAPEDEV to /dev/null (or NUL on NT). > > Elizibeth Loveland wrote: > > > My log file became full when i was building a new db in the server. I > > used onstat -u/-s to get into quiescent mode so I could use > > onmonitor/onparams to remove logs or add space but, although there was > > no error from onstat, the engine would not execute the > > onparams/onmonitor instruction and always returned a stmt that I had to > > be in quiescent mode -- even though I was or had atleast successfully > > executed the command. > > > > This is not a live db and I do not have a working tape unit on it or > > care about saving the log file. There are other db's on the server that > > I do want to keep -- also not live. > > > > How can I reset the logfile status without a backup? > > Someone have some quick & dirty (db not live) to get beyond this and > > get the engine up and running normally again? > > > > Thanks. > > > -- Octav Chiriac Phone: (373) 2 21 20 96 NetInfo S.R.L. Fax: (373) 2 21 36 59 Chisinau (373) 2 24 00 83 Moldova, Republic of mailto:com@netinfo-moldova.com