DB2安裝以及建庫(kù)參考

DB2安裝以及建庫(kù)參考JIMMY第一章DB2安裝11前提條件1、在操作系統(tǒng)上創(chuàng)建下面用戶和組用戶用戶ID組組IDDB2INST11001DB2IADM1999DB2FENC11002DB2FADM1998DASUSR11003DASADM19972、MOUNT光驅(qū)，便于使用安裝介質(zhì)，或者將安裝軟件FTP到服務(wù)器。3、查看/ETC/HOSTS文件，確認(rèn)主機(jī)名和IP已經(jīng)設(shè)置。4、如果是LINUX操作系統(tǒng)，檢查是否安裝了開(kāi)發(fā)工具包“DEVELOPMENTTOOLS”、“XSOFTWAREDEVELOPMENT”、“LEGACYSOFTWAREDEVELOPMENT”，如果沒(méi)有請(qǐng)安裝。5、驗(yàn)證中文語(yǔ)言環(huán)境安裝正確，以DB2INST1用戶登錄OS，運(yùn)行下面命令LSALL如果文件日期顯示為中文，說(shuō)明中文語(yǔ)言環(huán)境正確。注以上操作可參照對(duì)應(yīng)的操作系統(tǒng)手冊(cè)。12DB2軟件安裝用ROOT用戶將介質(zhì)上傳道服務(wù)器，用ROOT用戶安裝。1、以ROOT用戶登錄OS，進(jìn)入安裝文件所在目錄，運(yùn)行下面命令TARXVFC58SMLTARCD009_ESE_LNX_32_NLV/DB2_INSTALL此命令為從命令行進(jìn)行安裝DB2（如果權(quán)限不夠則執(zhí)行CHMODR777）SPECIFYONEORMOREOFTHEFOLLOWINGKEYWORDS,SEPARATEDBYSPACES,TOINSTALLDB2PRODUCTSKEYWORDPRODUCTDESCRIPTIONDB2ESEDB2ENTERPRISESERVEREDITIONFORLINUXDB2ADMCLDB2ADMINISTRATIONCLIENTFORLINUXDB2ADCLDB2APPLICATIONDEVELOPMENTCLIENTFORLINUXENTER“HELP“TOREDISPLAYPRODUCTNAMESENTER“QUIT“TOEXIT2、輸入DB2ESE，按RETURN鍵運(yùn)行結(jié)果IBM_DB2MSEN81PREPARINGIBM_DB2MSEN81IBM_DB2CLIV81PREPARINGIBM_DB2CLIV81IBM_DB2ICW81PREPARINGIBM_DB2ICW81IBM_DB2LDAP81PREPARINGIBM_DB2LDAP81IBM_DB2WMSA81PREPARINGIBM_DB2WMSA81IBM_DB2CUCS81PREPARINGIBM_DB2CUCS81IBM_DB2CONV81PREPARINGIBM_DB2CONV81IBM_DB2SECL81PREPARINGIBM_DB2SECL81IBM_DB2SESM81PREPARINGIBM_DB2SESM81IBM_DB2ICUC81PREPARINGIBM_DB2ICUC81IBM_DB2ICUT81PREPARINGIBM_DB2ICUT81IBM_DB2JHEN81PREPARINGIBM_DB2JHEN81IBM_DB2REPL81PREPARINGIBM_DB2REPL81IBM_DB2SP81PREPARINGIBM_DB2SP81IBM_DB2CHEN81PREPARINGIBM_DB2CHEN81IBM_DB2ADT81PREPARINGIBM_DB2ADT81IBM_DB2ADTS81PREPARINGIBM_DB2ADTS81IBM_DB2XMLS81PREPARINGIBM_DB2XMLS81IBM_DB2CJ81PREPARINGIBM_DB2CJ81IBM_DB2DC81PREPARINGIBM_DB2DC81IBM_DB2DWCM81PREPARINGIBM_DB2DWCM81IBM_DB2FS81PREPARINGIBM_DB2FS81IBM_DB2INST81PREPARINGIBM_DB2INST81IBM_DB2WBDB81PREPARINGIBM_DB2WBDB81IBM_DB2XML81PREPARINGIBM_DB2XML81IBM_DB2JDBC81PREPARINGIBM_DB2JDBC81IBM_DB2CA81PREPARINGIBM_DB2CA81IBM_DB2RTE81PREPARINGIBM_DB2RTE81IBM_DB2CONN81PREPARINGIBM_DB2CONN81IBM_DB2CRTE81PREPARINGIBM_DB2CRTE81IBM_DB2DAS81PREPARINGIBM_DB2DAS81IBM_DB2DJ81PREPARINGIBM_DB2DJ81IBM_DB2ENGN81PREPARINGIBM_DB2ENGN81IBM_DB2SMPL81PREPARINGIBM_DB2SMPL81IBM_DB2DJX81PREPARINGIBM_DB2DJX81IBM_DB2INX81PREPARINGIBM_DB2INX81IBM_DB2PEXT81PREPARINGIBM_DB2PEXT81IBM_DB2ESSG81PREPARINGIBM_DB2ESSG81IBM_DB2CC81PREPARINGIBM_DB2CC81IBM_DB2ICC81PREPARINGIBM_DB2ICC81IBM_DB2ICMS81PREPARINGIBM_DB2ICMS81THEINSTALLATIONLOGFILECANBEFOUNDIN/TMP/DB2_INSTALL_LOG29754DB2_INSTALLPROGRAMCOMPLETEDSUCCESSFULLY13創(chuàng)建數(shù)據(jù)庫(kù)管理服務(wù)器用ROOT用戶操作CD/DB2安裝目錄/INSTANCE/DASCRTUDASUSR1用DASUSR1用戶登錄OSVIBASH_PROFILE/HOME/DASUSR1/DAS/DASPROFILE添加這一行代碼（如果文件不存在則新建，位置在DASUSR1用戶的缺省目錄下，如HOME/DASUSR1/）14創(chuàng)建實(shí)例用ROOT用戶操作CD/DB2安裝目錄/INSTANCE/DB2ICRTUDB2FENC1DB2INST1DBI1070IPROGRAMDB2ICRTCOMPLETEDSUCCESSFULLY15修改/ETC/SERVICES文件用ROOT用戶操作修改/ETC/SERVICES文件LOCALSERVICESDB2INST150000/TCP增加該行代碼16設(shè)置環(huán)境變量用DB2INST1用戶操作161修改BASH_PROFILEVIBASH_PROFILE（如果文件不存在則新建，位置在DB2INST1用戶的缺省目錄下）/HOME/DB2INST1/SQLLIB/DB2PROFILE增加該行代碼162163設(shè)置服務(wù)名稱(chēng)DB2UPDATEDBMCFGUSINGSVCENAMEDB2INST1DB20000ITHEUPDATEDATABASEMANAGERCONFIGURATIONCOMMANDCOMPLETEDSUCCESSFULLY注意這一步如出現(xiàn)問(wèn)題，請(qǐng)參見(jiàn)常見(jiàn)問(wèn)題這章的問(wèn)題一來(lái)進(jìn)行解決。164設(shè)置注冊(cè)變量DB2SETDB2COMMTCPIP17啟動(dòng)實(shí)例DB2START12/26/200516213100SQL1063NDB2STARTPROCESSINGWASSUCCESSFULSQL1063NDB2STARTPROCESSINGWASSUCCESSFUL18DB2客戶端安裝181前提條件1、在操作系統(tǒng)上創(chuàng)建下面用戶和組用戶用戶ID組組IDDB2INST11001DB2IADM19992、MOUNT光驅(qū)，便于使用安裝介質(zhì)，或者將安裝軟件FTP到服務(wù)器。182DB2軟件安裝用ROOT用戶將介質(zhì)上傳到服務(wù)器，用ROOT用戶安裝。1、以ROOT用戶登錄OS，進(jìn)入安裝文件所在目錄，運(yùn)行下面命令CDDB2V91FORAIXLSLICENSE正版ESEMEDIAXLCCDESELSDISK1CDDISK1LSDB2DB2_INSTALLDB2SETUPDOCINSTALLFIXPACKPWD/HOME/DB2INST1/DB2V91FORAIX/ESE/DISK1/DB2_INSTALLKSH/DB2_INSTALL0403006執(zhí)行許可權(quán)被拒絕。CHMODR777/DB2_INSTALL用于安裝產(chǎn)品的缺省目錄是/OPT/IBM/DB2/V91想要選擇另一個(gè)目錄來(lái)進(jìn)行安裝嗎是否是輸入安裝目錄的完整路徑名/IBM/DB2CLIENT指定下面的一個(gè)或多個(gè)關(guān)鍵字（用空格分隔）以安裝DB2產(chǎn)品。CLIENTRTCLESE輸入“HELP“以重新顯示產(chǎn)品名。輸入“QUIT“以退出。CLIENT正在初始化DB2安裝。要執(zhí)行的任務(wù)總數(shù)為30要執(zhí)行的所有任務(wù)的總估計(jì)時(shí)間為578任務(wù)1啟動(dòng)描述正在啟用異步I/O估計(jì)時(shí)間2秒任務(wù)1結(jié)束任務(wù)2啟動(dòng)描述正在檢查許可協(xié)議的接受情況估計(jì)時(shí)間1秒任務(wù)2結(jié)束任務(wù)3啟動(dòng)描述產(chǎn)品消息英語(yǔ)估計(jì)時(shí)間10秒任務(wù)3結(jié)束任務(wù)4啟動(dòng)描述基本客戶機(jī)支持估計(jì)時(shí)間131秒任務(wù)4結(jié)束任務(wù)5啟動(dòng)描述IBMJAVATM軟件開(kāi)發(fā)包（SDK）估計(jì)時(shí)間81秒任務(wù)5結(jié)束任務(wù)6啟動(dòng)描述JAVA幫助（HTML）英語(yǔ)估計(jì)時(shí)間7秒任務(wù)6結(jié)束任務(wù)7啟動(dòng)描述SQL過(guò)程估計(jì)時(shí)間3秒任務(wù)7結(jié)束任務(wù)8啟動(dòng)描述ICU實(shí)用程序估計(jì)時(shí)間41秒任務(wù)8結(jié)束任務(wù)9啟動(dòng)描述JAVA支持估計(jì)時(shí)間6秒任務(wù)9結(jié)束任務(wù)10啟動(dòng)描述JAVA公共文件估計(jì)時(shí)間19秒任務(wù)10結(jié)束任務(wù)11啟動(dòng)描述SPATIALEXTENDER客戶機(jī)估計(jì)時(shí)間6秒任務(wù)11結(jié)束任務(wù)12啟動(dòng)描述基本應(yīng)用程序開(kāi)發(fā)工具估計(jì)時(shí)間18秒任務(wù)12結(jié)束任務(wù)13啟動(dòng)描述復(fù)制工具估計(jì)時(shí)間13秒任務(wù)13結(jié)束任務(wù)14啟動(dòng)描述DB2LDAP支持估計(jì)時(shí)間4秒任務(wù)14結(jié)束任務(wù)15啟動(dòng)描述“DB2實(shí)例安裝”向?qū)Ч烙?jì)時(shí)間4秒任務(wù)15結(jié)束任務(wù)16啟動(dòng)描述XMLEXTENDER估計(jì)時(shí)間10秒任務(wù)16結(jié)束任務(wù)17啟動(dòng)描述第一步估計(jì)時(shí)間3秒任務(wù)17結(jié)束任務(wù)18啟動(dòng)描述DB2客戶機(jī)的產(chǎn)品特征符估計(jì)時(shí)間5秒任務(wù)18結(jié)束任務(wù)19啟動(dòng)描述DB2WEB工具估計(jì)時(shí)間12秒任務(wù)19結(jié)束任務(wù)20啟動(dòng)描述XMLEXTENDER樣本估計(jì)時(shí)間3秒任務(wù)20結(jié)束任務(wù)21啟動(dòng)描述ADT樣本程序估計(jì)時(shí)間21秒任務(wù)21結(jié)束任務(wù)22啟動(dòng)描述SPATIALEXTENDER樣本估計(jì)時(shí)間3秒任務(wù)22結(jié)束任務(wù)23啟動(dòng)描述正在設(shè)置DB2庫(kù)路徑估計(jì)時(shí)間120秒任務(wù)23結(jié)束任務(wù)24啟動(dòng)描述正在執(zhí)行控制任務(wù)估計(jì)時(shí)間20秒任務(wù)24結(jié)束任務(wù)25啟動(dòng)描述正在更新全局注冊(cè)表估計(jì)時(shí)間20秒任務(wù)25結(jié)束任務(wù)26啟動(dòng)描述正在更新DB2LS鏈接估計(jì)時(shí)間1秒任務(wù)26結(jié)束任務(wù)27啟動(dòng)描述正在注冊(cè)DB2許可證估計(jì)時(shí)間5秒任務(wù)27結(jié)束任務(wù)28啟動(dòng)描述正在設(shè)置缺省全局概要文件注冊(cè)表變量估計(jì)時(shí)間1秒任務(wù)28結(jié)束任務(wù)29啟動(dòng)描述正在初始化實(shí)例列表估計(jì)時(shí)間5秒任務(wù)29結(jié)束任務(wù)30啟動(dòng)描述正在更新全局概要文件注冊(cè)表估計(jì)時(shí)間3秒任務(wù)30結(jié)束已成功完成執(zhí)行。有關(guān)更多信息，請(qǐng)參閱“/TMP/DB2_INSTALLLOG155660“上的DB2安裝日志。183創(chuàng)建實(shí)例用ROOT用戶操作CD/DB2安裝目錄/INSTANCE/DB2ICRTUDB2INST1DB2INST1DBI1070IPROGRAMDB2ICRTCOMPLETEDSUCCESSFULLY命令CD/IBM/CLICENTKSH/IBM/CLICENT找不到。/IBM/DB2CLIENTKSH/IBM/DB2CLIENT0403006執(zhí)行許可權(quán)被拒絕。CD/IBMLSDB2CLIENTLOSTFOUNDCDDB2CLIENTLSMETADATABINCONVDOCINCLUDE32INSTANCELIB64PROFILESREGSECURITY64READMEBNDDB2XMLFUNCTIONINFOPOPJAVALICENSESAMPLESTIVREADYADMCFGDEFAULTENVINCLUDEINSTALLLIB32MSGSECURITY32TOOLSCDINSTANCELSCOMMONDB2ICKNMDB2IDEFSDB2IINFODB2IMIGRDB2ISETDB2ISTOPDB2IUPDTNATIVEDB2CKMIGDB2ICRTDB2IDROPDB2ILISTDB2INSTCFGDB2ISETUPDB2ISTRTDB2IUTILDB2CLPIDDB2IDBMDB2IEXECDB2IMCHKDB2IPCLDDB2ISRVDB2IUADMDB2UIT/DB2ICRTUDB2INST1DB2INST1DBI1070IPROGRAMDB2ICRTCOMPLETEDSUCCESSFULLY184編目、連接數(shù)據(jù)庫(kù)SUDB2INST1DB2CATALOGTCPIPNODENODE58REMOTE10014858SERVER50000DB20000ITHECATALOGTCPIPNODECOMMANDCOMPLETEDSUCCESSFULLYDB21056WDIRECTORYCHANGESMAYNOTBEEFFECTIVEUNTILTHEDIRECTORYCACHEISREFRESHEDDB2TERMINATEDB20000ITHETERMINATECOMMANDCOMPLETEDSUCCESSFULLYDB2CATALOGDATABASEBIZATNODENODE58DB20000ITHECATALOGDATABASECOMMANDCOMPLETEDSUCCESSFULLYDB21056WDIRECTORYCHANGESMAYNOTBEEFFECTIVEUNTILTHEDIRECTORYCACHEISREFRESHEDDB2TERMINATEDB20000ITHETERMINATECOMMANDCOMPLETEDSUCCESSFULLYDB2CONNECTTOBIZUSERDB2ISNT1ENTERCURRENTPASSWORDFORDB2ISNT1SQL30082NSECURITYPROCESSINGFAILEDWITHREASON“24“USERNAMEAND/ORPASSWORDINVALID“SQLSTATE08001DB2CONNECTTOBIZDB2INST1SQL0104NANUNEXPECTEDTOKEN“DB2INST1“WASFOUNDFOLLOWING“EXPECTEDTOKENSMAYINCLUDE“USER“SQLSTATE42601DB2CONNECTTOBIZUSERDB2INST1ENTERCURRENTPASSWORDFORDB2INST1SQL0332NCHARACTERCONVERSIONFROMTHESOURCECODEPAGE“1386“TOTHETARGETCODEPAGE“819“ISNOTSUPPORTEDSQLSTATE57017DB2SETDB2SETDB2CODEPAGE1386DB2CONNECTTOBIZUSERDB2INST1ENTERCURRENTPASSWORDFORDB2INST1SQL0332NCHARACTERCONVERSIONFROMTHESOURCECODEPAGE“1386“TOTHETARGETCODEPAGE“819“ISNOTSUPPORTEDSQLSTATE57017DB2TERMINATEDB20000ITHETERMINATECOMMANDCOMPLETEDSUCCESSFULLYDB2SETDB2CODEPAGE1386DB2SETDB2CODEPAGE1386DB2CONNECTTOBIZUSERDB2INST1CDB2CONNECTTOBIZUSERDB2INST1ENTERCURRENTPASSWORDFORDB2INST1DATABASECONNECTIONINFORMATIONDATABASESERVERDB2/AIX64910SQLAUTHORIZATIONIDDB2INST1LOCALDATABASEALIASBIZ19DB2補(bǔ)丁安裝191問(wèn)題描述在一個(gè)啟用并行性（INTRA_PARALLELENABLED）的系統(tǒng)（DBMS），在執(zhí)行需要排序的查詢時(shí)（例如，SELECTDISTINCT，ORDERBY，或者聚合操作）可能造成數(shù)據(jù)庫(kù)崩潰。造成數(shù)據(jù)庫(kù)崩潰的原因是啟用并行性的時(shí)，可能發(fā)生重復(fù)釋放同一個(gè)臨時(shí)頁(yè)面的情況。192解決方案1關(guān)閉并行性影響性能2打補(bǔ)丁DB2V91FIXPACK7193具體問(wèn)題描述HTTP/WWW01IBMCOM/SUPPORT/DOCVIEWWSSRS71THEN/HOME/DB2INST1/SQLLIB/DB2PROFILEFI編輯文件/HOME/ZHKREAD/BASH_PROFILE，內(nèi)容如下/HOME/DB2INST1/SQLLIB/DB2PROFILE313賦予用戶連接數(shù)據(jù)庫(kù)權(quán)限用數(shù)據(jù)庫(kù)實(shí)例用戶DB2INST1登陸服務(wù)器，執(zhí)行下列命令，賦予ZHKREAD用戶連接數(shù)據(jù)庫(kù)的權(quán)利DB2GRANTCONNECTONDATABASETOUSERZHKREAD314建立數(shù)據(jù)庫(kù)模式建立數(shù)據(jù)庫(kù)模式DB2CREATESCHEMAZHKREAD315賦予用戶查詢權(quán)限執(zhí)行下列命令，賦予查詢權(quán)利DB2GRANTSELECTONTABLETBL_NAMETOUSERZHKREADGRANTSELECTONTABLETBL_INCOMETOUSERZHKREADGRANTSELECTONTABLETBL_INEXPORTTOUSERZHKREADGRANTSELECTONTABLETBL_INPAYTOUSERZHKREADGRANTSELECTONTABLETBL_INREMITTOUSERZHKREADGRANTSELECTONTABLETBL_OUTPAYTOUSERZHKREADGRANTSELECTONTABLETBL_OUTREMITTOUSERZHKREADGRANTSELECTONTABLETBL_CUSTOMSTOUSERZHKREADGRANTSELECTONTABLETBL_REFERENCETOUSERZHKREADGRANTSELECTONTABLEB_A06TOUSERZHKREADGRANTSELECTONTABLETBL_CUSTOMERINFOTOUSERZHKREADGRANTSELECTONTABLETBL_CUSTOMERBANKTOUSERZHKREADGRANTSELECTONTABLETBL_BRANCHINFOTOUSERZHKREADGRANTSELECTONTABLETBL_BANKINFOTOUSERZHKREADGRANTSELECTONTABLETBL_SAFEINFOTOUSERZHKREADGRANTSELECTONTABLETBL_TAXFREETOUSERZHKREADGRANTSELECTONTABLETBL_INDUSTRYTOUSERZHKREADGRANTSELECTONTABLETBL_ECONTYPETOUSERZHKREADGRANTSELECTONTABLETBL_COUNTRYTOUSERZHKREADGRANTSELECTONTABLETBL_AREACODETOUSERZHKREADGRANTSELECTONTABLETBL_CCYCODETOUSERZHKREADGRANTSELECTONTABLETBL_CCYRATEHISTOUSERZHKREADGRANTSELECTONTABLETBL_TXCODETOUSERZHKREADGRANTSELECTONTABLETBL_BANKATTRTOUSERZHKREADGRANTSELECTONTABLETBL_PAYMETHODCODETOUSERZHKREADGRANTSELECTONTABLETBL_PAYATTRTOUSERZHKREAD316建立表別名執(zhí)行下列命令建立表別名CREATEALIASZHKREADTBL_INCOMEFORDB2INST1TBL_INCOMECREATEALIASZHKREADTBL_INEXPORTFORDB2INST1TBL_INEXPORTCREATEALIASZHKREADTBL_INPAYFORDB2INST1TBL_INPAYCREATEALIASZHKREADTBL_INREMITFORDB2INST1TBL_INREMITCREATEALIASZHKREADTBL_OUTPAYFORDB2INST1TBL_OUTPAYCREATEALIASZHKREADTBL_OUTREMITFORDB2INST1TBL_OUTREMITCREATEALIASZHKREADTBL_CUSTOMSFORDB2INST1TBL_CUSTOMSCREATEALIASZHKREADTBL_REFERENCEFORDB2INST1TBL_REFERENCECREATEALIASZHKREADB_A06FORDB2INST1B_A06CREATEALIASZHKREADTBL_CUSTOMERINFOFORDB2INST1TBL_CUSTOMERINFOCREATEALIASZHKREADTBL_CUSTOMERBANKFORDB2INST1TBL_CUSTOMERBANKCREATEALIASZHKREADTBL_BRANCHINFOFORDB2INST1TBL_BRANCHINFOCREATEALIASZHKREADTBL_BANKINFOFORDB2INST1TBL_BANKINFOCREATEALIASZHKREADTBL_SAFEINFOFORDB2INST1TBL_SAFEINFOCREATEALIASZHKREADTBL_TAXFREEFORDB2INST1TBL_TAXFREECREATEALIASZHKREADTBL_INDUSTRYFORDB2INST1TBL_INDUSTRYCREATEALIASZHKREADTBL_ECONTYPEFORDB2INST1TBL_ECONTYPECREATEALIASZHKREADTBL_COUNTRYFORDB2INST1TBL_COUNTRYCREATEALIASZHKREADTBL_AREACODEFORDB2INST1TBL_AREACODECREATEALIASZHKREADTBL_CCYCODEFORDB2INST1TBL_CCYCODECREATEALIASZHKREADTBL_CCYRATEHISFORDB2INST1TBL_CCYRATEHISCREATEALIASZHKREADTBL_TXCODEFORDB2INST1TBL_TXCODECREATEALIASZHKREADTBL_BANKATTRFORDB2INST1TBL_BANKATTRCREATEALIASZHKREADTBL_PAYMETHODCODEFORDB2INST1TBL_PAYMETHODCODECREATEALIASZHKREADTBL_PAYATTRFORDB2INST1TBL_PAYATTR32生產(chǎn)環(huán)境用戶切換321創(chuàng)建操作系統(tǒng)用戶用ROOT用戶登錄系統(tǒng)，SMITUSER命令創(chuàng)建操作系統(tǒng)用戶WHJH，設(shè)置密碼為WHJH1308。322用WHJH登錄系統(tǒng)修改密碼323修改用戶配置文件用WHJH用戶登錄，用VI命令編輯文件/HOME/WHJH/PROFILE。VI/HOME/WHJH/PROFILE文件內(nèi)容如下PATH/USR/BIN/ETC/USR/SBIN/USR/UCBHOME/BIN/USR/BIN/X11/SBINEXPORTPATHIFS“MAIL“THISISATSHELLSTARTUPINNORMALTHENECHO“MAILMSG“OPERATION,THESHELLCHECKSFIPERIODICALLYTHEFOLLOWINGTHREELINESHAVEBEENADDEDBYUDBDB2IFF/HOME/DB2INST1/SQLLIB/DB2PROFILETHEN/HOME/DB2INST1/SQLLIB/DB2PROFILEFI324賦予用戶連接數(shù)據(jù)庫(kù)權(quán)限用數(shù)據(jù)庫(kù)實(shí)例用戶DB2INST1登陸服務(wù)器，執(zhí)行下列命令，賦予WHJH用戶連接數(shù)據(jù)庫(kù)的權(quán)利DB2CONNECTTOINTEDBDB2GRANTCONNECTONDATABASETOUSERWHJH325賦予用戶LOAD權(quán)限INFORMATICAPOWERCENTER對(duì)表進(jìn)行插入操作時(shí)，要求用戶有LOAD權(quán)限，賦予WHJH用戶LOAD權(quán)限的語(yǔ)句如下GRANTLOADONDATABASETOUSERWHJH326建立數(shù)據(jù)庫(kù)模式建立數(shù)據(jù)庫(kù)模式DB2CREATESCHEMAWHJH327賦予用戶操作表的權(quán)限執(zhí)行下列命令，賦予用戶WHJH操作表的權(quán)利DB2GRANTSELECT,INSERT,UPDATE,DELETE,ALTER,INDEX,REFERENCESONTABLETBL_NAMETOUSERWHJHDB2GRANTSELECT,INSERT,UPDATE,DELETE,ALTER,INDEX,REFERENCESONTABLEB_A06TOUSERWHJHDB2GRANTSELECT,INSERT,UPDATE,DELETE,ALTER,INDEX,REFERENCESONTABLEB_AE01_INPAYTOUSERWHJHDB2GRANTSELECT,INSERT,UPDATE,DELETE,ALTER,INDEX,REFERENCESONTABLEB_AE01_INREMITTOUSERWHJHDB2GRANTSELECT,INSERT,UPDATE,DELETE,ALTER,INDEX,REFERENCESONTABLEB_AE01_OUTPAYTOUSERWHJHDB2GRANTSELECT,INSERT,UPDATE,DELETE,ALTER,INDEX,REFERENCESONTABLEB_AE01_OUTREMITTOUSERWHJHDB2GRANTSELECT,INSERT,UPDATE,DELETE,ALTER,INDEX,REFERENCESONTABLEB_AE02_OUTPAYTOUSERWHJHDB2GRANTSELECT,INSERT,UPDATE,DELETE,ALTER,INDEX,REFERENCESONTABLEB_AE02_OUTREMITTOUSERWHJHDB2GRANTSELECT,INSERT,UPDATE,DELETE,ALTER,INDEX,REFERENCESONTABLEB_AE05TOUSERWHJHDB2GRANTSELECT,INSERT,UPDATE,DELETE,ALTER,INDEX,REFERENCESONTABLEB_AE06TOUSERWHJHDB2GRANTSELECT,INSERT,UPDATE,DELETE,ALTER,INDEX,REFERENCESONTABLEB_BD01TOUSERWHJHDB2GRANTSELECT,INSERT,UPDATE,DELETE,ALTER,INDEX,REFERENCESONTABLEB_BD01_TMPTOUSERWHJHDB2GRANTSELECT,INSERT,UPDATE,DELETE,ALTER,INDEX,REFERENCESONTABLEB_BD02TOUSERWHJHDB2GRANTSELECT,INSERT,UPDATE,DELETE,ALTER,INDEX,REFERENCESONTABLEB_BD02_TMPTOUSERWHJHDB2GRANTSELECT,INSERT,UPDATE,DELETE,ALTER,INDEX,REFERENCESONTABLEB_BD06TOUSERWHJHDB2GRANTSELECT,INSERT,UPDATE,DELETE,ALTER,INDEX,REFERENCESONTABLEB_BD06_TMPTOUSERWHJHDB2GRANTSELECT,INSERT,UPDATE,DELETE,ALTER,INDEX,REFERENCESONTABLEB_BE_INCOMETOUSERWHJHDB2GRANTSELECT,INSERT,UPDATE,DELETE,ALTER,INDEX,REFERENCESONTABLEB_BE01TOUSERWHJHDB2GRANTSELECT,INSERT,UPDATE,DELETE,ALTER,INDEX,REFERENCESONTABLEB_BH01TOUSERWHJHDB2GRANTSELECT,INSERT,UPDATE,DELETE,ALTER,INDEX,REFERENCESONTABLEB_BH02TOUSERWHJHDB2GRANTSELECT,INSERT,UPDATE,DELETE,ALTER,INDEX,REFERENCESONTABLEB_BH06TOUSERWHJHDB2GRANTSELECT,INSERT,UPDATE,DELETE,ALTER,INDEX,REFERENCESONTABLEC_C02TOUSERWHJHDB2GRANTSELECT,INSERT,UPDATE,DELETE,ALTER,INDEX,REFERENCESONTABLEC_C02_TMPTOUSERWHJHDB2GRANTSELECT,INSERT,UPDATE,DELETE,ALTER,INDEX,REFERENCESONTABLETBL_AREACODETOUSERWHJHDB2GRANTSELECT,INSERT,UPDATE,DELETE,ALTER,INDEX,REFERENCESONTABLETBL_BANKATTRTOUSERWHJHDB2GRANTSELECT,INSERT,UPDATE,DELETE,ALTER,INDEX,REFERENCESONTABLETBL_BANKINFOTOUSERWHJHDB2GRANTSELECT,INSERT,UPDATE,DELETE,ALTER,INDEX,REFERENCESONTABLETBL_BANKINFO_TESTTOUSERWHJHDB2GRANTSELECT,INSERT,UPDATE,DELETE,ALTER,INDEX,REFERENCESONTABLETBL_BRANCH_REFTOUSERWHJHDB2GRANTSELECT,INSERT,UPDATE,DELETE,ALTER,INDEX,REFERENCESONTABLETBL_BRANCH_REF_TMPTOUSERWHJHDB2GRANTSELECT,INSERT,UPDATE,DELETE,ALTER,INDEX,REFERENCESONTABLETBL_BRANCHINFOTOUSERWHJHDB2GRANTSELECT,INSERT,UPDATE,DELETE,ALTER,INDEX,REFERENCESONTABLETBL_BRANCHINFO_CHECKTOUSERWHJHDB2GRANTSELECT,INSERT,UPDATE,DELETE,ALTER,INDEX,REFERENCESONTABLETBL_BRANCHINFO_DELAYTOUSERWHJHDB2GRANTSELECT,INSERT,UPDATE,DELETE,ALTER,INDEX,REFERENCESONTABLETBL_BRANCHINFO_OTHTOUSERWHJHDB2GRANTSELECT,INSERT,UPDATE,DELETE,ALTER,INDEX,REFERENCESONTABLETBL_BRANCHINFO_TMPTOUSERWHJHDB2GRANTSELECT,INSERT,UPDATE,DELETE,ALTER,INDEX,REFERENCESONTABLETBL_CCY_REFTOUSERWHJHDB2GRANTSELECT,INSERT,UPDATE,DELETE,ALTER,INDEX,REFERENCESONTABLETBL_CCYCODETOUSERWHJHDB2GRANTSELECT,INSERT,UPDATE,DELETE,ALTER,INDEX,REFERENCESONTABLETBL_CCYRATE_TMP1TOUSERWHJHDB2GRANTSELECT,INSERT,UPDATE,DELETE,ALTER,INDEX,REFERENCESONTABLETBL_CCYRATE_TMP2TOUSERWHJHDB2GRANTSELECT,INSERT,UPDATE,DELETE,ALTER,INDEX,REFERENCESONTABLETBL_CCYRATE_TMP3TOUSERWHJHDB2GRANTSELECT,INSERT,UPDATE,DELETE,ALTER,INDEX,REFERENCESONTABLETBL_CCYRATE_TMP4TOUSERWHJHDB2GRANTSELECT,INSERT,UPDATE,DELETE,ALTER,INDEX,REFERENCESONTABLETBL_CCYRATE_TMP5TOUSERWHJHDB2GRANTSELECT,INSERT,UPDATE,DELETE,ALTER,INDEX,REFERENCESONTABLETBL_CCYRATE_TMP6TOUSERWHJHDB2GRANTSELECT,INSERT,UPDATE,DELETE,ALTER,INDEX,REFERENCESONTABLETBL_CCYRATE_TMP7TOUSERWHJHDB2GRANTSELECT,INSERT,UPDATE,DELETE,ALTER,INDEX,REFERENCESONTABLETBL_CCYRATE_TMP8TOUSERWHJHDB2GRANTSELECT,INSERT,UPDATE,DELETE,ALTER,INDEX,REFERENCESONTABLETBL_CCYRATE_TMP9TOUSERWHJHDB2GRANTSELECT,INSERT,UPDATE,DELETE,ALTER,INDEX,REFERENCESONTABLETBL_CCYRATEHISTOUSERWHJHDB2GRANTSELECT,INSERT,UPDATE,DELETE,ALTER,INDEX,REFERENCESONTABLETBL_CCYRATEHIS_BAKTOUSERWHJHDB2GRANTSELECT,INSERT,UPDATE,DELETE,ALTER,INDEX,REFERENCESONTABLETBL_CHECK_LOGTOUSERWHJHDB2GRANTSELECT,INSERT,UPDATE,DELETE,ALTER,INDEX,REFERENCESONTABLETBL_CODEBANKTOUSERWHJHDB2GRANTSELECT,INSERT,UPDATE,DELETE,ALTER,INDEX,REFERENCESONTABLETBL_CODEBANK_RESULTTOUSERWHJHDB2GRANTSELECT,INSERT,UPDATE,DELETE,ALTER,INDEX,REFERENCESONTABLETBL_CODEBRANCH_OTHERSTOUSERWHJHDB2GRANTSELECT,INSERT,UPDATE,DELETE,ALTER,INDEX,REFERENCESONTABLETBL_CODECUSTOMERTOUSERWHJHDB2GRANTSELECT,INSERT,UPDATE,DELETE,ALTER,INDEX,REFERENCESONTABLETBL_COUNTRYTOUSERWHJHDB2GRANTSELECT,INSERT,UPDATE,DELETE,ALTER,INDEX,REFERENCESONTABLETBL_COUNTRY_REFTOUSERWHJHDB2GRANTSELECT,INSERT,UPDATE,DELETE,ALTER,INDEX,REFERENCESONTABLETBL_CUSTOM_RPTTOUSERWHJHDB2GRANTSELECT,INSERT,UPDATE,DELETE,ALTER,INDEX,REFERENCESONTABLETBL_CUSTOM_RPT_WSTOUSERWHJHDB2GRANTSELECT,INSERT,UPDATE,DELETE,ALTER,INDEX,REFERENCESONTABLETBL_CUSTOMERBANKTOUSERWHJHDB2GRANTSELECT,INSERT,UPDATE,DELETE,ALTER,INDEX,REFERENCESONTABLETBL_CUSTOMERBANK_TMPTOUSERWHJHDB2GRANTSELECT,INSERT,UPDATE,DELETE,ALTER,INDEX,REFERENCESONTABLETBL_CUSTOMERINFOTOUSERWHJHDB2GRANTSELECT,INSERT,UPDATE,DELETE,ALTER,INDEX,REFERENCESONTABLETBL_CUSTOMERINFO_CHECKTOUSERWHJHDB2GRANTSELECT,INSERT,UPDATE,DELETE,ALTER,INDEX,REFERENCESONTABLETBL_CUSTOMERINFO_DELAYTOUSERWHJHDB2GRANTSELECT,INSERT,UPDATE,DELETE,ALTER,INDEX,REFERENCESONTABLETBL_CUSTOMERINFO_JIMMYTOUSERWHJHDB2GRANTSELECT,INSERT,UPDATE,DELETE,ALTER,INDEX,REFERENCESONTABLETBL_CUSTOMERINFO_TMPTOUSERWHJHDB2GRANTSELECT,INSERT,UPDATE,DELETE,ALTER,INDEX,REFERENCESONTABLETBL_CUSTOMSTOUSERWHJHDB2GRANTSELECT,INSERT,UPDATE,DELETE,ALTER,INDEX,REFERENCESONTABLETBL_CUSTOMS_TMPTOUSERWHJHDB2GRANTSELECT,INSERT,UPDATE,DELETE,ALTER,INDEX,REFERENCESONTABLETBL_DISPOSE_CTLTOUSERWHJHDB2GRANTSELECT,INSERT,UPDATE,DELETE,ALTER,INDEX,REFERENCESONTABLETBL_ECONTYPETOUSERWHJHDB2GRANTSELECT,INSERT,UPDATE,DELETE,ALTER,INDEX,REFERENCESONTABLETBL_ECONTYPE_REFTOUSERWHJHDB2GRANTSELECT,INSERT,UPDATE,DELETE,ALTER,INDEX,REFERENCESONTABLETBL_EXPORT_CTLTOUSERWHJHDB2GRANTSELECT,INSERT,UPDATE,DELETE,ALTER,INDEX,REFERENCESONTABLETBL_EXPORT_LOGTOUSERWHJHDB2GRANTSELECT,INSERT,UPDATE,DELETE,ALTER,INDEX,REFERENCESONTABLETBL_HUYKTOUSERWHJHDB2GRANTSELECT,INSERT,UPDATE,DELETE,ALTER,INDEX,REFERENCESONTABLETBL_IDEL_CTLTOUSERWHJHDB2GRANTSELECT,INSERT,UPDATE,DELETE,ALTER,INDEX,REFERENCESONTABLETBL_INCOMETOUSERWHJHDB2GRANTSELECT,INSERT,UPDATE,DELETE,ALTER,INDEX,REFERENCESONTABLETBL_INCOME_DELTOUSERWHJHDB2GRANTSELECT,INSERT,UPDATE,DELETE,ALTER,INDEX,REFERENCESONTABLETBL_INCOME_IN_CHECKTOUSERWHJHDB2GRANTSELECT,INSERT,UPDATE,DELETE,ALTER,INDEX,REFERENCESONTABLETBL_INCOME_IN_DELAYTOUSERWHJHDB2GRANTSELECT,INSERT,UPDATE,DELETE,ALTER,INDEX,REFERENCESONTABLETBL_INCOME_OUT_CHECKTOUSERWHJHDB2GRANTSELECT,INSERT,UPDATE,DELETE,ALTER,INDEX,REFERENCESONTABLETBL_INCOME_OUT_DELAYTOUSERWHJHDB2GRANTSELECT,INSERT,UPDATE,DELETE,ALTER,INDEX,REFERENCESONTABLETBL_INCOME_TMPTOUSERWHJHDB2GRANTSELECT,INSERT,UPDATE,DELETE,ALTER,INDEX,REFERENCESONTABLETBL_INCOME_TMP_TMPTOUSERWHJHDB2GRANTSELECT,INSERT,UPDATE,DELETE,ALTER,INDEX,REFERENCESONTABLETBL_INCOME_TMP_USDTESTTOUSERWHJHDB2GRANTSELECT,INSERT,UPDATE,DELETE,ALTER,INDEX,REFERENCESONTABLETBL_INDUSTRYTOUSERWHJHDB2GRANTSELECT,INSERT,UPDATE,DELETE,ALTER,INDEX,REFERENCESONTABLETBL_INDUSTRY_REFTOUSERWHJHDB2GRANTSELECT,INSERT,UPDATE,DELETE,ALTER,INDEX,REFERENCESONTABLETBL_INEXPORTTOUSERWHJHDB2GRANTSELECT,INSERT,UPDATE,DELETE,ALTER,INDEX,REFERENCESONTABLETBL_INEXPORT_DELTOUSERWHJHDB2GRANTSELECT,INSERT,UPDATE,DELETE,ALTER,INDEX,REFERENCESONTABLETBL_INEXPORT_TMPTOUSERWHJHDB2GRANTSELECT,INSERT,UPDATE,