Re: How do I initialize the root dbspace?

In article <5ras3u$2io@cssun.mathcs.emory.edu>, Bill Ennis <ennis@ssax.com> writes >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 Correct. >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 No, only the first chunk exists after a reinit. >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. > Correct. It is normal best to have 1 dbspace = 1 chunk = 1 physical disk. This means you have a simple configuration and can force which physical disks are used:- create table (...) in dbspace xx and use fragmenting across dbspaces to ensure table/indicies get spread across physical disks. >-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 -- David Williams