When Informix dynamically allocates logical logs, do they dynamically unalloc?
Posted in 2005
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. 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 suspect they do not auto-unalloc, just like the dynamic locks did not. I suspect I have to manually drop them. I'm a bit squeamish about dropping anything in rootdbs. Advice/education requested.... thanks, Norma Jean -- Message posted via http://www.dbmonster.com