IBM DB2數據庫的31個使用技巧

db2   list   node   directory

db2   catalog   tcpip   node   <node_name>   
remote   <hostname &brvbar;ip_address>   server   
<svcname &brvbar;port_number>   ostype   <OS2 &brvbar;
AIX &brvbar;WIN95 &brvbar;NT &brvbar;HPUX &brvbar;
SUN &brvbar;MVS &brvbar;OS400 &brvbar;
VM &brvbar;VSE &brvbar;SCO &brvbar;SGI &brvbar;
Linux &brvbar;DYNIX>

db2   uncatalog   node   <node_name>

db2   list   database   directory

db2   list   database   directory   on   <盤符>

db2   catalog   database   <db_name>   as   
<db_alias>   at   node   <node_name>

db2   uncatalog   database   <db_name>

db2   connect   to   <db_alias>   user   
<user_id>   using   <passWord>

create   database   <db_name>   using   
codeset   <codeset>   territory   <territiry>

create   database   dbtest   using   codeset   
IBM-437   territory   US

db2   migrate   database   <db_name>

db2   select   *   from    "tabschema ". "tabname " 
命令行處理器：db2=>   select   *   from   "tabschema ". "tabname "

db2look   -d   <db_name>   -e   -c   -o   <file_name>

db2   -tvf   <file_name>

select   *   from   sysibm.sysversions

alter   table   <tb_name>   alter   column   
<col_name>   set   data   type   varchar(SIZE)

describe   table   <tb_name> 
or 
describe   select   *   from   <schema> . <tb_name>

ALTER   TABLE   TABLE_NAME   ACTIVE   NOT   
LOGGED   INITALLY   WITH   EMPTY   TABLE

SELECT   *   FROM   SYSCAT.PROCEDURES

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