I'm installing IDS 9.4 on a new machine (Solaris 9).
The install went fine.
I set up a 512MB raw chunk for the rootdbs.
I set the ROOTSIZE to 60000
When I do an oninit -i, I get the following:
bash-2.05$ oninit -i
This action will initialize IBM Informix Dynamic Server;
any existing IBM Informix Dynamic Server databases will NOT be
accessible -
Do you wish to continue (y/n)? y
oninit: Not enough room in ROOT DBspace.
Requested 161038K, ONCONFIG value 'ROOTSIZE' 60000K.
The relevant onconfig parms look like this:
# Root Dbspace Configuration
ROOTNAME rootdbs # Root dbspace name
ROOTPATH /dbms/links/rootchnk # Path for device containing root
dbspace
ROOTOFFSET 0 # Offset of root dbspace into device
(Kbytes)
ROOTSIZE 60000 # Size of root dbspace (Kbytes)
And the link to the rootdbs chunk looks like this:
bash-2.05$ pwd
/dbms/links
bash-2.05$ ls -la root*
lrwxrwxrwx 1 informix informix 18 Apr 27 13:14 rootchnk ->
/dev/rdsk/c1t4d2s0
bash-2.05$
That space is on a Raid controller -- c1t4d2s0 is partitioned as
cylinders 0-255 for 512.00MB
So I'm not understanding why it's not having enough space for rootdbs,
and I'm hoping it's something really simple that someone can clue me in!
Thanks,
Brian McLaughlin
Administrative Computing
George Fox University
(503) 554-2587
sending to informix-list
Murray Wood \(IList\) - 27 Apr 2005 23:03 GMT
Brian
You have told Informxi to create a dbspace on 60Mb. Yet the initial
contents of rootdbs in your ONCONFIG add up to 161Mb. It will not fit.
Think you may want to set ROOTSIZE to 512000
MW
> -----Original Message-----
> From: owner-informix-list@iiug.org
[quoted text clipped - 52 lines]
>
> sending to informix-list
sending to informix-list
Jean Sagi - 28 Apr 2005 18:10 GMT
Yes.
In fact, one can automate the process with onparams, which automatically (it or by side effect) change your onconfig file appropiatly.
J.
-----Original Message-----
From: Mike Dunham-Wilkie <mike@barrodale.com>
To: "Murray Wood \(IList\)" <ifxmaillist@quanta.co.nz>, <informix-list@iiug.org>
Date: Thu, 28 Apr 2005 08:38:46 -0700
Subject: RE: New installation
Remember that PHYSFILE, LOGFILES and LOGSIZE all contribute to the size of
the ROOT db when you initialize the instance. I keep these small during
initialization and then move the physical and logical logs to their own
dbspaces (and enlarge them appropriately) after initialization.
Mike
At 03:03 PM 4/27/2005, Murray Wood \(IList\) wrote:
>Brian
>
[quoted text clipped - 62 lines]
>
>sending to informix-list
----------------------------------------------
Michael Dunham-Wilkie, M.Sc., M.P.A.
Senior Database Analyst
Barrodale Computing Services Ltd.
Tel: (250) 472-4372 Fax: (250) 472-4373
Web: <http://www.barrodale.com>http://www.barrodale.com
Email: mike@barrodale.com
----------------------------------------------
Mailing Address:
P.O. Box 3075 STN CSC
Victoria BC Canada V8W 3W2
Shipping Address:
Hut R, McKenzie Avenue
University of Victoria
Victoria BC Canada V8W 3W2
----------------------------------------------
Jean Sagi
jeansagi@myrealbox.com
jeansagi@yahoo.com
sending to informix-list
Brian McLaughlin - 28 Apr 2005 20:19 GMT
Many thanks to the folks that replied to my initial question. I guess I
was focusing on why there wasn't enough space on the partition (when
there was) rather than why I hadn't configured rootdbs large enough to
hold what I'd asked it to hold. I've never set up an instance from
scratch, so this is a good experience for me. (fortunately, I have a
dedicated server here to experiment/practice on before we have to move
our production DB).
Another little tidbit I learned was to have Informix offset into the
chunk that occupies cylinder 0 on the device. I put rootdbs right over
the partition map. IDS came up and ran just fine -- until I tried to
add another dbspace, at which point pretty much *everything* stopped
working. That was a good one.
I surely appreciate the quick accurate answers from you folks that have
been there before.
Thanks,
Brian McLaughlin
Administrative Computing
George Fox University
(503) 554-2587
sending to informix-list