Re: How do I initialize the root dbspace?

Hi, You've a several things mesing you up. Hopefully, I will identify them all. For starters, the rootdb space will be used as the home of your logical and physical logs when you reinitialize. This means that you need enough space for all logical and physical logs plus space for systmaster. You mentioned that you changed the logs size. Now, having several chunks that make up the rootdbspace I'm really not sure if the 2nd and 3rd will be used on a reinit. What is your ROOTSIZE set to in onconfig? Maybe you should just set it to 60MB? It's customary to put the logical and physical logs into their own dbspace(s). You don't have to doo this but the root dbspace needs to be able to fit them - along with other things that belong in the rootspace. -Bill } } Hi, } } Informix 7x, Solaris 2x. Being new to Informix, we made a lot of typical } novice mistakes when we first installed it, 2K logical log sizes, } underestimated db sizes resulting in dbspaces with many chunks, etc. Since } we are a development company and we only use the databases for testing, it } is not important for us to do the normal dba performance kind of stuff. } However, I ran into a problem (running out of space again) while loading up } a customer's database. So, I thought that now would be a good time to } clean up some of the crap. So here is what I did. } } 1) I exported the databases (2) we needed to save and dropped them. } 2) I dropped the db space for these two databases and recreated it so it } had one chunk (87,500 pages). } 3) I left the root space alone. (currently 3 chunks 35,000 20,000 and } 10,000). } 4) It says there are only 59,000 pages free in the root space( out of } 125,000). } 5) The only loaded database is sysmaster. Why is sysmaster taking up so } much space when there are no other databases? } 6) I tried to re-initialize the database space ( oninit -i) and I got an } error: } oninit: Not enough room in ROOT DBspace. } oninit: Fatal error in shared memory initialization } 7) I thought the purpose of oninit -i was to reclaim all the lost space. } Where am I going wrong? } 8) All I want to do is start from scratch with a clean healthy database } environment. Does anyone have any suggestions? } } Thanks in advance for your help. } } Bill Bertovich } billb@connect3.com } } } } } } -- Bill Ennis Voice: 312-474-7516 SSA Fax: 312-474-7460 500 W. Madison email: ennis@ssax.com ennis@accesschicago.net