发表于 2009-1-5 19:48
| 
DB2 UDB for Linux銆乁NIX 鍜 Windows V8
鍙戝竷: 2008-7-01 13:54 | 浣滆: admin | 鏌ョ湅: 14娆
DB2 UDB for Linux銆乁NIX 鍜 Windows V8
鐑 鑽
銆愬瓧浣擄細灏 澶с
DB2 UDB for Linux銆乁NIX 鍜 Windows V8
浣滆咃細锛 鏂囩珷鏉ユ簮锛氾紞 鐐瑰嚮鏁帮細2420 鏇存柊鏃堕棿锛2006-4-22 
Suita Gupta, IBM Malaysia
Allan Tham, IBM Malaysia
Raul Chong, IBM Toronto
2004 骞 2 鏈 濡傛灉鎮ㄦ槸涓浣嶆湁鍏磋叮鍩瑰吇 DB2 Universal Database 鎶鑳界殑鏁版嵁搴撲笓瀹讹紝閭ｄ箞鎮ㄥ緢鍙兘鍏峰浜嗗叾浠栧叧绯绘暟鎹簱浜у搧鐨勬暟鎹簱鎶鑳姐傛湰鏂囧睍绀轰簡濡備綍鍒╃敤鎮ㄧ幇鏈夌殑 Oracle 9i 鐨勭煡璇嗗揩閫熻幏寰 DB2 UDB for Linux銆乁NIX 鍜 Windows Version 8 鏂归潰鐨勬妧鑳姐
绠浠
濡傛灉鎮ㄦ槸涓浣嶆湁鍏磋叮鍩瑰吇 DB2 Universal Database TM鎶鑳界殑鏁版嵁搴撲笓瀹讹紝閭ｄ箞鎮ㄥ緢鍙兘宸茬粡鍏峰浜嗗叾浠栧叧绯绘暟鎹簱浜у搧鐨勬暟鎹簱鎶鑳姐傚湪 developerWorks 閲岀殑涓婁竴绡囨枃绔犱腑锛屾垜璋堝埌浜嗗浣曞埄鐢ㄦ偍鐨 MS SQL Server 2000 鎶鑳芥潵瀛︿範 DB2 UDB for Linux銆乁NIX 鍜 Windows銆傛偍鐔熸倝鐨勬槸 Oracle 鑰岄潪 SQL Server 鍚楋紵濡傛灉鏄殑锛屽氨璇烽槄璇讳笅鍘汇傝繖涓绡囨枃绔犱腑锛屾垜灏嗗睍绀哄浣曞埄鐢ㄦ偍鐜版湁鐨 Oracle 9i 鐨勭煡璇嗗揩閫熻幏寰 DB2 UDB for Linux銆乁NIX 鍜 Windows Version 8 鏂归潰鐨勬妧鑳姐
鏈枃涓紝鏈“Oracle”鎸囩殑鏄 Oracle 9i Release 2锛“DB2 UDB”鎸囩殑鏄 DB2 UDB for Linux銆乁NIX 鍜 Windows Version 8銆
绯荤粺缁撴瀯姒傝堪
棣栧厛锛屾垜浠渶瑕佺悊瑙 Oracle 鎵浣跨敤鐨勪綋绯荤粨鏋勪互鍙婂浣曞皢涔嬩笌 DB2 UDB 鐩告瘮杈冦 鍥 1灞曠ず浜 Oracle 鐨勭郴缁熺粨鏋勩 鍥 2灞曠ず浜 DB2 UDB 鐨勭郴缁熺粨鏋勶紝璇峰皢涓よ呭仛涓涓嬫瘮杈冦傝鍙傜収杩欎簺鍥炬潵闃呰鏈枃浠ヤ究鐞嗚В銆
鍥 1. Linux銆乁NIX 鍜 Windows Version 9.2 涓婄殑 Oracle 绯荤粺缁撴瀯
鍥 2. Linux銆乁NIX 鍜 Windows Version 8 涓婄殑 DB2 UDB 绯荤粺缁撴瀯
瀹炰緥
瀹炰緥锛坕nstance锛夌殑姒傚康鍦 Oracle 鍜 DB2 UDB 涓槸鐩镐技鐨勩傚湪杩欎袱绉嶆儏鍐典笅锛屽疄渚嬮兘鏄寚鍚庡彴杩涚▼涓庡叡浜瓨鍌ㄥ櫒鐨勭粍鍚堛備袱鑰呬箣闂存渶澶х殑宸埆灏辨槸锛孫racle 涓瘡涓疄渚嬪彧鍖呭惈涓涓暟鎹簱锛岃 DB2 UDB 涓涓暟鎹簱鍙互鍏变韩涓涓疄渚嬨
鍥犱负鏁版嵁搴撳拰瀹炰緥涔嬮棿瀛樺湪涓瀵逛竴鐨勫搴斿叧绯伙紝鎵浠ュ湪 Oracle 涓閫氳繃鐢 CREATE DATABASE 鍛戒护鍒涘缓鏁版嵁搴撴潵鏄惧紡鍦板垱寤哄疄渚嬨傚彟澶栵紝鎮ㄤ篃鍙互浣跨敤 Database Configuration Assistant锛堟暟鎹簱閰嶇疆鍔╂墜锛夋垨 ORADIM 宸ュ叿锛圤racle 9i 涓彁渚涚殑鏂伴夐」锛夊湪鏈哄櫒涓婂垱寤 Oracle 瀹炰緥銆傛偍杩樺繀椤绘彁渚涙煇浜涗俊鎭紝鍖呮嫭绯荤粺鏍囪瘑绗︼紙System Identifier锛孲ID锛夋垨鏈嶅姟鍚嶃佸疄渚嬪彛浠ゃ佹渶澶х敤鎴锋暟銆佸惎鍔ㄦā寮忥紝绛夌瓑銆傚悓鏍凤紝鍙互浣跨敤甯︽湁 DELETE 閫夐」鐨 ORADIM 宸ュ叿鏉ュ垹闄よ瀹炰緥銆傛偍涔熼渶瑕佷紶閫 SID 鎴栨湇鍔″悕銆傞櫎闈炴偍鍦ㄥ畨瑁呰繃绋嬩腑鍒涘缓鏂扮殑鏁版嵁搴擄紝鍚﹀垯鏂板畨瑁 Oracle 鏃舵槸涓嶄細鍒涘缓榛樿瀹炰緥鐨勩
鍦 DB2 UDB 涓紝褰撳皢浜у搧瀹夎鍦 Windows 骞冲彴涔嬪悗锛屽皢榛樿鍦板垱寤“DB2”瀹炰緥銆侺inux 鍜 UNIX 涓紝鍏堕粯璁ゅ疄渚嬪悕涓“db2inst1”銆傝嫢瑕佸湪鍚屼竴鍙版満鍣ㄤ笂鍒涘缓鍙︿竴涓疄渚嬶紝鎮ㄥ彧闇鎵ц鍛戒护 db2icrt
鍥 3鏄剧ず浜 DB2 UDB Control Center GUI 涓粯璁ょ殑 DB2 UDB 瀹炰緥“DB2”锛圵indows 涓級鍜岀敤 db2icrt 鍛戒护鍒涘缓鐨勫叾浠栦袱涓疄渚嬨
鍥 3. 鏄剧ず鏈 DB2 UDB 瀹炰緥鐨 DB2 UDB Control Center GUI
瑕佷粠鍛戒护琛屾帴鍙ｅ紩鐢ㄤ竴涓粰瀹氱殑 DB2 UDB 瀹炰緥锛岃浣跨敤 DB2INSTANCE 鐜鍙橀噺銆傝鍙橀噺璁╂偍鎸囧畾鎵鏈夊懡浠ゅ皢搴旂敤鍒扮殑褰撳墠鐨勬椿鍔ㄥ疄渚嬨備緥濡傦紝濡傛灉灏 DB2INSTANCE 璁剧疆鎴 PROD锛岀劧鍚庢偍鍙戝嚭 create database MYDB1 鍛戒护锛岄偅涔堟偍灏嗗垱寤哄拰瀹炰緥 PROD 鍏宠仈鐨勬暟鎹簱銆傚鏋滄偍鎯冲湪瀹炰緥 DB2 涓婂垱寤鸿鏁版嵁搴擄紝鍒欏繀椤婚鍏堝皢鍙橀噺 DB2INSTANCE 鐨勫兼洿鏀逛负 DB2銆傝繖涓 ORACLE_SID锛圫ystem Identifier锛夌被浼硷紝瀹冧篃鏄敤浜庡湪瀹炰緥涔嬮棿杩涜鍒囨崲銆
