linux6下informix11.7安装配置说明材料

1、本文仅适用于数据库挂载本地盘的情况。本文中逻辑日志设置为19个，逻辑日志，物理日志以及tempdbs 的大小设置为 2G , rootdbs 设置为5.1G，其他地区可根据局方划分 虚拟空间的大小灵活调整。建立informix账户-s /bin/bash In formixuseradd-u 500 500 /home/I nformix确认shell类型如果shell类型不是bash则修正informix 账户shell类型chsh-s /bin/bash in formixroatesadnpi 宀# chsh -t /b1n/bash Informix chanalrg shell fo

2、r inTornlx, 3helT cnnjedR r oatf&sacdnpd.# more/ootsadipl -： _ a= 5D：FTF user:;/sb1n(/nol ogin nobody:x;99 ：Nobody :/i/5bnr/ncl gindbus :x：8J; 31： system iresae bus :/：/sbn/nol(jgJn vcsaiibifety-rTual cordleowner:/ciev;/slrlnynolog1 nr 卩 c：itT32112 !HpchJ nd ia wi an t A a r /c a che/r p cb1 rdz/sti

3、lr/nol onr brr ;x;i5：i73: ;/euc/ahrT :/Shln/noljQJ n rpcusETservice user ;/zar/l ib/nfa i/sbin/nolonint;： sut!i-il u?er dtjun lu tit uied by oprof-ile；/hDme/oprofile：/stin/riologirirf 5 nnbociy: 165534 ! S5524 : Anarrj,iiiou5 NFS Us Er :/vir/lib/nfs : /stin/nolcicjin lid I dicmori: x:69:68: hal diMn

4、ori：/ :/sa1ri/nol og1r ntp：K：38: SB:/etc/ntp :/sbirVroicgin saslai-itli： r：4QQ ：7&: sjsliULhcl usar:r/Rrjpty/isliUTh：bin/nologin posrf 1 x :x：B5:89: /var/5 p do! /pc st fl x :/s b 1 tvtio ogln 53liJ:;74 : 74:Pr 1 v 11 tue-3epaiat td 55M:Ad1 /rpty/sil id i/sbln/nul ugh i tcpdjr|3 :x; 72:72 ; :/:/5b n

5、/nolcgin upr nF r lc?_.inTarmix: k: 5OCI: 5 00 :/hona/inf orni *15ST：K：503： 500： : /h Ume/S 5 7: /t)1 n/l)4 S f iroDCdhdiinplr otJtQsqLtdiipl 1/oot*a:$nio * bash_prof 11 e 稍.bash-proflle# Ger rhe aliases and functions if -f 、bashre ; thenfi bashre# UFr specific envirDriment -nd stirrup programsedito

6、r=v1export EDITORinfo rmi xdir -/horn a/i nforrtiv/ex c/sql h 口龙工 T E rmc af -/h uni e/n nforrni x/excArnicap；sac diripl 1 nfornri x./honiG/i nfornri xS sacdripL 1 n forml x_/home/1 nforrnl xj MMM E I解压informix_11.7 安装包? a CiSupl i nrfo rml x_/h rnie/1 nfnr mlxSi 耳弟 cdrnpl i rifUEi xJH cme/l nfor mi

7、 15r-.=- 川匸-r-r-r-P 1 卄初Tgf7. 2 H厂列#wx-x2 drxrvr-x, 6 石初Tgf7. 5 H厂押忙一岂-試3 -r-r r-h 1 -rj-rw-r-P 1infixniiiK roert root root1 nm-iri l Mnrorml1170.IngCSDK/UrtIi/i_ s dk/un lx/doe/匚 DK/bn I y/dac /tsc(iJ：_mch1 n_nat as 二,7C.txt CSDkUiI/dcic/Dl ed a_r el二 ss . ZC -htirnotesl s DK/bN l/doc/otftie_r c 1

8、not 5s_3*7D.txc c3x?K/unLx/dg/tl5_relinoc勢 3h70,txi LsrK/unix/doc QLtjt- jn jchj ri5_noces_3.7d. :kt l sck /uniivctoc/fisql L_rsl nacasj* TC.hcul c 5 x?k/um ixjuc Xcpp_r e 1 not e z 亠 F J * n l5rfi/unry/doc/cpfn_r 匕 1 notes_3.7i). Fenl -SLK. ru ll./duc/urismulriJLuS_3*7D. htlll c s UK/uni/duc/es qic

9、_r c j口匸es_3l ，L.*，rua *. Ll - -L.LJlr l i-a T=. l Ci L-. w T解压后文件1-3 匚 dmpl勺 nfa total 79SL4S drxr -xr-x drxr-scr-x-r-a 厂打- r r -rrKr-xr-x dr #xr-xr-x. drwxr-xr-Xi dritfxr-xr-Xp 二r胃寸 三i二二. drxrwxr-xB drxrxr-Xa drxrxx-x. drxrxr xa drrxr -xr-K.-rf-rw-r-rm11./fKJins/inferni ： (1 a, lrt1 nroritil x1 nF

10、o广刖x1 nfgrirr1 x i nFornri * IrtfiDrirrix Inforniji nforirri x1 rTforrtri x I nfnrlTii i root rooT rofft1 nformfl x i nFornri x i nforriTi x1 nforrril xInf i； rm ix i -trnv. 1nfi：rnn1x 1 rf crrni x irrForrnix lnfarrmlx 1 Hfgrmix 厂于匚怖诋 1 nfarriiii i rest rooc root Irfcrmilx i r r II i irrfermix 1 rr

11、ji i ?.409.4091504 & 1CH41 367861935409640Qf.4Q96 916736040U6409e409640 口低 96759 S5723Ct5letM-Mlf_s- ? Ns a再 3-2 f 5 5 -rm CH n 11 n 112 _2 z 211 丄 T iI 丄 Tl.4.u 路01路附 :alkaqeIrifubimik_ijTl inuteLJ-l- 7D PC4_LTm_ji:&6_04- license sdk_H censejdbcunliFiciLaililpart pridl 1 _intDrmixlL7D_jLB lag dl_1

12、nTDriil xlL7C lundr-切换账户至root进行安装sA-dmpl i iFormlA-/liLUne/iifortiilxSiLi 亠PiEfWrd：rGffT(7s crtnpi 7* pwri/r uoti*ooT(9saztiTipl - * ec /home/-1 nf arml xroo-ccitipL 1nforni-ly# 1?bundl prapertles extendIconnectinfunnixjult imiie_J-L+ 70 nCSDKI BH_Dat a_5orveidsinstill jcfocrootsacchipL Informix# Is

13、 -1 ntutdl 为證43drw:r 茁minfer rr ixinf orni k你&oct132 011CSPKrirwxr-Jf r“弓Infnrrrlyinfnrnl4O=)fiOct132Q11TCOMMFi 1-rrr.ii nfFqrnf i xinfornik5040oct132 IllREADME, ntml-r .1inf orrr ixinf ami k10141oct122 011bundl a. roperrleE-rwr-1nfornlx5&76OL955OCT32 03 L1 ds_1 nsral 1drvx忑n JinFornfixInformix4036o

14、ct132 011SERVERdrvK-K-览甲Ai nFarniiinforni k40?6OCT132 011JDBCdrw一 Inf orn1 k90OCT132 011I BM_D3t a_bW3Wr_DT 1vCT_arkag?二三=inf oriflixInforni x449167360gyi专 n16:24I nf or m i)c_ul tlmat e_H - 70.FC4_LIM_x3drvKrwxr-Krootr col他&旳y25It ：0Clicense耐xr-買.roctr not4O=)fi帖询yn c/lh ：Usdk lirpnspdrvKrwsr-K.roo

15、troot40&6lay16 : OLjdbcdrvxirwKr -k.IntarmlxIntoml k4036un15曲0uni nstLi 1 Idrwr-1nfornlx40915Jun15 ：WPXT AndwInFornfixInformix9575SJunIE :门ol_i rrfarmiXl7C_l. leg-rw 一w-ri nfornii xinforni k9?723jun12 :玮ol _i -iornTi xH7Q, lagrnoitsacchipL 1nfcirni1xir ./1 rls_1 nscal 1Preparing to Insrall,.,cxtrict

16、i ng t-io jrc frart rhe 讣STi)cr archive. r unpA-klnj rhe j杵Extract inc( the install st non reso ur ces Fran the lnsta! er ar chi ve,., ContigtheI &r tor this m产t&nM enuironnisnt.wrings: /l1b/1ibc.so + &: mo such fileLaunchi nzj InstaI ler, + .Preparing CONSOLE Mode insta1ation.直接ENTER回车Prepar i ng c

17、onsole Mode mstal 1 atiIBM informi _1r st al lq_ll. 70. pdf 3. Launch information centerAccess rhe LDb 11.70 informaflcm center at ntTp:/pub!ib boulder. bin con/infocenrer/idshelpAll/lriex isp you niiy camel tms instil lation at any time by typing 3uituo曰 pys efTRIIn Inst a I TO mmch want to1 at i o

18、n , prompt crangeto pro亡日已日 ro the next someThi ng cn a previousstep 1n the instal atJon. step. type 1 back*.PRESS TO 匚CNTIfJUE：选1并回车mternmtiorial Program Li cense Agreefnenrt：Pmrt 1 - Gener耳1 Term忌BY DOWNLOADIHG,工MSTA-LING, COPYING, XTCESilNG, LICKING ON AN ACCEPT*1 BUTTON, OP. OTHERWISE USING THE

19、PFtOGP.AM, LICEN5匚匚 AGREES TO THE TERMS OF THIS AGREEMEMT* IF YOU ARE ACC EPT I MG THESE TERRIS ON BEHALF OF LICENSEE s YOU REPRESENT AND ARRhTT THAT YOU HAVE FULL AUTHORITY TO BIND LICENSEE TO ThEE TERMS IF YOU DO NCT ASKEE THESE TERMSp-DO NOI DOWNLOAD, INSTALL, COPY ? ALLESS, CLICK ON AM ACCEPI BU

20、 CTOIM, OR USE THE PRXFLAM；阳D-PRWPTLY RETURN THE UNUSED MEDIA, DOCUMENTATION, AND PROOF OF ENTITLEMENT TO THE PARTY ROM WHOW IT A5 OBTAINED FOR A REFUND OF THE AMDUhJT PiTn. T 匚 THF PHOGR1M 迅电W M谢忖LQADFD, DFSTRAY A|. I COPT FS OF THF PRgRM*Press Enter :a conrlnue viewlng the license agneemnt, or ent

21、er 1 ro accept tha agreement, 2二口 decline it, 3 to prim it, or ?9 to go tack io che pre/1uu& screen. ; 1选1回车或直接按回车键insTa_laTion Gaals汕年t do you wam： TO acconpl 1 sh?Intsi 1 praduct= and featui &s2- Extract the prndurt -iles (-OLEGACY option)ENTER THE NUMBER FOR TOUR CHOICE, OR PRESS TO ACCEPT THE DE

22、FAULT：:指定安装路径，并选 Y回车确认；我们常用/home/lnformix，如果不指定informix 默认安装到 /opt/IBM/informix中in5ranAtJon Locar!onchoose location for softvae 1nsta1atiorDef iu It Instal 1 Fol dr ： / Opt/lEM/1 hfarffli XEkJTER AN ABSOLUTE PATH, OR PRESS TO ACCEPT THE DEFAULT :/Tione/lnrformlxIUSTALL folder 15： /hoffle/informix:S

23、THIS CORRECT? (Y/N): 此处选1或者按ENTER默认Typicalinsia*1eTlon typeseiect the instanation tgu.IypJCd : 1 instilII Lhe ildtabdsf? server wlTh 11 featur已s and d datdLdse 、电rer Lhdt ie configured vitk default 汗汩E. includos:r=pnT safTwsre DevFlnpnent k1t CCSOKJava Dclabcsc ccnnectwity fJrBC)Mi nimurn dis k 亡占 r

24、&qui ! ZiDD-MOOMBCuston i _ Inst al Iddtaoase sarvar with specific f eatu rmz and sofTWir e thit y 口 u r&cl.Qpiorid-iy insian a conljurej diabase server riSTanGeH rii nimurn d_$breejui -ea: ?5 mb iwithout w 1- Typical2- Cust cmEMTER THE INLNEEP POP YOUR 匚HOLCE, CR PP.EZ5 - TO ACCEPT THE OCFAULT:此处选2

25、，不要默认选项server instance creationCreate a serve instarce?-L- Yes - cecte ar instance1- No - do not crests 4n instanceENTER THE NUMBER FOR VOUR CHOICE, OR PRESS TO ACCEP1HE DEFAULT： : 2此处选1并回车确认Internetianal License AgreEnnent for Nonwarranted ProgramsFart 1 - Genera TermsFT DOWNLOADING, IN5TALLItMG, C

26、OFYING s AZCE551NG ? CLICKING OM AM ACCEPTBUTTON P OR OTHERWISE USIMG THE PROGRAM. LICENSEE AGREES TO THE TERMS OF THIS AGREMEMTa IF YOU ARI ACCEPTIMG THESE TERMS OM behalf OF LICENSEE, YOU REPRESENT AND ARRANT THAT YOU HAVE FULL AUTHORITY TO BIND LICENSEE TO THESE TER阴5. IF YOU KJ NOT AGREE TO THES

27、E TERM5.如 DC NOT DOWNLOAD ? INSTALL, COPY, ACCESS s CLICK ON AN ACCEPT41 BUTTON ? OR USE THE PRCGFAM； AND创 PROMPTLY RETURN THE UNIISFD MEDIA A KID DOCI INFriTATTON TC THF PATV FROM WHOM IT WAS OBTAINED FOR A REFUND OF THE 咖OUHT PAIDB IF THE PROGIR.OJM kAE COWMLOADED, DESTROY ALL COPIES OF THE PF.OGR

28、AMP严esE Enter to corrtinue vi ewi ng t he accept the agreement. 112 to deci to the pravious screen：15 ailt*1orto:kAb此处直接回车确认instil 1 al Ion buinmaryplaase r ovi av xne fol1 awn ng before conti nuing:productIBMMarne:Informix software BundleFcldmr :instil 1/Tio*ne/1 riformixproduct Featur弓IBM Informix

29、 database server； 色 server ?Extanslon; and toolsj j/FDundai1ori.Database extensions* 匚arrverslon and reverwicin support, 洌pub|J s hi ng ,Demonsrration database scripts, EntfirprIse Repl 1caLton, Data laadi03 ufllitieSj onunioad ana anload utilities f dhl odd iifi Uryt higi-Performarce Loader, Back u

30、p and Re；st ureT arctiacker uti 1ity, ON-Bar uii1Iry, infarmi x sxorage nianacer , informlx 1 nterrace toTlvoll storage Manager, Administrative utilities, p耳rforrnance miznitorinc urilif1 es, Mls匚Elian也口s monitoring uti1Jti&, Auditing uti11ties,Database Import nd eport ut1ities, I6M 一 -I6P1 IBM I EP

31、I 7.2 IBM IBMclientInformixInformix Gbiect interface fc)r C+ kInformix object irterface for 匚十十 demo5, Inf Qrmix一applJ cat 1 on compati t)11 lty module,IiiFormix E5QL/t derius ,:Lnfcirni1x libomi fur tirmirt apinirESQL A IBM Informix ODBC Driver,IBM Informix ODBC Driver danost Gl obal Language suppo

32、rt (Jgls), 协est European and Amerlca, East European and Slavic, Japanese,Korean, chiinasa, rhai,ten infQrmix jobcDisk Space informati on for installation Target): Requi r亡d; 5E9.190.475 bytAval 1 able: 162,M4 , 54 3&S bytesPRESS O CONTINUE:此处直接回车，系统自动安装Ready To Inst 111Insr all Anywhere is now ready

33、 ro install IBM Informix software Bundle onto your system at the foilowing location:/hcme/inf c rirri xPRESS TO INSTALL:insTal 11 ng.安装完毕installation coup:!etecangratu I ar ions! IBM Inf orml x Sortware 3und I e i nstal Iat1 on 1s cornpleie.Product Insiall st ar us:ism informlK 11* 70: suGcessrul10M

34、 informi x cli entSDK； Suuu亡尸ulIBM infomn : JDBC driver : SuccesifulFnr rnnr p inf nrnur-i r*ri jKouT ist ng Tnf nrmi x pr nduct sThe TRWl inf nrmi * 1. 70TrrformAri on enrpr 己rhtt:/publ 1b. bziul dr 一 i fam. C3rr/J nfocenter/i dshel p/vlL7/nndex, j sp*PftESS VCNTER Tl EXIT THE 1NETAL.ER：LrootSsacch

35、ipl InformixJ# Is回到informix 账户下如果是本地磁盘做数据库则在informix账户下建立chunklink目录并执行数据库空间mkdir /home/I nformix/ch un kli nk cd /home/I nformix/ch un kli nk touch rootdbs touch tempdbstouch logdbstouch phydbstouch datadbsl datadbs2 datadbs3 datadbs4 datadbs5chmod 660 *dbs*编辑onconfig 文件nconf Lx Icp oncon fig.std o

36、nconfig根据现场主机实际情况编辑onconfig 文件rootdbs 方面ROOTNAME rootdbsROOTPATH /home/i nformix/chu nkli nk/rootdbsROOTOFFSET 10000ROOTSIZE 5100000Logdbs 方面LOGFILES2LOGSIZE 200000DYNAMIC_LOGS 3LOGBUFF 64FULL_DISK_INIT 1在初始化之前设置成 1初始化完成后会自动变成 0DBSERVERNAME ivpndb2要根据现场实际情况变更LOCKS 6000000 锁的数量要根据预计的业务量进行调整共享内存方面SHMV

37、IRTSIZE 1024000SHMADD 128000备份文件名和路径备份方面TAPEDEV /home/i nformix/ph.datTAPEBLK1024编辑sqlhosts 文件IF护 servicename i5 a service name entry from the services i1 n 1 e.# options 1 n the fifth field:# b=connet1 on buffer 5 i 20# c-onnecfion redirections# g-护i护e=# m=护k=軒 r=軒 s=# csm=# Ta create an enrry for

38、a group, put a group name in the dbs er ver name field,# the word group 1 n the net type 卡 ield, a hyphen i n both the hostname and the# serviceriame flleds, and 1- In The options field护# Far additi onal information on the parameters, see the I DM inf ormi x Admi rri strator 5 Gul de.ift甘tf自tr音ift甘I

39、f自tr音M甘tf自ti音齒甘iff甘tf自tf音齒ifr ift甘tr自音3irlLQCRL!35UC WlrpcREgEVCT W Q V fhOEa/ud; 50Sfl/tcp f-09 VuHf 90&l/tcp:DD2/U.k FDF?/udrr -tPi awjka rei IBM AUROftA Pei* ：iDM RftlflDte Sy* HBM Rffnots Sy;* vsa uei2Dlsp i* vesd rierDp4 Clin趕T# t* cl ass c Data 1 / ZBl inform :厶 f .nrhi teu；j卢 infarrTlx* Tntcr

40、rii h |rem infucniiK# im Informix 梓审EbsE* wckoi鼻khiT tec-XHilni A mi 11 ec-xni I na T t wiT-zpc serve 卢 xml -I pc Servp初始化onin it-ivy初始化执行时间较长因为要将本地磁盘空间先划分出一部分作为rootdbs 这个耗时较长sacdmolin卡ormix_/hom/1nformixjanln1t -ivy illegal value G) for dynamic_logs paraineter.ing dafAult value Qj. Raading configur

41、ation fi 1 e /Tioma/informix/atc/anconf 1g. . .succeeded creating /informiktmp/nfxcHir * succeeded Checking config parameters”u匚ceededAl 1 ocating and atta:hing xo shared memory h H uccecdcd creating resident pool 95442 kbytes,-.succeeded” I structure.succeededt.o fnfos f 11 皀-.亡芒cl已clAl 1 ocat ng 2

42、000Q1& kbytes for buffer pool of 2k page sizesucceeded creat 1 ng infos file H/home/irrfrmix/etc/. infos. ivpndb2, succeeded Li nk1 nq conf f 11 e H/home/i nf ormi x/at c/. conf. 1 vpndb?11. . .succeeded inltlaTizing rhead wr 11 i ng -上一= initiaTizat ion of Encryption *. wucceecIeM initializing ASF.

43、su匚(：总mdmd initializing Dictionay 匚 a 匚hm and spl Routi na 匚 iche succeeded Eringlng up adm vp. . .succeeded creaxi ng vp cl asses.succeededForki ny ma 111_1 oop thread. . . sun_ceeded inlTlaI1z1ng dr structures.succeeded Forking 1 * socrcp 1istener threads.succeeded starting tracing.succeeded inifi

44、al zing 8 fl ushers., succeeded此时online.log日志中可见到FULL DISK INIT 变成 0d d 3 52d 8L3：1S：13;1S;L3：10： 13：L0： 12江匕 _3 ：18： 13: 一 K：LJ：_S：za2&34343434i4i nrorm yhome/ norini $cd irifdrmifu/honie/TnfTQrtiii $tdil -f online 1 口gEenrt i lams nabl&d. alariprog - /hmre/irrf arttiix/et Bactl rtg Lingua from mdu I & oLoadl Mnrl lie tfCwUi i EOOi l rtj i.aniji n】m medul p ;r：; icr 一丄一 .二二】sortx-a