Re: When Informix dynamically allocates logical logs, do they dynamically unalloc?

NormaJean Sebastian via DBMonster.com wrote: > Hi all, > Haven't been tuning in much... that's the hazard of not getting the posting > directly to my mail-box anymore... > > anyway... > > I have seen IDS 9.4 (64 bit on Solaris) dynamically allocate locks. > It will do so, but not unalloc them. for example, if i have 1 mill locks, > and the activity blows past that, and IDS dynamically allocs more, say up > to 3.4 mill.... > well after the dust settles, the 3.4 mill locks are still there, it didn't > auto-drop back to the defined number (1 mill). Bouncing the DB sets it > back. That's more or less by design. > Tonight, I have witnessed our first dynamic log allocation (woooo hoooo... > pass the cigars!).... > IDS put it in rootdbs. we added more log space, and it started using that > as it's so smart :) > but I could not find info in the online manuals about what happens after > IDS doesn't need those dynamically alloc'd logs.... > i could not find that they would automatically unalloc. I'm 99% certain they don't auto-unalloc. > I suspect they do not auto-unalloc, just like the dynamic locks did not. > I suspect I have to manually drop them. Yes - me too. > I'm a bit squeamish about dropping anything in rootdbs. Why? Moving log logs out of rootdbs is good practice on systems big enough (with enough disk drives) to warrant the effort. It's pretty painless removing logs - you make sure they're backed up (not in use and not needed) and remove them, IIRC. -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2005.01 -- http://dbi.perl.org/