DB2SQL命令大全你绝对用的到.docVIP

DB2/SQL命令大全 QP[zo0b* ?zZ@IlVv ?5BKL ?NRAdp)06 ?连接数据库： , r2h {X ?QC+^orEh ?connect to [数据库名] user [操作用户名] using [密码] XG/6?s5} ?# ojE4v ?创建缓冲池(8K)： F(q8T}J ?u.}mnlHNX ?create bufferpool ibmdefault8k IMMEDIATE SIZE 5000 PAGESIZE 8 K ; 2#PV.q~+y ?创建缓冲池(16K)(OA_DIVERTASKRECORD)： s=x`tr/ ?create bufferpool ibmdefault16k IMMEDIATE SIZE 5000 PAGESIZE 16 K ; 7^=19/ ?创建缓冲池(32K)(OA_TASK)： 5%/ k ?create bufferpool ibmdefault32k IMMEDIATE SIZE 5000 PAGESIZE 32 K ; ,*I#,Gs ?4It0 k ?创建表空间： sn+h_O ?LBS5b);Zq ?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; -.}$L^+( ?Vm6{q8~T ?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; /F/gXri q ?B}*v!.LA ?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; 10^\6 A ?eEh*f]G^ ?GRANT USE OF TABLESPACE exoatbs TO PUBLIC; {S5}O9gD ?GRANT USE OF TABLESPACE exoatbs16k TO PUBLIC; ?qqwm Wa ?GRANT USE OF TABLESPACE exoatbs32k TO PUBLIC; x}-k 9z ?|Z F4% ?创建系统表空间： 4+[V k7+U ?U|H[
Qc
?CREATE TEMPORARY TABLESPACE exoasystmp IN DATABASE PARTITION GROUP IBMTEMPGROUP PAGESIZE 8K MANAGED BY SYSTEM USING (/home/exoa2/exoasystmp ? ) EXTENTSIZE 32 PREFETCHSIZE 16 BUFFERPOOL IBMDEFAULT8K OVERHEAD 24.10 TRANSFERRATE 0.90 DROPPED TABLE RECOVERY OFF; c:e!G*l2 ?7y2u)` ?CREATE TEMPORARY TABLESPACE exoasystmp16k IN DATABASE PARTITION GROUP IBMTEMPGROUP PAGESIZE 16K MANAGED BY