Re: RE: New installation
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
>
>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
> > [mailto:owner-informix-list@iiug.org] On Behalf Of Brian McLaughlin
> > Sent: Thursday, 28 April 2005 9:55 a.m.
> > To: informix-list@iiug.org
> > Subject: New installation
> >
> > 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
> >
> >
>
>
>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