configuring a database server

《configuring a database server》由会员上传分享，免费在线阅读，更多相关内容在学术论文-天天文库。

1、Module4ConfiguringaDatabaseServerConfiguringaDatabaseServer11-20034-1©2001,2003InternationalBusinessMachinesCorporationObjectivesAttheendofthismodule,youwillbeableto:®Createcookedfilesorpreparerawdevicesforserverdiskstorage®Setenvironmentvariablesnecessarytoadmini

2、steradatabaseserver®Explainthepurposeoftheconfigurationfile®Identifybasicconfigurationparametersettingsrequiredtobringupasimpledatabaseserver®UseatexteditororIBMInformixServerAdministrator(ISA)tomodifytheconfigurationfile®Bringthedatabaseserveronline4-24-2Configur

3、ingaDatabaseServerInstallingtheServerInstallationrequiresthatyouperformthefollowingtasks:®Preparespacefordatastorage(allocatechunks).®Settheappropriateenvironmentvariables.®Setupthesqlhostsfile.®Configurethesystemusingtheconfigurationfileinthe$INFORMIXDIR/etcdirec

4、tory.4-3Aboveisalistofthestepsrequiredtoconfigureyourdatabaseserver.Thesestepsarecoveredinthefollowingpages.ConfiguringaDatabaseServer4-3PreparingSpaceforDataStorageRawDevice/dev/rdsk/c0t1d0s4CookedFile/informix/rootchunk4-4IBMInformixDynamicServerprovidestwooptio

5、nsyoucanusefordatastorage:¢Arawdeviceisacharacter-specialdevicethatyoucreateusingaUNIXutilitythatassociatesadevicepathnamewithadevicedriver.ThisdriverisapartoftheoperatingsystemthattranslatesI/Orequestsintoinstructionsforthediskhardware;itisindependentoftheUNIXfil

6、esystem¢Acookedfileisaregularfilethatismanagedbytheoperatingsystem.Whilethedatabaseservercontrolsthecontentsofthefile,itmustmakeI/Orequeststotheoperatingsystem.ThoughWindowsdoessupportrawdevices(unformattedpartition),IBMdoesWindowsnotrecommendthatthisapproachbeuse

7、dforthisplatform.4-4ConfiguringaDatabaseServerPreparingaRawDevice1.2.chmod660device_name3.chgrpinformixdevice_name4.chowninformixdevice_name4-5Tocreatearawdevice,youshouldrefertoyoursystemadministrationmanualsforyourUNIXsystem.Ifyouar

8、egoingtorepartitionanexistingdisk,itisagoodideatoarchivethedataonthediskbeforeyouunmountthedeviceandrepartitionit.Makenoteofthesizeofeachrawdeviceinkilo