DB2安装以及建库参考

DB2安装以及建库参考JIMMY第一章DB2安装11前提条件1、在操作系统上创建下面用户和组用户用户ID组组IDDB2INST11001DB2IADM1999DB2FENC11002DB2FADM1998DASUSR11003DASADM19972、MOUNT光驱，便于使用安装介质，或者将安装软件FTP到服务器。3、查看/ETC/HOSTS文件，确认主机名和IP已经设置。4、如果是LINUX操作系统，检查是否安装了开发工具包“DEVELOPMENTTOOLS”、“XSOFTWAREDEVELOPMENT”、“LEGACYSOFTWAREDEVELOPMENT”，如果没有请安装。5、验证中文语言环境安装正确，以DB2INST1用户登录OS，运行下面命令LSALL如果文件日期显示为中文，说明中文语言环境正确。注以上操作可参照对应的操作系统手册。12DB2软件安装用ROOT用户将介质上传道服务器，用ROOT用户安装。1、以ROOT用户登录OS，进入安装文件所在目录，运行下面命令TARXVFC58SMLTARCD009_ESE_LNX_32_NLV/DB2_INSTALL此命令为从命令行进行安装DB2（如果权限不够则执行CHMODR777）SPECIFYONEORMOREOFTHEFOLLOWINGKEYWORDS,SEPARATEDBYSPACES,TOINSTALLDB2PRODUCTSKEYWORDPRODUCTDESCRIPTIONDB2ESEDB2ENTERPRISESERVEREDITIONFORLINUXDB2ADMCLDB2ADMINISTRATIONCLIENTFORLINUXDB2ADCLDB2APPLICATIONDEVELOPMENTCLIENTFORLINUXENTER“HELP“TOREDISPLAYPRODUCTNAMESENTER“QUIT“TOEXIT2、输入DB2ESE，按RETURN键运行结果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创建数据库管理服务器用ROOT用户操作CD/DB2安装目录/INSTANCE/DASCRTUDASUSR1用DASUSR1用户登录OSVIBASH_PROFILE/HOME/DASUSR1/DAS/DASPROFILE添加这一行代码（如果文件不存在则新建，位置在DASUSR1用户的缺省目录下，如HOME/DASUSR1/）14创建实例用ROOT用户操作CD/DB2安装目录/INSTANCE/DB2ICRTUDB2FENC1DB2INST1DBI1070IPROGRAMDB2ICRTCOMPLETEDSUCCESSFULLY15修改/ETC/SERVICES文件用ROOT用户操作修改/ETC/SERVICES文件LOCALSERVICESDB2INST150000/TCP增加该行代码16设置环境变量用DB2INST1用户操作161修改BASH_PROFILEVIBASH_PROFILE（如果文件不存在则新建，位置在DB2INST1用户的缺省目录下）/HOME/DB2INST1/SQLLIB/DB2PROFILE增加该行代码162163设置服务名称DB2UPDATEDBMCFGUSINGSVCENAMEDB2INST1DB20000ITHEUPDATEDATABASEMANAGERCONFIGURATIONCOMMANDCOMPLETEDSUCCESSFULLY注意这一步如出现问题，请参见常见问题这章的问题一来进行解决。164设置注册变量DB2SETDB2COMMTCPIP17启动实例DB2START12/26/200516213100SQL1063NDB2STARTPROCESSINGWASSUCCESSFULSQL1063NDB2STARTPROCESSINGWASSUCCESSFUL18DB2客户端安装181前提条件1、在操作系统上创建下面用户和组用户用户ID组组IDDB2INST11001DB2IADM19992、MOUNT光驱，便于使用安装介质，或者将安装软件FTP到服务器。182DB2软件安装用ROOT用户将介质上传到服务器，用ROOT用户安装。1、以ROOT用户登录OS，进入安装文件所在目录，运行下面命令CDDB2V91FORAIXLSLICENSE正版ESEMEDIAXLCCDESELSDISK1CDDISK1LSDB2DB2_INSTALLDB2SETUPDOCINSTALLFIXPACKPWD/HOME/DB2INST1/DB2V91FORAIX/ESE/DISK1/DB2_INSTALLKSH/DB2_INSTALL0403006执行许可权被拒绝。CHMODR777/DB2_INSTALL用于安装产品的缺省目录是/OPT/IBM/DB2/V91想要选择另一个目录来进行安装吗是否是输入安装目录的完整路径名/IBM/DB2CLIENT指定下面的一个或多个关键字（用空格分隔）以安装DB2产品。CLIENTRTCLESE输入“HELP“以重新显示产品名。输入“QUIT“以退出。CLIENT正在初始化DB2安装。要执行的任务总数为30要执行的所有任务的总估计时间为578任务1启动描述正在启用异步I/O估计时间2秒任务1结束任务2启动描述正在检查许可协议的接受情况估计时间1秒任务2结束任务3启动描述产品消息英语估计时间10秒任务3结束任务4启动描述基本客户机支持估计时间131秒任务4结束任务5启动描述IBMJAVATM软件开发包（SDK）估计时间81秒任务5结束任务6启动描述JAVA帮助（HTML）英语估计时间7秒任务6结束任务7启动描述SQL过程估计时间3秒任务7结束任务8启动描述ICU实用程序估计时间41秒任务8结束任务9启动描述JAVA支持估计时间6秒任务9结束任务10启动描述JAVA公共文件估计时间19秒任务10结束任务11启动描述SPATIALEXTENDER客户机估计时间6秒任务11结束任务12启动描述基本应用程序开发工具估计时间18秒任务12结束任务13启动描述复制工具估计时间13秒任务13结束任务14启动描述DB2LDAP支持估计时间4秒任务14结束任务15启动描述“DB2实例安装”向导估计时间4秒任务15结束任务16启动描述XMLEXTENDER估计时间10秒任务16结束任务17启动描述第一步估计时间3秒任务17结束任务18启动描述DB2客户机的产品特征符估计时间5秒任务18结束任务19启动描述DB2WEB工具估计时间12秒任务19结束任务20启动描述XMLEXTENDER样本估计时间3秒任务20结束任务21启动描述ADT样本程序估计时间21秒任务21结束任务22启动描述SPATIALEXTENDER样本估计时间3秒任务22结束任务23启动描述正在设置DB2库路径估计时间120秒任务23结束任务24启动描述正在执行控制任务估计时间20秒任务24结束任务25启动描述正在更新全局注册表估计时间20秒任务25结束任务26启动描述正在更新DB2LS链接估计时间1秒任务26结束任务27启动描述正在注册DB2许可证估计时间5秒任务27结束任务28启动描述正在设置缺省全局概要文件注册表变量估计时间1秒任务28结束任务29启动描述正在初始化实例列表估计时间5秒任务29结束任务30启动描述正在更新全局概要文件注册表估计时间3秒任务30结束已成功完成执行。有关更多信息，请参阅“/TMP/DB2_INSTALLLOG155660“上的DB2安装日志。183创建实例用ROOT用户操作CD/DB2安装目录/INSTANCE/DB2ICRTUDB2INST1DB2INST1DBI1070IPROGRAMDB2ICRTCOMPLETEDSUCCESSFULLY命令CD/IBM/CLICENTKSH/IBM/CLICENT找不到。/IBM/DB2CLIENTKSH/IBM/DB2CLIENT0403006执行许可权被拒绝。CD/IBMLSDB2CLIENTLOSTFOUNDCDDB2CLIENTLSMETADATABINCONVDOCINCLUDE32INSTANCELIB64PROFILESREGSECURITY64READMEBNDDB2XMLFUNCTIONINFOPOPJAVALICENSESAMPLESTIVREADYADMCFGDEFAULTENVINCLUDEINSTALLLIB32MSGSECURITY32TOOLSCDINSTANCELSCOMMONDB2ICKNMDB2IDEFSDB2IINFODB2IMIGRDB2ISETDB2ISTOPDB2IUPDTNATIVEDB2CKMIGDB2ICRTDB2IDROPDB2ILISTDB2INSTCFGDB2ISETUPDB2ISTRTDB2IUTILDB2CLPIDDB2IDBMDB2IEXECDB2IMCHKDB2IPCLDDB2ISRVDB2IUADMDB2UIT/DB2ICRTUDB2INST1DB2INST1DBI1070IPROGRAMDB2ICRTCOMPLETEDSUCCESSFULLY184编目、连接数据库SUDB2INST1DB2CATALOGTCPIPNODENODE58REMOTE10014858SERVER50000DB20000ITHECATALOGTCPIPNODECOMMANDCOMPLETEDSUCCESSFULLYDB21056WDIRECTORYCHANGESMAYNOTBEEFFECTIVEUNTILTHEDIRECTORYCACHEISREFRESHEDDB2TERMINATEDB20000ITHETERMINATECOMMANDCOMPLETEDSUCCESSFULLYDB2CATALOGDATABASEBIZATNODENODE58DB20000ITHECATALOGDATABASECOMMANDCOMPLETEDSUCCESSFULLYDB21056WDIRECTORYCHANGESMAYNOTBEEFFECTIVEUNTILTHEDIRECTORYCACHEISREFRESHEDDB2TERMINATEDB20000ITHETERMINATECOMMANDCOMPLETEDSUCCESSFULLYDB2CONNECTTOBIZUSERDB2ISNT1ENTERCURRENTPASSWORDFORDB2ISNT1SQL30082NSECURITYPROCESSINGFAILEDWITHREASON“24“USERNAMEAND/ORPASSWORDINVALID“SQLSTATE08001DB2CONNECTTOBIZDB2INST1SQL0104NANUNEXPECTEDTOKEN“DB2INST1“WASFOUNDFOLLOWING“EXPECTEDTOKENSMAYINCLUDE“USER“SQLSTATE42601DB2CONNECTTOBIZUSERDB2INST1ENTERCURRENTPASSWORDFORDB2INST1SQL0332NCHARACTERCONVERSIONFROMTHESOURCECODEPAGE“1386“TOTHETARGETCODEPAGE“819“ISNOTSUPPORTEDSQLSTATE57017DB2SETDB2SETDB2CODEPAGE1386DB2CONNECTTOBIZUSERDB2INST1ENTERCURRENTPASSWORDFORDB2INST1SQL0332NCHARACTERCONVERSIONFROMTHESOURCECODEPAGE“1386“TOTHETARGETCODEPAGE“819“ISNOTSUPPORTEDSQLSTATE57017DB2TERMINATEDB20000ITHETERMINATECOMMANDCOMPLETEDSUCCESSFULLYDB2SETDB2CODEPAGE1386DB2SETDB2CODEPAGE1386DB2CONNECTTOBIZUSERDB2INST1CDB2CONNECTTOBIZUSERDB2INST1ENTERCURRENTPASSWORDFORDB2INST1DATABASECONNECTIONINFORMATIONDATABASESERVERDB2/AIX64910SQLAUTHORIZATIONIDDB2INST1LOCALDATABASEALIASBIZ19DB2补丁安装191问题描述在一个启用并行性（INTRA_PARALLELENABLED）的系统（DBMS），在执行需要排序的查询时（例如，SELECTDISTINCT，ORDERBY，或者聚合操作）可能造成数据库崩溃。造成数据库崩溃的原因是启用并行性的时，可能发生重复释放同一个临时页面的情况。192解决方案1关闭并行性影响性能2打补丁DB2V91FIXPACK7193具体问题描述HTTP/WWW01IBMCOM/SUPPORT/DOCVIEWWSSRS71THEN/HOME/DB2INST1/SQLLIB/DB2PROFILEFI编辑文件/HOME/ZHKREAD/BASH_PROFILE，内容如下/HOME/DB2INST1/SQLLIB/DB2PROFILE313赋予用户连接数据库权限用数据库实例用户DB2INST1登陆服务器，执行下列命令，赋予ZHKREAD用户连接数据库的权利DB2GRANTCONNECTONDATABASETOUSERZHKREAD314建立数据库模式建立数据库模式DB2CREATESCHEMAZHKREAD315赋予用户查询权限执行下列命令，赋予查询权利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建立表别名执行下列命令建立表别名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生产环境用户切换321创建操作系统用户用ROOT用户登录系统，SMITUSER命令创建操作系统用户WHJH，设置密码为WHJH1308。322用WHJH登录系统修改密码323修改用户配置文件用WHJH用户登录，用VI命令编辑文件/HOME/WHJH/PROFILE。VI/HOME/WHJH/PROFILE文件内容如下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赋予用户连接数据库权限用数据库实例用户DB2INST1登陆服务器，执行下列命令，赋予WHJH用户连接数据库的权利DB2CONNECTTOINTEDBDB2GRANTCONNECTONDATABASETOUSERWHJH325赋予用户LOAD权限INFORMATICAPOWERCENTER对表进行插入操作时，要求用户有LOAD权限，赋予WHJH用户LOAD权限的语句如下GRANTLOADONDATABASETOUSERWHJH326建立数据库模式建立数据库模式DB2CREATESCHEMAWHJH327赋予用户操作表的权限执行下列命令，赋予用户WHJH操作表的权利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,