I have a confusion...what is the default memroy configuration for OE 11.3? How the memory is allocated when broker is started without specifying the parameter(default)?
Where does the default config file for parameters is stored? I mean eventhough if we don't specify parameters like no.of buffers,blocks,AI,BI buff,etc, Some default values are assigned.Where does the values are specified ?
The amount of memory allocated by the database broker on startup is dependent upon the values of various startup parameters. These include the ones you have mentioned like -B, -bibufs, -aibufs, and others as well. How these are specified depends on how you start the database. If it is a "managed" database (configured in OE Explorer/OE Management) then these values are typically configured through the web UI and they are stored in the file conmgr.properties. If it is a "scripted" database then there is typically a shell script that includes a proserve command followed by parameters and values. These parameters may include a pointer to a parameter file (.pf), e.g. "proserve mydb -pf /some/path/myparams.pf".
In either case, managed or scripted, if you do not specify a startup parameter explicitly then its default value applies. For example if you don't specify -B then its value is 3000 blocks or (8 blocks * value of -n), whichever is greater. The default startup parameter values are listed in the Reference section of the Database Administration manual.
Thanks Rob.
Yeah i understood that some default value is assigned if we don't specify a parameter.My doubt is how the DEFAULT VALUE IS BEING ASSIGNED? Does it fetches the value from any Configuration file ?