Re: FW: Upgrading from 7.31 to 9.3 - storage requirements
Coder wrote: > We could think of no reason for the growth either, but alas it happened. > Since it was over a year ago, no we don't have any case numbers written > down. The 1st weekend after our upgrade to 9.3, we performed our > standard reorg processes. Unloading data, dropping tables, standing > 'em back up and rebuilding indexes & updating stats (we have these > procedures automated by now). We ended up having to add enough > chunks to increase each DB space to 10gb (original entire DB spaces > were typically 3 to 3 1/2 gb. This over growth happened regardless > or our setting index fill factor to 100 %. After many calls to IBFormix, > some tech finally admited to the detached indexes not only being > large, but like I'd said, inefficient due to some code mistakes. We > found about the DEFAULT_ATTACH variable, set it up, and next reorg > time everything shrunk back to normal (alice drank the other potion). Did you fragment over 5 dbspaces, perhaps? -- Ciao, The Obnoxious One "Ogni uomo mi guarda come se fossi una testa di cazzo"
Obnoxio The Clown <obnoxio@hotmail.com> wrote: > > >Did you fragment over 5 dbspaces, perhaps? > >-- >Ciao, >The Obnoxious One > >"Ogni uomo mi guarda come se fossi una testa di cazzo" no, but thanks for trying. Only 1 % of our tables are fragmented in the entire instance. "The only time we detach indexes now is when we fragment tables." And that is to get around another problem with serial keys & indexes on fragmented tables (but thats another story all togeather). My site does not have a problem, but thank you all very much for trying to assist. I am trying to recomend to Dirk to use the DEFAULT_ATTACH variable in his informix.rc file. It should take care of his problems like it did ours. :) ----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==---- http://www.newsfeed.com The #1 Newsgroup Service in the World! >100,000 Newsgroups ---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =---