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>