db2linuxsql

1. linux閲嶅惎db2鎶ラ敊锛屽ぇ绁炴眰鏁

1.鍦ㄥ懡浠よ岀晫闱涓鐢ㄥ备笅璇鍙ュ垏鎹㈠埌db2inst1璐︽埛涓锛
su - db2inst1
娉ㄦ剰锛屽懡浠よ佸皬鍐欙纴涓闂寸殑鍑忓彿鏄鍗婅掔殑銆傚叾涓璬b2inst1璐︽埛锛埚悓镞朵篃鏄瀹炰緥銆佽繘绋嬶级鏄鍦ㄥ畨瑁匘B2杩囩▼涓鍒涘缓镄勪竴涓榛樿よ处鎴凤纴鐩稿綋浜嶹indows涓镄勯偅涓狣B2瀹炰緥锛岃佹兂镓ц屽悇绉峝b2镄勫懡浠わ纴闇瑕佸湪杩欎釜璐︽埛涓嬫搷浣滐绂

2.鍦ㄨヨ处鎴蜂笅锛屽彲浠ユ墦寮鎺у埗涓蹇冿纴涔熷彲浠ヨ繘鍏ュ埌锻戒护琛屽勭悊鍣ㄣ傝繘鍏ュ懡浠よ屽勭悊鍣ㄧ殑鏂规硶寰堢亩鍗曪纴鐩存帴鐢╠b2锻戒护锛岀劧钖庡洖杞﹀嵆鍙锛

3.镓揿紑鎺у埗涓蹇幂◢寰链夌偣楹荤储锛岄渶瑕佸湪妗岄溃涓婂彟澶栨墦寮涓涓锻戒护琛岀獥鍙ｏ纴鍦ㄥ叾涓杈揿叆锛
xhost local:db2
铹跺悗鍦╠b2inst1璐︽埛镓鍦ㄧ殑绐楀彛涓锛岃緭鍏ュ懡浠わ细
db2cc &
灏卞彲浠ユ墦寮鎺у埗涓蹇冦

4.鐜板湪鍙浠ユ煡鐪嫔綋鍓嶅疄渚
db2ilist
濡傛灉闇瑕佸垱寤鸿〃锛屽垯闇瑕佹墦寮鏁版嵁搴撶＄悊链嶅姟锛岃緭鍏ュ懡浠わ细
su - db2inst1
db2start //钖锷╠b2宸ヤ綔瀹炰緥
db2stop //锅沧db2瀹炰緥
db2set -all //镆ョ湅db2镓链夋敞鍐岃〃鍙橀噺
鍦ㄥ彉閲忓垪琛ㄤ腑链変竴涓猟b2绠＄悊鐢ㄦ埛锛欴B2ADMINSERVER=XXXXX
鍙链夊垏鎹㈠埌绠＄悊鐢ㄦ埛镓嶅彲浠ュ垱寤鸿〃 su - XXXXX
铹跺悗锛岃緭鍏ュ懡浠わ细 db2admin start 钖锷ㄧ＄悊瀹炰緥
璇存槑:
鍦↙inux鐜澧冧笅锛屼竴涓鐢ㄦ埛瀵瑰簲涓涓瀹炰緥锛屽垱寤烘暟鎹搴揿繀椤诲湪瀹炰緥涓嫔垱寤猴纴锲犳ゅ垏鎹㈠埌鐢ㄦ埛鍗冲彲鍒囨崲鍒板疄渚嬨傚懡浠ゅ备笅锛
su - db2inst1
db2 get instance

2. linuxdb2锻戒护琛屾墽琛屽煎嚭镆ヨ㈢粨鏋渓inuxdb2锻戒护

db2镞犳硶杩炴帴鏁版嵁搴掳纻

1.鐪嬬湅绔鍙ｅ彿链夋病链夐厤缃姝ｇ‘锛岀湅涓涓嬮厤缃鍙傛暟svcename璺焥ervices鏂囦欢涓閰岖疆镄刣b2绔鍙ｅ彿鏄钖︿竴镊达纴windows涓鑸鐢50000锛寀nix/linux涓鑸鐢60000

2.杩炴帴鍑洪敊棣栧厛鐪嬬湅链嶅姟鍣╥p鍜岀鍙ｅ啓瀵规病链

ip濡傛灉娌￠敊灏辫佺湅鐪嬫湇锷″櫒镄刣b2链嶅姟绔鍙ｅ逛笉瀵广傚彟澶栧逛簬链嶅姟鍣ㄤ笅闱㈣繖浜涗篃瑕佹敞镒

妫镆ユ湇锷″櫒镄勯厤缃𨱍呭喌濡备笅锛

楠岃瘉瀛桦湪镄凞B2鏁版嵁搴

db2listdbdirectory

db2listdbdirectoryshowdetail

楠岃瘉瀹炰緥浣跨敤镄勯氲鍗忚锛屾煡鐪妇B2COMM鍙橀噺

db2set-all

镆ョ湅鏁版嵁搴撶＄悊鍣ㄧ殑閰岖疆锛屾煡鐪婼VCENAME锛堢壒鎸噒cpip鍗忚锛

db2getdbmcfg

镆ョ湅/etc/services涓锛屾湁镞犱笌涓婇溃瀵瑰簲SVCENAME镄勭鍙ｏ纴渚嫔傦细

db2cDB250000/tcp

瑕佺‘璁ゆ湇锷″櫒鏄钖﹀湪鐩戝惉锛屽彲浠ョ敤netstat-an𨱒ユ煡鐪嬬鍙ｆ槸钖﹀勪簬LISTEN鐘舵併

镐庝箞镆ョ湅DB2镄勫悗鍙拌繘绋嬶纻镐庝箞鐪嬬郴缁熷垎閰岖粰鏁版嵁搴撶殑瑁歌惧囷纻

1.unix/linuxls-al|grepdb2

2.濡傛灉浠巐v镄勫悕瀛椾笂鐪嬩笉鍑烘潵灏辫繛涓婃暟鎹搴掳纴铹跺悗鐪嬭〃绌洪棿瀹瑰櫒钖

銆愭ャ戝备綍瀵煎嚭链嶅姟鍣ㄤ笂镄刣b2鏁版嵁搴掳纴鏄瀵煎嚭鏁翠釜鏁版嵁搴掳纴鍖呮嫭琛ㄧ粨鏋勮〃绌洪棿锛屾暟鎹绛夛纻

涓岖敤锛屽彲浠ヨ繙绋嬭繛鎺ュ埌链嶅姟鍣锛寃indows绯荤粺鍙浠ラ氲繃杩灭▼杩炴帴锛宭inux/unix绯荤粺鍙浠ラ氲繃ssh/telnet杩炴帴锛屽湪链嶅姟鍣ㄤ笂鐢╠b2connectto鏁版嵁搴揿悕杩炴帴鏁版嵁搴掳纴铹跺悗阃氲繃db2look-d鏁版嵁搴揿悕-e-a-c-o瀵煎嚭鏂囦欢钖.sql-i鐢ㄦ埛钖-w瀵嗙爜瀵煎嚭缁撴瀯锛岄氲繃db2move鏁版嵁搴揿悕export-u鐢ㄦ埛钖-p瀵嗙爜瀵煎嚭鏁版嵁锛

鍦ㄦ湰鍦板煎叆鍓嶅厛connect鏁版嵁搴掳纴铹跺悗db2-td;-cf瀵煎嚭鏂囦欢钖.sql鍦ㄦ湰鍦版牴鎹璇ユ枃浠秙ql寤虹珛鏁版嵁缁撴瀯锛屼箣钖庣敤db2move鏁版嵁搴揿悕load-u鐢ㄦ埛钖-p瀵嗙爜瀵煎叆鏁版嵁

濡备綍镆ョ湅db2涓鍒涘缓鎴愬姛镄勫瓨鍌ㄨ繃绋嬶纻

瀛桦偍杩囩▼锛歴p_xx.镆ョ湅瀛桦偍linux锛歞b2"select*fromsyscat.PROCEDURES|grep-isp_xx"window:db2"select*fromsyscat.PROCEDURES|find/i"sp_xx""