How do I initialize the root dbspace?
Posted in 1997
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