轻松掌握IBM DB2数据库的31个使用技巧

SELECT   *   FROM   SYSCAT.CHECKS   
WHERE   TABNAME   =   <tb_name>

SELECT   *   FROM   SYSCAT.REFERENCES   
WHERE   TABNAME   =   <tb_name>

select   *   from   SYSCAT.BUFFERPOOLS

db2   get   dbm   cfg

db2   update   dbm   cfg   using   参数名   新值

db2   update   db   cfg   for   
<db_name>   using   参数名   新值

create   bufferpool   <buf_name>   size   
<number   of   pages>   [pagesize   4096]   
{[not]   EXTENDED   STORAGE}

alter   bufferpool   <buf_name>   size   
<number   of   pages>   {[not]   EXTENDED   STORAGE}

drop       bufferpool   <buf_name>

select   *   from   tabschema.tabname   where   
(colA,   colB,   colC)   [not]   in   (values   
(valueA1,   valueB1,   valueC1),   
(valueA2,   valueB2,   valueC2),   
...(valueAn,   valueBn,   valueCn))

db2   list   application   [show   detail]

db2dart   <db_name>   /DB

db2batch   -d   <db_name>   -f   <file_name>   
[-a   userid/passwd]   [-r   <outfile_name> ]

export   to   <Derectry> <filme>

export   to   c:\user.ixf   of   ixf   select   *   from   user

import   from

import   from   c:\user.ixf   of   ixf   
[Create/Insert   into   /   update]   tablename