Re: Problem with Informix Logspace (urgent)

On Mon, 28 Apr 1997, Georg Schmid wrote: > Hi everybody ! (I'm new to this group). Heya, Georg. > I've got the following problem with Informix 6.0 running on Solaris2.5: 6.0 eh? Gee, that takes me back. Anyway... > To avoid a 'Long transaction aborted ...' > i added a new chunk to my rootdbs (200 MB). Alright, but in future I'd recommend using a dedicated dbspace for your logical logs, and moving the physical log out of rootdbs (and into a discrete space) as well. However, what's done is done, so... > Then i tried to add new logspace using the following two methods: > (i've got to mention that i changed the LOGSIZE parameter in the > ONCONFIG file recently from 1000 to 20000 (KB)). That won't work. Default size (I'm sure someone will correct me if I'm wrong) is set during installation (or an oninit -i (which I don't recommend)). However, onparams has an option (in 7.x at least) -s that allows you to specify a size while creating a log. > 1. 'onparams -a -d rootdbs'. > This went ok and used up 20 MB in my new chunk. It did? Interesting. > 2. Using 'onmonitor' im 'quiescent'-mode. Curiously enough > onmonitor only shows the old LOGSIZE value (1000 KB) > and adds logspace in sizes of 1 MB. Curioser and curioser, etc. > First question: > Is 'onparams' reading a different ONCONFIG-file then 'onmonitor' ? Not likely, but LOGSIZE is not one of the parameters I'd recommend fiddling with manally in any case. > Second question: > Why doesn't onmonitor show the new logfiles ? (according to the manuals > they should be displayed with an 'A' for 'Added'). I thought you said (in 2. above) that they did exist? Now I'm confused. Please explain further. I wouldn't be surprised if they existed but had a 1 MB size. > After that i created a level-0 archive using 'ontape -s -L 0'. > Now the new logfiles should have an 'F' according to the manuals, > but still no logfiles show up in onmonitor. As above. > How can i persuade Informix to use the new logspace ? Does it, or does it not, exist at this point? > Any hint would be appreciated. Hint of the day: Dust bunnies make poor pets. -Richard