发表于 2009-1-5 19:48
| 
鐥涜嫤鐨勯仐蹇樷曗曠粰搴旂敤绋嬪簭寮鍙戜汉鍛樼殑鍑犲彞蹇犲憡
鍙戝竷: 2008-7-01 13:54 | 浣滆: admin | 鏌ョ湅: 15娆
鐥涜嫤鐨勯仐蹇樷曗曠粰搴旂敤绋嬪簭寮鍙戜汉鍛樼殑鍑犲彞蹇犲憡
鐑 鑽
銆愬瓧浣擄細灏 澶с
鐥涜嫤鐨勯仐蹇樷曗曠粰搴旂敤绋嬪簭寮鍙戜汉鍛樼殑鍑犲彞蹇犲憡
浣滆咃細锛 鏂囩珷鏉ユ簮锛氾紞 鐐瑰嚮鏁帮細2111 鏇存柊鏃堕棿锛2006-4-22 
Chris Kern
寮鍙戜汉鍛,
2003 骞 12 鏈 鏈枃鐨勭洰鐨勫氨鏄憡璇夊簲鐢ㄧ▼搴忓紑鍙戜汉鍛樺叧浜庡悜 DBA 闃愯堪闂鐨勪竴浜涙妧宸э紝鎴栬呰嚦灏戞彁渚涗竴绉嶉槓杩版儏鍐电殑鏂瑰紡锛屽噺灏 DBA 鍦ㄥ憡璇夋偍濡備綍鍋氭椂寮曡捣鐨勫槻绗戙
澶勫
浣滀负涓鍚嶅簲鐢ㄧ▼搴忓紑鍙戜汉鍛橈紝闄や簡瓒呰繃 10 骞寸殑 DB2 搴旂敤绋嬪簭鏀寔缁忛獙浠ュ锛屽彲浠ヨ鎴戞病鏈変粈涔堢湡姝ｇ殑璇佷功锛屼絾鏄垜璁や负鎴戝畬鍏ㄦ湁璧勬牸璁ㄨ搴旂敤绋嬪簭寮鍙戜汉鍛樻墍缁忓巻鐨勭棝鑻︺傛偍涔熻浼氶棶鐥涜嫤鏉ヨ嚜鍝噷锛熷氨鏄偅浜涗技涔庤秴鍑轰簡搴旂敤绋嬪簭寮鍙戜汉鍛樻帶鍒朵箣澶栫殑绁炵鐨 DB2 闂銆備簨瀹炰笂锛屾垜纭疄閫氳繃浜 IBM DB2 V7.1 Family Application Development Certification 鑰冭瘯锛屽洜姝ゅ彲浠ュ绉版湁姝ｅ紡鐨“IBM 璁よ瘉鐨勮В鍐虫柟妗堜笓瀹讹紙IBM Certified Solutions Expert锛”澶磋銆備絾鏄紝鎴戝彲浠ヨ偗瀹氬湴璇达紝杩欏苟娌℃湁浣挎垜姣斿弬鍔犺冭瘯涔嬪墠鏇磋仾鏄庛傦紙鏈夋椂鍊欐垜鐢氳嚦鎬鐤戦櫎浜嗚兘澶熷湪浣犵殑鍗у閲屾偓鎸備笂涓涓瘉涔︼紝璁よ瘉鐨勬暣涓繃绋嬫槸鍚︽湁鏇村鐨勬剰涔夈傚綋鐒惰繖鏈夌偣绂婚浜嗐傦級
鎴戠煡閬擄紝璧板埌闄勮繎鐨勯潪甯稿弸濂界殑鎶鏈敮鎸佸尯鏄竴浠跺涔堝績鎯婅儐棰ょ殑浜嬶紝姝ュ饱娌夐噸鍦拌蛋鍒版暟鎹簱绠＄悊閮ㄩ棬涓棿锛屽啋鍐掑け澶卞湴锛堜篃璁告槸瑁呯殑锛夊绉帮紝“DB2 鏈変竴涓棶棰橈紝鍥犱负鎴戠殑绋嬪簭涓嶈兘宸ヤ綔锛”缁濆涓嶄細鏄垜鐨勭▼搴忎唬鐮佹湁闂锛佹垜瀹屽叏鐩镐俊锛屽鏋 DBA 姣忔鍦ㄥ惉鍒“DB2 鏈夐棶棰”鏃堕兘鑳藉緱鍒颁竴鏋氱‖甯侊紝閭ｄ粬浠棭灏卞彲浠ラ浼戝埌鍧庢槅锛圕ancun锛夊矝涓婂幓鍏昏侊紝鍐嶄篃涓嶇敤鎷呭績绫讳技 DB2 杩欐牱閬ヨ繙鐨勪粈涔堜簨鎯呬簡銆
涓庝换浣曚簨鎯呬竴鏍凤紝闃愯堪闂鎯呭喌鐨勬柟寮忎篃鏈夋纭拰閿欒涔嬪垎銆傛湰鏂囩殑鐩殑灏辨槸瑕佸憡璇夊簲鐢ㄧ▼搴忓紑鍙戜汉鍛樺叧浜庡悜 DBA 闃愯堪闂鐨勪竴浜涙妧宸э紝鎴栬呰嚦灏戞彁渚涗竴绉嶉槓杩版儏鍐电殑鏂瑰紡锛屽噺灏 DBA 鍦ㄥ憡璇夋偍濡備綍鍋氭椂寮曡捣鐨勭瑧璇濄傛垜缁忓父鐪嬪埌搴旂敤绋嬪簭寮鍙戜汉鍛樺湪鍋氬ソ鍑嗗涔嬪墠锛屽氨鎬ュ寙鍖嗗湴璺戝埌 DBA 閭ｅ効瀵绘眰甯姪锛屼笉涓浼氬効鍙堟劆鎬掕屽眬淇冨湴鍥炲埌浠栦滑鐨勬牸瀛愰棿銆傝璁颁綇锛屾偍——搴旂敤绋嬪簭寮鍙戜汉鍛——濡傛灉娌℃湁鍋氫换浣曞噯澶囧氨鎶婇棶棰樺甫缁 DBA锛屾偍灏变笉浼氳耽寰椾粬浠殑鍚堜綔鍜屽皧閲嶃
瀹氫箟闂
瑕佷繚璇佹偍鐨勯棶棰樼粡杩囧緢濂界殑瀹氫箟銆侱B2 鏄蒋浠跺拰纭欢鐨勫鏉傜粍鍚堛傚敖绠 DB2 浣滀负涓涓叧绯绘暟鎹簱鍙兘涓嶆槸瀹岀編鐨勶紝浣嗗簲鐢ㄧ▼搴忎唬鐮佷腑鐨勯棶棰樺拰 bug 杩滆繙瓒呰繃 DB2 RDBMS 涓殑闂銆傛壘鍒 DBA 骞跺憡璇変粬浠紝鎮ㄧ殑 DB2 绋嬪簭“涓嶈兘宸ヤ綔”銆“娌℃湁寰楀埌姝ｇ‘鐨勭粨鏋”鎴栬“寮傚父缁堟”锛屽苟涓嶈兘鍚戜粬浠彁渚涘鐞嗘墍闇瑕佺殑鐪熸淇℃伅銆傚鏁 DBA 鍜屽叾浠栨瘡涓汉涓鏍锋椂闂村疂璐碉紝鍥犳浠栦滑娌℃湁鏃堕棿浠庡ご鍒板熬璋冭瘯鎮ㄧ殑搴旂敤绋嬪簭銆傛垜浠嚦灏戝彲浠ュ鏈夐棶棰樼殑搴旂敤绋嬪簭鎴栬呬护浜轰笉蹇殑 SQL 璇彞锛堣繖浜岃呴兘鍙兘娣辫棌鍦ㄧ▼搴忕殑璋冪敤閾句腑锛変綔闆剁偣璋冩暣鐨勫熀纭宸ヤ綔銆傛棦鐒舵垜浠棩澶嶄竴鏃ュ湴鎻愪緵搴旂敤绋嬪簭鏀寔锛岄偅涔堣皝鍙堣兘姣斿簲鐢ㄧ▼搴忓紑鍙戜汉鍛樻洿閫傚悎娣卞叆鍒嗘瀽搴旂敤绋嬪簭骞舵壘鍒伴棶棰樼殑鏍规簮鍛紵鍦ㄨ皟鏌ラ棶棰樼殑鏉ユ簮鏃讹紝韪忓叆 DBA 鐨勯棬妲涙姤鍛婇棶棰樹箣鍓嶇▼搴忓憳鏀堕泦鐨勪俊鎭紙姣斿 SQLCA 璇婃柇淇℃伅锛夎秺澶氾紝褰 DBA 纭疄鍙備笌瑙ｅ喅闂鏃讹紝浠栦滑灏辫秺鑳芥洿蹇洿瀹规槗鍦板府鍔╄В鍐抽棶棰樸
閫氬父锛屽鏋滄垜浠兘璇嗗埆鍑轰护浜轰笉蹇殑绋嬪簭鎴 SQL 璇彞锛屾垜浠彲鑳藉氨浼氬彂鐜颁粈涔堝湴鏂归敊浜嗚屼笉蹇呭幓鎵 DBA銆備絾鏄綋鎮ㄧ‘瀹為渶瑕 DBA 鐨勫府鍔╂椂锛屽鏋滄垜浠兘鎸囧嚭“褰撴父鏍 ABC 鎵撳紑鏃堕棶棰樺嚭鍦ㄥ寘 XYZ”鎴栬“褰撹瘯鍥炬彁鍙栨暟鎹椂寰楀埌 SQL 閿欒鐮 -000”锛岄偅涔堝氨姣斿彧鏄缁熺殑涓鍙“DB2 涓嶈兘宸ヤ綔”濂藉緱澶氥傚鏋滆兘澶熼殧绂诲鑷撮棶棰樼殑 SQL 璇彞锛岄偅涔堝畠鍦 QMF 鎴栬 SPUFI 涓兘鍚︽墽琛岋紵濡傛灉绋嬪簭杩愯寰堥暱鏃堕棿锛岃繖鑳藉惁璇存槑闂锛熺▼搴忔湡鏈涚殑缁撴灉鏄粈涔堬紵杩欓噷鐨勮鐐规槸锛屾嫢鏈夎缁嗙殑淇℃伅浠ユ敮鎸佹垜浠槓杩伴棶棰橈紝杩欏浜庢垜浠摐鍒嗗埌 DBA 鐨勪竴鐐规椂闂存潵瑙ｅ喅闂澶ф湁瑁ㄧ泭銆備粠鎴戜滑鎵璇寸殑杩欎竴鐐瑰嚭鍙戯紝寰堝鏄撳紩鍏ュ洶鎵板簲鐢ㄧ▼搴忓紑鍙戜汉鍛樼殑涓嬩竴涓妧宸с
鍧氭寔鍙備笌
涓嶈鍙槸鎶婇棶棰樻墧鍒 DBA 鐨勯潰鍓嶅苟鏈熸湜鑳藉瑙ｅ喅銆傚湪杩欎釜璇煶閭欢銆佺數瀛愰偖浠跺拰浼犵湡婊″ぉ椋炵殑鏃朵唬锛屽彂閫佷竴涓秷鎭埌 DBA 棰嗗湴锛屽苟鎸囨湜涓嶉渶瑕佹彁鍑洪棶棰樼殑绋嬪簭鍛樼殑鍙備笌灏辫兘绁炲鍦板緱鍒拌В鍐筹紝鐪熸槸澶鏄撲簡銆備笉璁烘垜浠皢涓灏佺數瀛愰偖浠舵妱閫佺粰浜嗗灏戜釜浜猴紝闄ら潪搴旂敤绋嬪簭寮鍙戜汉鍛樺弬涓庡埌闂鐨勮В鍐充腑鏉ワ紝鍚﹀垯闂灏变笉鍙兘寰楀埌瑙ｅ喅銆侱BA 鍙互鎻愬嚭寤鸿锛屾彁渚涗唬鐮佹垨鑰 SQL锛屽苟涓旀嫢鏈夐潪甯告鐨勫伐鍏枫傚敖绠″姝わ紝闄ら潪鎴戜滑琛ㄧ幇鍑哄淇搴旂敤绋嬪簭涓殑闂鐨勪富鍔ㄦэ紝鍚﹀垯 DBA 浣曞繀鍏冲績鎴戜滑鏄惁璧峰簥浜嗗苟閲嶆柊杩愯浜嗗簲鐢ㄧ▼搴忥紵浠呬粎璇“鎴戝憡璇 DBA 浜”骞舵湡鏈涙煇绉嶇湡姝ｇ殑瑙ｅ喅鏄笉澶熺殑銆傛垜浠秺琛ㄧ幇鍑哄弬涓庣殑鎰挎湜锛屽叾浠栦汉灏辫秺鎰挎剰甯姪鎴戜滑銆
涓嬮潰鐨勬鏌ヨ〃鍒楀嚭浜嗗簲鐢ㄧ▼搴忓紑鍙戜汉鍛樺彲浠ュ仛鐨勪竴浜涗簨鎯咃紝浠ユ悳闆嗘湁鍔╀簬 DBA 鐨勪俊鎭細
闅旂闂銆傝繖鍙兘闇瑕佸交搴曞垎鏋愮▼搴忎腑鏌愪釜闀块暱鐨勮皟鐢ㄩ摼銆傝繖绉嶈垂鏃剁殑宸ヤ綔鏇撮傚悎绋嬪簭鍛樿屼笉鏄 DBA 鏉ュ仛銆
璇嗗埆鍑轰护浜轰笉蹇殑SQL銆傚鏋滃彲鑳斤紝杩欎釜 SQL 璇彞鑳藉湪 SPUFI 鎴 QMF 涓墽琛屽悧锛燂紙闂锛氬湪 SPUFI 鎴 QMF 涓墽琛屼竴涓鍙ヤ笌璇嗗埆鏈夐棶棰樼殑 SQL 璇彞杩欎釜绱фョ殑浠诲姟鏈変粈涔堝叧绯? 锛
鎻愪緵灏藉彲鑳藉鐨 SQLCA銆傚敖绠 SQLCODE 鎴 SQLSTATE 涓嶉敊锛屼絾鏄嫢鏈夋墍鏈夌殑 SQLCA 璇婃柇淇℃伅鏇村ソ銆
鎵ц涓涓В閲婏紙explain锛夈 鍦ㄥ寘鎴栬呰鍒掞紙plan锛変笂鎵ц涓涓В閲娿侱BA 鍙互甯姪鎮ㄨВ閲婄粨鏋溿傦紙闂锛氬皾璇曞彲瑙嗗寲鐨勮В閲婂拰鎮ㄨ嚜宸卞缁撴灉鐨勭悊瑙ｆ湁浠涔堥敊璇紵锛
瀵逛簬鏈熸湜鐨勭粨鏋滄湁涓瀹氱殑姒傚康銆傚鏋滀笉鐭ラ亾鎮ㄨ浠涔堬紝鍙堟庝箞鐭ラ亾闂浠涔堟椂鍊欒В鍐充簡锛
鐭ラ亾闂瀛樺湪浜嗗闀挎椂闂淬傝繖涓棶棰樺凡缁忓瓨鍦ㄤ竴娈垫椂闂翠簡锛岃繕鏄垰鍒氬嚭鐜板憿锛
鐜鏈変粈涔堝彉鍖栧悧锛熷簲鐢ㄧ▼搴忔槸鍚︿綔浜嗘煇浜涘彲鑳藉鑷撮棶棰樼殑淇敼锛熸瘮濡傦細搴旂敤绋嬪簭閲嶆柊缂栬瘧鎴栬呴噸鏂扮粦瀹氳繃锛坮ebound锛夛紝鏈杩戞墽琛岃繃 RUNSTATS锛岀瓑绛夈
澶勭悊鐨勬暟鎹槸鍚︽瘮骞冲父澶氾紵 锛堥棶棰橈細浠涔堟槸“骞冲父”锛燂級鏄惁鏈夋椿鍔ㄥ嘲鍊煎彲鑳介犳垚搴旂敤绋嬪簭闂锛
濡傛灉闂鍑虹幇鍦ㄤ骇鍝佺幆澧冧腑锛岃兘鍦ㄦ祴璇曠幆澧冧腑閲嶅缓鍚楋紵灏濊瘯璁╁畠鍦ㄦ祴璇曠幆澧冧腑鍙戠敓銆
