If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > Informix > oninit -i fails to create sysmaster

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 07-13-04, 09:31
amit_s_dixit amit_s_dixit is offline
Registered User
 
Join Date: Jul 2004
Posts: 4
oninit -i fails to create sysmaster

Hi,
I have Installed Informix 9.40 on my HP-UX Server.
When I initialized Informix Using
$oninit -i
It fails to create sysmaster, with error "Not Enough Free Disk Space"

Though I am having more than 3 GB space free.

Please Help Stuck with this problem..

Thanks,
Amit
Reply With Quote
  #2 (permalink)  
Old 07-13-04, 10:41
mjldba mjldba is offline
Registered User
 
Join Date: Dec 2003
Location: North America
Posts: 139
Hi,

I'm pretty sure the sysmaster database is created in rootdbs & your rootdbs
may not be big enough.

Please check your $INFORMIXDIR/etc/onconfig file, what is the size of
ROOTSIZE?

I have no problems with ROOTSIZE = 120000, which is 30000 pages on an AIX box with 4k pages, and less that 2000 pages are in use.
Reply With Quote
  #3 (permalink)  
Old 07-14-04, 00:58
amit_s_dixit amit_s_dixit is offline
Registered User
 
Join Date: Jul 2004
Posts: 4
Unhappy Strange But Worked

HI,
It worked that way when I increased the size of rootdb to 120000, it worked.

But I am still unable to understand why the same size of 30000 works on
other machine and not on this one.

Thanks,
Amit
Reply With Quote
  #4 (permalink)  
Old 07-14-04, 10:59
matute matute is offline
Registered User
 
Join Date: Jun 2004
Location: Madrid, Spain
Posts: 47
Hi,

It depends on several other parmeters, like size and number of the logical logs, size of the physical log and size of the online pages.

It will be easier to see the problem if you send these parameters:

PHYSIZE
LOGSIZE
LOGNUMBER

and the last line of the output from onstat -b

Hope it helps,
Jose Luis
__________________
José Luis Matute.

Regards from Spain.
Reply With Quote
  #5 (permalink)  
Old 07-14-04, 11:46
ServerMetrics ServerMetrics is offline
Registered User
 
Join Date: May 2004
Posts: 45
You could also try building sysmaster once the server is up, notice your server came up without sysmaster around. Since sysmaster is a read-only view into existing memory your can re-create it no bad effects. Informix executes the $INFORMIXDIR/etc/sysmaster.sql script so run it through any sql execution tool.
__________________
Keith Brownlow
ServerMetrics DB Monitoring (www.servermetrics.com)
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On