DB常用命令大全列表.docVIP

DB2常用命令大全列表 登陆电子对帐数据库22.5.233.142 db2 connect to ebill user ebank using ebank 登陆公司网银数据库22.5.233.142 db2 connect to ebank5 user ebank using ebank 备份表 db2 export to EBC_BILL_LIST_2007_7.ixf of ixf select * from EBC_BILL_LIST where EBL_BILL_SIGNBACK_FLAG = 1 and YEAR(EBL_CREATE_DATE) = 2007 and MONTH(EBL_CREATE_DATE) = 7 导入数据 db2 import from EBC_BILL_LIST_2007_7.ixf of ixf replace into EBC_BILL_LIST 导出建库表的SQL db2look -d ebank5 -a -e -x -o creatab.sql 用db2move将数据备份出来 db2move ebank5 export 导入数据库所有的数据 db2move ebank5 import 将数据导入新库中 db2move ebank5 load 运行存储过程 db2 call EB_UPDATE_STATESIGN(?) 其中？表示输入输出 sql语句中终止符换成@ db2 –tvf createdb.sql –td@ 解表 db2 get snapshot for locks on ebill db2 force application(上个语句等到的id) 连接数据库： connect to [数据库名] user [操作用户名] using [密码] 创建缓冲池(8K)： create bufferpool ibmdefault8k IMMEDIATE SIZE 5000 PAGESIZE 8 K ; 创建缓冲池(16K)(OA_DIVERTASKRECORD)： create bufferpool ibmdefault16k IMMEDIATE SIZE 5000 PAGESIZE 16 K ; 创建缓冲池(32K)(OA_TASK)： create bufferpool ibmdefault32k IMMEDIATE SIZE 5000 PAGESIZE 32 K ; 创建表空间： CREATE TABLESPACE exoatbs IN DATABASE PARTITION GROUP IBMDEFAULTGROUP PAGESIZE 8K MANAGED BY SYSTEM USING (/home/exoa2/exoacontainer) EXTENTSIZE 32 PREFETCHSIZE 16 BUFFERPOOL IBMDEFAULT8K OVERHEAD 24.10 TRANSFERRATE 0.90 DROPPED TABLE RECOVERY OFF; CREATE TABLESPACE exoatbs16k IN DATABASE PARTITION GROUP IBMDEFAULTGROUP PAGESIZE 16K MANAGED BY SYSTEM USING (/home/exoa2/exoacontainer16k ) EXTENTSIZE 32 PREFETCHSIZE 16 BUFFERPOOL IBMDEFAULT16K OVERHEAD 24.1 TRANSFERRATE 0.90 DROPPED TABLE RECOVERY OFF; CREATE TABLESPACE exoatbs32k IN DATABASE PARTITION GROUP IBMDEFAULTGROUP PAGESIZE 32K MANAGED BY SYSTEM USING (/home/exoa2/exoacontainer32k ) EXTENTSIZE 32 PREFETCHSIZE 16 BUFFERPOOL IBMDEFAULT32K OVERHEAD 24.1 TRANSFERRATE 0.90 DROPPED TABLE RECOVERY OFF; GRANT USE OF TABLESPACE exoatbs TO PUBLIC; GRANT USE OF TABLESPACE exoatbs16k TO PUBLIC; G