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 > Size of rootdbs and physdbs should always same

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 02-17-03, 00:16
ChanduP ChanduP is offline
Registered User
 
Join Date: Feb 2003
Location: HYD-INDIA
Posts: 3
Size of rootdbs and physdbs should always same

Hi..

After creating the new instance, when i try to initilised the shared memory i got the below message

For disk space initialization, the value specified in the ONCONFIG file for
PHYSDBS (physlog) should be equal to that of ROOTDBS (rootdbs).
oninit: Fatal error in shared memory initialization



do we need to keep always both the values are of equal size.

ChanduP
Reply With Quote
  #2 (permalink)  
Old 02-17-03, 08:05
Roelwe Roelwe is offline
Registered User
 
Join Date: Aug 2002
Location: Belgium
Posts: 534
Absolutely not!

The physical log is at initialization time a part of the rootdbs.
So the size should be at least smaller than the rootdbs. After initialization, you should change the location of your physical log from the rootdbs to another dbspace, like the physdbs.
Set the correct parameters in the onconfig too.
__________________
rws
Reply With Quote
  #3 (permalink)  
Old 02-19-03, 21:24
manny_er manny_er is offline
Registered User
 
Join Date: Feb 2003
Posts: 24
Smile Re: Size of rootdbs and physdbs should always same

The ROOTDBS should greater than the physical log by atleast 30MB (to be safe) if your physical log is to be placed in the ROOTDBS. If you try to place the physical log to a separate space such as PHYSICALDBS, the total physical log size should be the size of your PHYSICALDBS. For best practices it should be separated, separted by disk is much better.

I hope I have answered your question well.
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