銆�銆�1銆佸収(n猫i)瀛橈紙memory锛�

銆�銆�2銆佺�佺��(p谩n)锛坉isk锛�

銆�銆�3銆侀��(j矛n)绋嬶紙process锛�

銆�銆�姝ワ細鐛插彇鏁�(sh霉)鎿�(j霉)搴�(k霉)瀹夎�濈▼搴�銆� 鍦╳ww.Linuxbyte.net鐨勮粺浠朵腑蹇冧笅杓塈nformix Dynamic Server 2000 RPM鍖呫��

銆�銆�绗�浜屾�ワ細閬�(y霉n)琛屸�渓(f膩)inuxconf鈥�锛屽�炲姞涓�鍊�(g猫)Informix绲勶紱澧炲姞Informix鐢ㄦ埗(h霉)锛屽爆绲勭偤Informix锛宧ome鐩�閷勭偤Informix榛樿獚(r猫n)瀹夎�濈洰閷勨��/opt/informix鈥�锛屼娇鐢ㄥ懡浠ょ偤锛�

銆�銆�# useradd Informix -d /opt/informix

銆�銆�绗�涓夋�ワ細淇�鏀箁oot鐢ㄦ埗(h霉)鍜孖nformix鐢ㄦ埗(h霉)鐨�銆俠ash_profile锛屽姞涓婁互涓嬪咕琛岃ō(sh猫)缃�鐠�(hu谩n)澧冭畩閲忥細

銆�銆�INFORMIXDIR=/opt/informix銆�銆�myserver=server銆�銆�ONCONFIG=onconfig.server銆�銆�export INFORMIXDIR myserver ONCONFIG銆�銆�PATH=$PATH: $INFORMIXDIR/bin銆�銆�export PATH

銆�銆�瑾�(y菙)鍙ヨВ閲�?zhu膩n)楠哥檺NFORMIXDIR鈥濈偤Informix鐨勫畨瑁濈洰閷�锛涒�渕yserver鈥濈偤鏁�(sh霉)鎿�(j霉)搴�(k霉)鏈嶅嫏(w霉)鍣ㄥ悕锛屽彲浠绘剰瑷�(sh猫)瀹�锛涒�渙nconfig.server鈥濈偤鍗冲皣閰嶇疆鐨勬枃浠跺悕銆�

銆�銆�绗�鍥涙�ワ細鍦�/etc/services鏂囦欢涓�鍠�鐛�(d煤)澧炲姞涓�琛岃獮(y菙)鍙�

銆�銆�sqlexec1 65530/tcp

銆�銆�瑾�(y菙)鍙ヨВ閲�?zhu膩n)?5530鐐烘暩(sh霉)鎿�(j霉)搴�(k霉)鎵�浣跨敤鐨勭��鍙ｈ櫉(h脿o)銆傜暥(d膩ng)鐒舵�ょ��鍙ｈ��(h脿o)鍙�鍦�1000鍒�65535涔嬮枔浠婚伕涓�鍊�(g猫)锛屽彧瑕佷笉鑸囧叾浠栫郴绲�(t菕ng)鏈嶅嫏(w霉)鐧�(f膩)鐢熸矕绐佸氨鎴�銆�

銆�銆�鎻愮ず锛氳几鍏ュ畬閫欎竴琛岃獮(y菙)鍙ュ悗涓�瀹氳�樺緱鍥炶��(ch膿)鍚庡啀瀛樼洡(p谩n)銆�

銆�銆�绗�浜旀�ワ細鐢╮oot閲嶆柊鐧婚寗锛岄亱(y霉n)琛宺pm鍛戒护瀹夎�滻nformix锛�

銆�銆�rpm -i --relocate /opt/informix

銆�銆�鏍规摎(j霉)鎻愮ず杓稿叆娉ㄥ唺(c猫)铏�(h脿o)纰煎悗锛屽畨瑁濈▼搴忔渻(hu矛)鑷�鍕�(d貌ng)瀹夎��锛屽嚭鐝�(xi脿n)瀹夎�濇垚鍔熺殑鎻愮ず鍚�锛屽嵆琛ㄧずInformix Dynamic Server瀹夎�濇垚鍔熴�傚彧闇�鍦ㄧ稉(j墨ng)閬�(gu貌)绨�(ji菐n)鍠�鐨勯厤缃�锛屽嵆鍙�浣跨敤Informix鏁�(sh霉)鎿�(j霉)搴�(k霉)銆�

銆�銆�绗�鍏�姝ワ細浠�Informix鐢ㄦ埗(h霉)鐧婚寗锛岀敤浠ヤ笅鍛戒护鐢熸垚涓�鍊�(g猫)绌烘枃浠�锛屽苟鎶婄敤鎴�(h霉)鍜屽爆绲勬敼鐐篒nformix锛�

銆�銆�>datadbs銆�銆�chown informix datadbs銆�銆�chgrp informix datadbs

銆�銆�瑾�(y菙)鍙ヨВ閲�?zhu膩n)楠哥櫜atadbs鈥濇枃浠剁敤浜庡瓨鏀炬暩(sh霉)鎿�(j霉)搴�(k霉)鐨勬暩(sh霉)鎿�(j霉)銆�

銆�銆�绗�涓冩�ワ細浠�informix鐢ㄦ埗(h霉)鐨勮韩浠介��(j矛n)鍏�/opt/informix/etc鐩�閷�锛屽皣鈥渙nconfig.std鈥濆京(f霉)鍒剁偤涓�鏂版枃浠垛�渙nconfig.server鈥濓紙鑸嘜NCONFIG璁婇噺鐩稿悓锛�锛屽啀鍦ㄢ�渧i鈥濋噷鎵惧埌骞朵慨鏀逛互涓嬩富瑕佺殑鍦版柟锛�

銆�銆�ROOTNAME /opt/informix/datadba銆�# datadbs鏂囦欢鐨勪綅缃�銆�銆�ROOTSIZE 30000銆�銆�銆�銆�銆�銆�銆�銆�銆�銆�#鏁�(sh霉)鎿�(j霉)搴�(k霉)闋�(y霉)鐣欑┖闁擄紝浠�KB鐐哄柈浣�锛屽彲鏍规摎(j霉)闇�瑕佷慨鏀广��銆�PHYSFILE 2000銆�銆�銆�銆�銆�銆�銆�銆�銆�銆�銆�#鐗╃悊鏃ュ織澶у皬銆�銆�LOGSIZE 1500銆�銆�銆�銆�銆�銆�銆�銆�銆�銆�銆� #閭忚集鏃ュ織澶у皬銆�銆�SERVERNUM 0銆�銆�SERVERNAME server1銆�銆�銆�銆�銆�銆�銆�銆�#鏈嶅嫏(w霉)鍣ㄥ悕

銆�銆�绗�鍏�姝ワ細灏団�渟qlhosts.std鈥濆京(f霉)鍒舵垚鈥渟qlhosts鈥濓紝鍚屾ǎ鍦╲i閲屽�炲姞涓�琛岋細

銆�銆�server1 onipcshm localhost sqlexec1

銆�銆�瑾�(y菙)鍙ヨВ閲�?zhu膩n)绨奺rver1銆乻qlexec1瑕佽垏鍓嶉潰鐩告噳(y墨ng)鍚嶇ū(ch膿ng)灏�(du矛)鎳�(y墨ng)锛宭ocalhosts瑕佽垏/etc/hosts鏂囦欢鐨勫収(n猫i)瀹瑰皪(du矛)鎳�(y墨ng)銆�

銆�銆�绗�涔濇�ワ細鍐嶄互root鐧婚寗锛屼慨鏀�/dev/console鏂囦欢灞�鎬�銆�

銆�銆�chown informix /etc/console銆�銆�chgrp informix /etc/console

銆�銆�绗�鍗佹�ワ細鎺ヨ憲浣跨敤浠ヤ笅鍛戒护琛屽垵濮嬪寲鏁�(sh霉)鎿�(j霉)搴�(k霉)绌洪枔锛屽畬鎴愬畨瑁�銆�

銆�銆�oninit 鈥搃y銆�銆�闅ㄥ悗鏌ョ湅/opt/informix/datadbs鏂囦欢锛屾渻(hu矛)鐧�(f膩)鐝�(xi脿n)鍏剁敱0璁婃垚浜�30MB锛岀劧鍚庨亱(y霉n)琛屽�備笅鍛戒护锛�

銆�銆�onstat 鈥�

銆�銆�濡傛灉鍑虹従(xi脿n)锛氣�淚nformix Dynamic Server 2000 Version 9.21.UC2 -- On-line --Up 16:30:21 --18888 Kbytes鈥濈殑鎻愮ず淇℃伅锛屾伃鍠滀綘锛孖nformix鏁�(sh霉)鎿�(j霉)搴�(k霉)宸茬稉(j墨ng)鍟熷嫊(d貌ng)鎴愬姛锛�

銆�銆�鍦ㄦ暩(sh霉)鎿�(j霉)搴�(k霉)鎳�(y墨ng)鐢ㄤ腑锛屾墍瀛樺劜(ch菙)鐨勬暩(sh霉)鎿�(j霉)濡傛灉涓熷け鎴栭伃鍒扮牬澹�锛屾渻(hu矛)鐢�(ch菐n)鐢熶笉鍙�闋�(y霉)娓�(c猫)鐨勭祼(ji茅)鏋滐紝閫犳垚鐒�(w煤)娉曞綄瑁�(b菙)鐨勬悕澶�銆傛墍浠ユ噳(y墨ng)瑭插皪(du矛)鏁�(sh霉)鎿�(j霉)搴�(k霉)瀛樺劜(ch菙)鐨勬暩(sh霉)鎿�(j霉)瀹氭湡鍌欎唤锛屾笡灏戠敱浜庝笩澶辨暩(sh霉)鎿�(j霉)閫犳垚鐨勬悕澶�銆侷nformix鏁�(sh霉)鎿�(j霉)搴�(k霉)鎻愪緵澶氱ó鍌欎唤鎵嬫�碉紝甯哥敤鏈変簩绋�鏂规硶锛�

銆�銆�涓�銆侀�氶亷(gu貌)dbexport灏囨煇涓�鏁�(sh霉)鎿�(j霉)搴�(k霉)鍏�(n猫i)瀹瑰倷浠芥垚ASCII鏂囦欢锛宒bimport鑳藉皣鍌欎唤鍏�(n猫i)瀹规仮寰�(f霉)銆�

銆�銆�浜�銆侀�氶亷(gu貌)ontape 杞�(zhu菐n)鍎�(ch菙)鏁�(sh霉)鎿�(j霉)搴�(k霉)锛坥ntape -s锛夊拰杞�(zhu菐n)鍎�(ch菙)浜嬪嫏(w霉)锛坥ntape 鈥揳 鎴� ontape -c锛変締(l谩i)瀹屾垚?锛涜��?f霉)鏁�(sh霉)鎿�(j霉)搴�(k霉)鍓囦娇鐢╫ntape 鈥搑 渚�(l谩i)閫�(j矛n)琛�銆�

銆�銆�INFORMIX鏁�(sh霉)鎿�(j霉)搴�(k霉)浣跨敤涓�娈垫檪(sh铆)闁�锛屼竴鑸�浜屽��(g猫)鏄熸湡宸﹀彸锛岄渶灏�(du矛)鏁�(sh霉)鎿�(j霉)搴�(k霉)鍋歶pdate stattistics high 銆傚�傛灉鏁�(sh霉)鎿�(j霉)璁婂寲杓冨ぇ锛屽彲绺�鐭�鑷充竴鏄熸湡鍋氫竴娆�銆傞�欐ǎ鍙�浠�?x煤n)?y艒u)鍖栨煡瑭�(x煤n)銆�

銆�銆�Dbaccess

銆�銆�閬告搰Query-language,

銆�銆�閬告搰srcc鏁�(sh霉)鎿�(j霉)搴�(k霉)锛�

銆�銆�杓稿叆 update statistics high 銆�

銆�銆�灏�(du矛)浜�1G澶у皬鏁�(sh霉)鎿�(j霉)搴�(k霉)澶х磩闇�鍋�2灏忔檪(sh铆)宸﹀彸銆�

鏇村�氱簿褰╁��(n猫i)瀹�锛岃珛(q菒ng)鐧诲叆缍�搴�(k霉)闆诲瓙閫氾紙www.3575.com.cn锛�