RE: Database initialisation

From: Srinivas Sreekumar <SRINIVAS_SK@inf.com> > >My logical logs are 64000K of 12 nos. And physical log of 8192K. 12*64000 + 8192 + other bits in rootdbs ~= 776830K at a guess. >-----Original Message----- >From: Obnoxio The Clown [mailto:obnoxio@hotmail.com] >Sent: Wednesday, August 09, 2000 3:34 PM >To: Srinivas Sreekumar; informix-list@iiug.org >Subject: Re: Database initialisation > > >From: Srinivas Sreekumar <SRINIVAS_SK@inf.com> > > > >I am trying to initialise a database (multiple residency) when I give > >oninit> >-i the following error occurs. > >oninit: Not enough room in ROOT DBspace. > > Requested 776830K, ONCONFIG value 'ROOTSIZE' 200000K. > >oninit: Fatal error in shared memory initialization > > > >In my onconfig file I have specified 200M as the ROOTSIZE. where does it > >picks the 776830K from. > >The IDS version is 7.30.UC10X5 on HP UX 11.00 > >How big are your logical and physical logs? >________________________________________________________________________ >Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com

Obnoxio The Clown wrote in message <8mreh8$pve$1@news.xmission.com>... > >From: Srinivas Sreekumar <SRINIVAS_SK@inf.com> >> >>My logical logs are 64000K of 12 nos. And physical log of 8192K. > >12*64000 + 8192 + other bits in rootdbs ~= 776830K at a guess. > This 776192K + other bits (638K) = 776830. Don't forget to add room for the sysmaster+sysutils databases. (100Mb). This gives 879230K or 859Mb. BUT If you have this much physical and logical log space they should be in their own dbspaces. ---- Start online --- 1. Do the oninit -i with 3 10Mb logical logs and a 5Mb physical log. also make sure TAPEDEV is set to /dev/null. ---- Create new dbspaces --- 2. Create the new dbspaces with the onspaces -c option. ---- Add new logical logs --- 3. Edit onconfig to change the LOGSIZE parameter to the size you want each logical log to be. 4. Restart online. 5. onmode -sy to move online to Quiescent mode. 6. onparams to add the logical logs in the new dbspace. 7. ontape -s -L 0 to do a fake level 0 archive to /dev/null and enable the newly added logical logs. ---- Delete old logical logs --- 8. onmode -lc several times to move the current logical log into the newly created ones. (onstat -l to check). 9. onparams -d to delete the old logical logs. 10. ontape -s -L 0 to do a fake level 0 archive to /dev/null. ---- Move physical log --- 11. onmode -yuk to shutdown online 12. Edit ONCONFIG and change PHYFILE and PHYSIZE to the newly created dbspace for the physical log. 13. oninit to restart online. 14. ontape -s -L 0 ---- Set TAPEDEV to correct value for backups (if you are not using onbar, otherwize leave at /dev/null) --- 15. onmode -yuk to shutdown online 16. Edit onconfig to point to the correct TAPEDEV. 17. oninit to restart online. >>-----Original Message----- >>From: Obnoxio The Clown [mailto:obnoxio@hotmail.com] >>Sent: Wednesday, August 09, 2000 3:34 PM >>To: Srinivas Sreekumar; informix-list@iiug.org >>Subject: Re: Database initialisation >> >> >>From: Srinivas Sreekumar <SRINIVAS_SK@inf.com> >> > >> >I am trying to initialise a database (multiple residency) when I give >> >oninit>> >-i the following error occurs. >> >oninit: Not enough room in ROOT DBspace. >> > Requested 776830K, ONCONFIG value 'ROOTSIZE' 200000K. >> >oninit: Fatal error in shared memory initialization >> > >> >In my onconfig file I have specified 200M as the ROOTSIZE. where does it >> >picks the 776830K from. >> >The IDS version is 7.30.UC10X5 on HP UX 11.00 >> >>How big are your logical and physical logs? >>________________________________________________________________________ >>Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com > >________________________________________________________________________ >Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com >