Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
Database Servers
DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybase
Desktop Databases
FileMakerFoxProMS AccessParadox
General
General DB TopicsDatabase Theory
Related Topics
Java Development.NET DevelopmentVB DevelopmentMore Topics ...

Database Forum / Informix Topics / April 2005

Tip: Looking for answers? Try searching our database.

New installation

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Brian McLaughlin - 27 Apr 2005 22:55 GMT
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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.