空间管理您的位置: 51Testing软件测试网 » 阿奔 » 日志

Db2命令大全

上一篇 / 下一篇 2009-11-15 08:37:09 / 个人分类：编程与其它

查看( 352 ) / 评论( 0 ) / 评分( 0 / 0 )

这篇写的好全啊，我是方便自己看，大家也可以看啊。

Db2命令大全

连接数据库：

connect to [数据库名] user [操作用户名] using [密码]

创建缓冲池(8K)：51Testing软件测试网 ?y(FS\

nm)Dtc!D R0     create bufferpool ibmdefault8k IMMEDIATE     SIZE 5000 PAGESIZE 8 K ;51Testing软件测试网1E%C!w9p#j.I
创建缓冲池(16K)(OA_DIVERTASKRECORD)：51Testing软件测试网+h,Ic7W7RT
     create bufferpool ibmdefault16k IMMEDIATE     SIZE 5000 PAGESIZE 16 K ;51Testing软件测试网3[&?ko`*S
创建缓冲池(32K)(OA_TASK)：
#J"q dDQ*C#|[0     create bufferpool ibmdefault32k IMMEDIATE     SIZE 5000 PAGESIZE 32 K ;51Testing软件测试网Q(]+qM+N

创建表空间：51Testing软件测试网*CwCB0I/f

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;

0uoYF7l2c&b2@p0 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;

Z$_X dX0GRANT USE OF TABLESPACE exoatbs TO PUBLIC;
Po0x/F7PQ|0GRANT USE OF TABLESPACE exoatbs16k TO PUBLIC;
j'Nc{r0GRANT USE OF TABLESPACE exoatbs32k TO PUBLIC;51Testing软件测试网'[Vv8mq1N

创建系统表空间：

F'k0eep,WG9d0 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;

n,F8TFu]W_;kd0 CREATE TEMPORARY TABLESPACE exoasystmp16k IN DATABASE PARTITION GROUP IBMTEMPGROUP PAGESIZE 16K MANAGED BY SYSTEM USING ('/home/exoa2/exoasystmp16k' ) EXTENTSIZE 32 PREFETCHSIZE 16 BUFFERPOOL IBMDEFAULT16K OVERHEAD 24.10 TRANSFERRATE 0.90 DROPPED TABLE RECOVERY OFF;

se^lNr F;h0 CREATE TEMPORARY TABLESPACE exoasystmp32k IN DATABASE PARTITION GROUP IBMTEMPGROUP PAGESIZE 32K MANAGED BY SYSTEM USING ('/home/exoa2/exoasystmp32k') EXTENTSIZE 32 PREFETCHSIZE 16 BUFFERPOOL IBMDEFAULT32K OVERHEAD 24.10 TRANSFERRATE 0.90 DROPPED TABLE RECOVERY OFF;51Testing软件测试网T\EJO#g

;fQ@U g5Z,R)\6fm"S(S01. 启动实例(db2inst1):

db2start

2. 停止实例(db2inst1):

db2stop

"n+kD%s{03. 列出所有实例(db2inst1)51Testing软件测试网)Lw M*ar

3Ydcr{r1T4Z0db2ilist

5.列出当前实例:

:zifL\,}0db2 get instance

DY#x+k;~J,pZwC-iE^04. 察看示例配置文件:

db2 get dbm cfg|more51Testing软件测试网N`1p*Oe

}JB9[ ln"X05. 更新数据库管理器参数信息:

,Q N-j;og-e ^/b0db2 update dbm cfg using para_name para_value51Testing软件测试网h#CPh|+b'C

qw9Wc3N'hRyP06. 创建数据库:51Testing软件测试网0SKps(DOo

db2 create db test

f8`%`*ey#ogo07. 察看数据库配置参数信息

db2 get db cfg for test|more

8. 更新数据库参数配置信息

ZbJ!Y]&|@d0db2 update db cfg for test using para_name para_value

10.删除数据库:

1ct*IjH]0db2 drop db test

11.连接数据库51Testing软件测试网.bq:Q6_z1P

t+AAvB4V&_6{6|0db2 connect to test

12.列出所有表空间的详细信息。51Testing软件测试网?*xAEVm$g

2}$F,^0XSp0db2 list tablespaces show detail51Testing软件测试网;R,w;N^?"g

k,l(x2? CD'w%_@Mvf013.查询数据:

db2 select * from tb1

14.删除数据:51Testing软件测试网%Fl"r'Wf|+|/s

%x&^3tn a]0db2 delete from tb1 where id=1

A!w"S|KnX-?015.创建索引:51Testing软件测试网5V$P$_@T TL

)t{p{F-a6Qi_ fr0db2 create index idx1 on tb1(id);

16.创建视图:

db2 create view view1 as select id from tb151Testing软件测试网?"uhg{@;f

C:tyJ"X%XPj{017.查询视图:

c0f7[jk~)Q0db2 select * from view1

18.节点编目51Testing软件测试网L$J/Q0kFF S

e3Gv(Vr$k0db2 catalog tcp node node_name remote server_ip server server_port

19.察看端口号

1a:p2e-u'^d wU7E,^0db2 get dbm cfg|grep SVCENAME

20.测试节点的附接

db2 attach to node_name51Testing软件测试网6n'B*W0Q#iR ^

21.察看本地节点

db2 list node direcotry

22.节点反编目

T }U8V)OUJ0db2 uncatalog node node_name

23.数据库编目

db2 catalog db db_name as db_alias at node node_name51Testing软件测试网!lv?3W:w

24.察看数据库的编目

P)P@'lU^b Zf0db2 list db directory

h6`K @'A0n^1Ta-v4m025.连接数据库

-oSpibEu0db2 connect to db_alias user user_name using user_password

26.数据库反编目

db2 uncatalog db db_alias51Testing软件测试网1O8}7U'ca

lIKy}w7r:S027.导出数据

db2 export to myfile of ixf messages msg select * from tb151Testing软件测试网Lv6T `bRQ

28.导入数据

d {$Q S4}HN2O0db2 import from myfile of ixf messages msg replace into tb151Testing软件测试网4y]Sug~

29.导出数据库的所有表数据

gk8R)qG0db2move test export

fRK^_+mEBI0D030.生成数据库的定义

fj1T4^8a6Y yQN0db2look -d db_alias -a -e -m -l -x -f -o db2look.sql

@ r u,npF9l'H V031.创建数据库

db2 create db test151Testing软件测试网%n ^cCR(t-@

R|1v.clAK0a032.生成定义

]{9y]'T0db2 -tvf db2look.sql

0aHqzv!M9ZF7e033.导入数据库所有的数据

.LRl!\(TK1h0db2move db_alias import51Testing软件测试网y \ Pyu

5t/om6TE)g8QK034.重组检查

bTfLpR0db2 reorgchk

RN)ztX035.重组表tb151Testing软件测试网']\@ V u9Ld

i;s!_9F"d0c]0db2 reorg table tb1

,kYZTJB/tqv036.更新统计信息

^F6E }-vG.E6@U0db2 runstats on table tb1

*w(hsJ5MfOt!Ci037.备份数据库test

}.e*w Ib8yn/kg0db2 backup db test

38.恢复数据库test51Testing软件测试网D"q _ ck9i

w4ZSV p6g+A8yuX:m0db2 restore db test

399\.列出容器的信息

db2 list tablespace containers for tbs_id show detail51Testing软件测试网S(?rR?H

40.创建表:51Testing软件测试网pqR.h4\3h z

db2 ceate table tb1(id integer not null,name char(10))

41.列出所有表51Testing软件测试网!{)lW%s}K)\)WL

NO cXE2`:V3}0db2 list tables

42.插入数据:

'C5q!UqN)lGqn0db2 insert into tb1 values(1,’sam’);

UR"Y M}/I0db2 insert into tb2 values(2,’smitty’);51Testing软件测试网qY)xl"iFOn

. 建立数据库DB2_GCB51Testing软件测试网g3d"`!E dx5i

9x:aU*{L|B6q0CREATE DATABASE DB2_GCB ON G: ALIAS DB2_GCB

9j2b]7n6Pk&N0USING CODESET GBK TERRITORY CN COLLATE USING SYSTEM DFT_EXTENT_SZ 32

2. 连接数据库

d#o?Z0?*d0connect to sample1 user db2admin using 8301206

3. 建立别名51Testing软件测试网^c8J#b]]I

6^ m1}zI k8c2[]0create alias db2admin.tables for sysstat.tables;

CREATE ALIAS DB2ADMIN.VIEWS FOR SYSCAT.VIEWS

create alias db2admin.columns for syscat.columns;

-A5KWcPj!m0create alias guest.columns for syscat.columns;

s&~5J4lo([-ju.[C04. 建立表

create table zjt_tables as

(select * from tables) definition only;

create table zjt_views as

(select * from views) definition only;

,sI?Z|%p05. 插入记录51Testing软件测试网E!x IC0M(T

k)M*u$O-D!tdG0insert into zjt_tables select * from tables;

sgKOL[6w'V*v7e0insert into zjt_views select * from views;51Testing软件测试网7I5aC V#n

6. 建立视图

0`B BN4|1A)hL5U0create view V_zjt_tables as select tabschema,tabname from zjt_tables;

7. 建立触发器

CREATE TRIGGER zjt_tables_del51Testing软件测试网*fY6v#T @7FK

AFTER DELETE ON zjt_tables

(IEr3KfF0REFERENCING OLD AS O

brC]7O^0FOR EACH ROW MODE DB2SQL

;Dws I3m"CQlw'l0Insert into zjt_tables1 values(substr(o.tabschema,1,8),substr(o.tabname,1,10))

)hfCVF*r.t\08. 建立唯一性索引

{m,HDC ^j0CREATE UNIQUE INDEX I_ztables_tabname

[size=3]ON zjt_tables(tabname);

9. 查看表

0l-^ U#~,y$Cc'C0^0select tabname from tables51Testing软件测试网 q0z2J X7]

][lPw0where tabname='ZJT_TABLES';51Testing软件测试网'W }v LW

10. 查看列51Testing软件测试网p~E)PW\

select SUBSTR(COLNAME,1,20) as 列名,TYPENAME as 类型,LENGTH as 长度

_p+ds3C3k5n"J j0from columns

where tabname='ZJT_TABLES';

11. 查看表结构

"E$wA+t1m$U0db2 describe table user1.department51Testing软件测试网(v7[(nI)z

Z#B6}4n'FB0db2 describe select * from user.tables

12. 查看表的索引51Testing软件测试网[ b&@ Y]-Pv

;aKcQ4Q)hvQ n%b0db2 describe indexes for table user1.department

,WFSAbh013. 查看视图

K.qKv8` w0select viewname from views

#ma7l%Gg)x:Xq0where viewname='V_ZJT_TABLES';

$PP:uUfAaI;O014. 查看索引

9D"lNcqK0select indname from indexes

where indname='I_ZTABLES_TABNAME';51Testing软件测试网&GQ-m2U*z ~6z

15. 查看存贮过程51Testing软件测试网bvK"Fnb,?B

&b zy;JVm7e0SELECT SUBSTR(PROCSCHEMA,1,15),SUBSTR(PROCNAME,1,15)

&Gqad"UxLKp0FROM SYSCAT.PROCEDURES;51Testing软件测试网)oK$z`;Jy#K(V

&{tI:lF!sO.z016. 类型转换(cast)

ip datatype:varchar

7mY Xa!}\-D_6@0select cast(ip as integer)+50 from log_comm_failed

ZE"so"o(S!cz017. 重新连接51Testing软件测试网 ?+h:u@R4a#^

9^o|f#q p0V0connect reset

18. 中断数据库连接

F*a W!R ZTI0disconnect db2_gcb

19. view application51Testing软件测试网"|`#kQa7N8E]

F!M/]#An^s1o&Tb0LIST APPLICATION;51Testing软件测试网WyiN |8ka

20. kill application

FORCE APPLICATION(0);

?&pc5{r'y0db2 force applications all (强迫所有应用程序从数据库断开)

$t6_q Op [021. lock table

lock table test in exclusive mode

Ki/`}8Xv022. 共享

%W0E;c4NOf sd(E0lock table test in share mode

23. 显示当前用户所有表

(M7t*T8Y.teNyQ$N&p0list tables

24. 列出所有的系统表

list tables for system

p%Z W9x%^B'P025. 显示当前活动数据库51Testing软件测试网9g$?jVl

list active databases51Testing软件测试网,_YJjR#V

26. 查看命令选项

z&a&|F#F%[%P]a0list command options

27. 系统数据库目录

LIST DATABASE DIRECTORY

!?7}!E/PX7hO _028. 表空间

list tablespaces

29. 表空间容器

LIST TABLESPACE CONTAINERS FOR

v#koS-x6q0Example: LIST TABLESPACE CONTAINERS FOR 1

aF;gO/go(^030. 显示用户数据库的存取权限

7|~,ip2t-X0GET AUTHORIZATIONS51Testing软件测试网ws6YEG

31. 启动实例

DB2START51Testing软件测试网,N&TzV&L8bO

0~VyV+G b032. 停止实例

L*A\,zM |W0db2stop

@5B3b A-] wzF}_033. 表或视图特权

grant select,delete,insert,update on tables to user

grant all on tables to user WITH GRANT OPTION

c$odTHj[|034. 程序包特权

GRANT EXECUTE51Testing软件测试网O-w4QgX(NU

ON PACKAGE PACKAGE-name51Testing软件测试网wth-ypg

TO PUBLIC

l'D5NU-A!z035. 模式特权

A9l!cDz)NZ?0GRANT CREATEIN ON SCHEMA SCHEMA-name TO USER51Testing软件测试网v1MPi/iB

36. 数据库特权

4zPM p(rh0grant connect,createtab,dbadm on database to user

E*gY2x5i7\037. 索引特权

grant control on index index-name to user

38. 信息帮助 (? XXXnnnnn )

例:? SQL30081

39. SQL 帮助(说明 SQL 语句的语法)51Testing软件测试网`$S9e'zc*h1B

help statement51Testing软件测试网2oyaZ6ab|G

例如，help SELECT

40. SQLSTATE 帮助(说明 SQL 的状态和类别代码)

6@5gTkG5gyC0? sqlstate 或 ? class-code

L_p1@ A Xr.oZ041. 更改与"管理服务器"相关的口令51Testing软件测试网%[4~Btg%xV

db2admin setid username password

42. 创建 SAMPLE 数据库

db2sampl51Testing软件测试网:f*Er3g}7_(P

}`S$L`3E0db2sampl F:(指定安装盘)51Testing软件测试网!d,\~DV\$B

43. 使用操作系统命令

! dir

44. 转换数据类型 (cast)

SELECT EMPNO, CAST(RESUME AS VARCHAR(370))51Testing软件测试网rpV1Xnab

FROM EMP_RESUME

h7]b5Uouy(e0WHERE RESUME_FORMAT = 'ascii'51Testing软件测试网*GEtZt;q%L

f!E)TF![?oj.wT045. UDF

要运行 DB2 Java 存储过程或 UDF，还需要更新服务器上的 DB2 数据库管理程序配置，以包括在该机器上安装 JDK 的路径51Testing软件测试网:M.~6o5{-j

db2 update dbm cfg using JDK11_PATH d:sqllibjavajdk51Testing软件测试网D$Z q2D8L2v0R

5Db {8M*V P8t@0TERMINATE

update dbm cfg using SPM_NAME sample

46. 检查 DB2 数据库管理程序配置

-B K[N'h%AB0db2 get dbm cfg

47. 检索具有特权的所有授权名51Testing软件测试网6{*C4d$Mf7I

SELECT DISTINCT GRANTEE, GRANTEETYPE, 'DATABASE' FROM SYSCAT.DBAUTH

UNION

SELECT DISTINCT GRANTEE, GRANTEETYPE, 'TABLE ' FROM SYSCAT.TABAUTH51Testing软件测试网:Sv6\W1P'GMl

UNION

SELECT DISTINCT GRANTEE, GRANTEETYPE, 'PACKAGE ' FROM SYSCAT.PACKAGEAUTH51Testing软件测试网*`CRpI@

UNION51Testing软件测试网!N N;x2CP%RS

K2x9}#Zt"g(| J}Z0SELECT DISTINCT GRANTEE, GRANTEETYPE, 'INDEX ' FROM SYSCAT.INDEXAUTH51Testing软件测试网)Mk8@q%F${P

:NaX3t8]'I0UNION

SELECT DISTINCT GRANTEE, GRANTEETYPE, 'COLUMN ' FROM SYSCAT.COLAUTH

zAGy TW0UNION

^Zp!i7k2f }0SELECT DISTINCT GRANTEE, GRANTEETYPE, 'SCHEMA ' FROM SYSCAT.SCHEMAAUTH

7{T2KtXa"H0E0J#^0UNION

@Cbg!_7?0r0SELECT DISTINCT GRANTEE, GRANTEETYPE, 'SERVER ' FROM SYSCAT.PASSTHRUAUTH

6l)E T3H.bZcfsA0ORDER BY GRANTEE, GRANTEETYPE, 3

0V7Hodv0create table yhdab

(id varchar(10),

O\ H#P:n0password varchar(10),51Testing软件测试网S/W5CI9K0{

ywlx varchar(10),

O OHS,U,inz E ^.]0kh varchar(10));

4ijlbD.XY8@b0create table ywlbb

qg&xH5cOb(k5r0(ywlbbh varchar(8),

ywmc varchar(60))

48. 修改表结构

alter table yhdab ALTER kh SET DATA TYPE varchar(13);

alter table yhdab ALTER ID SET DATA TYPE varchar(13);

#v2YPe;}wMu0alter table lst_bsi alter bsi_money set data type int;

7l2E&@i%t6LZ6`L[0insert into yhdab values

('20000300001','123456','user01','20000300001'),

'E C(f9VX6{W/Sj0('20000300002','123456','user02','20000300002');51Testing软件测试网9x3T4HG8U P,C

49. 业务类型说明

insert into ywlbb values

g2S6sW:Z%W;nP$th0('user01','业务申请'),

)u1I'y%VX:~Xa2x3B9}c0('user02','业务撤消'),51Testing软件测试网D A0I0w"nWE2j

r4fWU:{Y\(r V'h.z0('user03','费用查询'),

('user04','费用自缴'),51Testing软件测试网s#zjDEF

e,vHq0H0('user05','费用预存'),

zyU)P v9\3sZ1O0('user06','密码修改'),

(MX Ik{f0('user07','发票打印'),

('gl01','改用户基本信息'),51Testing软件测试网*G$Z nV$dV

fYB%b`/k3n*?0('gl02','更改支付信息'),51Testing软件测试网?D)txuQ

('gl03','日统计功能'),51Testing软件测试网 CEhklI.X

3eC1L"e.\~0('gl04','冲帐功能'),

\j.lj_0('gl05','对帐功能'),

tX2wB9yc$z3@0('gl06','计费功能'),

('gl07','综合统计')51Testing软件测试网/Uxx"vW s

备份数据库：
:h6LmiZU6[m A,H0{0CONNECT TO EXOA;
QUIESCE DATABASE IMMEDIATE FORCE CONNECTIONS;
CONNECT RESET;
BACKUP DATABASE EXOA TO "/home/exoa2/db2bak/" WITH 2 BUFFERS BUFFER 1024 PARALLELISM 1 WITHOUT PROMPTING;51Testing软件测试网$t8L \ IW*A V
CONNECT TO EXOA;
UNQUIESCE DATABASE;51Testing软件测试网^zE9[)s
CONNECT RESET;51Testing软件测试网+b:T!j+Zp

?4@OV B!g ml,\m4fZ0以下是小弟在使用db2move中的一些经验，希望对大家有所帮助。

'H*e z`D7a~o$K0db2 connect to YOURDB
AC.z'Z JfH0连接数据库51Testing软件测试网k:C.o;dm1_1[

%e"^:m0V6w$T0db2look -d YOURDB -a -e -x -o creatab.sql
0m\W~$l*c5D aM;X(g*{0导出建库表的SQL

db2move YOURDB export51Testing软件测试网$e(nHPv _Pw-P
用db2move将数据备份出来

c`3G Ul7b)A0vi creatab.sql51Testing软件测试网-_F'p1U x
如要导入的数据库名与原数据库不同，要修改creatab.sql中CONNECT 项51Testing软件测试网+c[5_"E&g9b
如相同则不用更改51Testing软件测试网S:_|+?Ksl(n

"v3@oQ.J0db2move NEWDB load
6`nr&A0Z1j0将数据导入新库中

在导入中可能因为种种原因发生中断，会使数据库暂挂51Testing软件测试网"F0eY-}b t
db2       list tablespaces      show      detail51Testing软件测试网 W;BK cV$L%[
如：51Testing软件测试网/t7b._6L8HV_
         详细说明：
V6K%Lat KS0        装入暂挂51Testing软件测试网.UVA/LGY#XD
总页数                             = 165251Testing软件测试网C\!\IiC_e
可用页数                           = 1652
已用页数                            = 1652
:URP.n)l!rjrFx0空闲页数                            = 不适用
A(gp(o2k4F0高水位标记（页）                    = 不适用
;D|3lNUp,I0页大小（字节）                      = 4096
s v xyph3~0盘区大小（页）                      = 32
预读取大小（页）                    = 32
p$Krhh+B/Y4NO0容器数                              = 1
'ekt3D6_Zo9pp0状态更改表空间标识                       = 2
状态更改对象标识                         = 59

db2 select tabname,tableid from syscat.tables where tableid=59
3m ]2N J5Pj0查看是哪张表挂起51Testing软件测试网+Q"Yay2d

表名知道后到db2move.lst(在db2move YOURDB export的目录中)中找到相应的.ixf文件
xe3[?!Y0db2 load from tab11.ixf of ixf terminate into db2admin.xxxxxxxxx
4lhG4lMd-]2Y0tab11.ixf对应的是xxxxxxxxx表

0Q/uk+TxL|~0数据库会恢复正常，可再用db2 list tablespaces show detail查看51Testing软件测试网-al`t5sH

30.不能通过GRANT授权的权限有哪种?

SYSAM

SYSCTRL51Testing软件测试网 Y$Fn(P.WP

jO0o o)_X l0SYSMAINT51Testing软件测试网4a? v/lo

['s9HtEh5T0要更该述权限必须修改数据库管理器配置参数

j LZ[ uFF!a7\F7u4`031.表的类型有哪些?

永久表(基表)

F7[s\'rHKx0临时表(说明表)51Testing软件测试网[To7Mt

9l&_I1q_;tm5g5iD"h0临时表(派生表)

'|9n1IA ^7~0f032.如何知道一个用户有多少表?51Testing软件测试网9[?w2s ad

SELECT * FROM SYSIBM.SYSTABLES WHERE CREATOR='USER'

33.如何知道用户下的函数?

select * from IWH.USERFUNCTION

|'C#K8^{x0select * from sysibm.SYSFUNCTIONS

34.如何知道用户下的VIEW数?

select * from sysibm.sysviewsWHERECREATOR='USER'

35.如何知道当前DB2的版本?

select * from sysibm.sysvERSIONS51Testing软件测试网JS:@Csu

36.如何知道用户下的TRIGGER数?

eSDQ;E wx6GP0select * from sysibm.SYSTRIGGERSWHERESCHEMA='USER'51Testing软件测试网,u_J@u9c

'~3K,K6Y2MP)Lx037.如何知道TABLESPACE的状况?

oA$J$X`V;W4t0select * from sysibm.SYSTABLESPACES

SJ0G,L$CA038.如何知道SEQUENCE的状况?

select * from sysibm.SYSSEQUENCES51Testing软件测试网3GHHr6zZ} y

0CCVD?.@O W m.a039.如何知道SCHEMA的状况?

select * from sysibm.SYSSCHEMATA51Testing软件测试网)I.xgJ!]v

40.如何知道INDEX的状况?

_A,Lyr N0select*fromsysibm.SYSINDEXES

41.如何知道表的字段的状况?

select*fromsysibm.SYSCOLUMNSWHERETBNAME='AAAA'51Testing软件测试网*kN1f}e,Oi%|

@6jp&Y6hW0t042.如何知道DB2的数据类型?

select*from sysibm.SYSDATATYPES

43.如何知道BUFFERPOOLS状况?51Testing软件测试网Z8I8dB:?QM

|:`5S9}$]d3q*E H0select*from sysibm.SYSBUFFERPOOLS

44.DB2表的字段的修改限制?

,G"Vu-s"V&p!Sp!E ]lw0只能修改VARCHAR2类型的并且只能增加不能减少.

45.如何查看表的结构?

DESCRIBLE TABLE TABLE_NAME

w_5S0^:q M MR0OR

DESCRIBLE SELECT*FROM SCHEMA.TABLE_NAME

用户菜单

我的栏目

标题搜索

日历

数据统计

访问量: 19251
日志数: 34
图片数: 8
书签数: 11
建立时间: 2007-04-24
更新时间: 2010-11-09

Db2命令大全

相关阅读:

用户菜单

我的栏目

标题搜索

日历

我的存档

数据统计

RSS订阅