Command List - IBM DB2 modify instance and database

Command List - IBM DB2 modify instance and database

Run the command in /opt/ibm/db2/V9.7/instance
Create a new instance        : ./db2icrt -u instance_name instance_name
Remove instance*              : ./db2idrop instance_name

Run the command in /opt/ibm/db2/V9.7/binCheck all existing instance* : db2ilist
Check current instance      : db2 get instance
Set current instance            : set db2instance=instance_name

Create new database       : db2 create db db_name
connect to database        : db2 connect to db_name
stop connecting database: db2 terminate
List all database              : db2 list db directory
remove database             : db2 drop db db_name
LIST all table                   :db2 list tables

Create table : db2 create table

check dbm cfg parameter : db2 get dbm cfg
update dbm cfg parameter: db2 update dbm cfg using PARAMETER OPTION

stopall application to stop connection
   db2 force application all
   db2 terminate

Run the command in /opt/ibm/db2/V9.7/admStartup current instance  : db2start
Stop current instance      : db2stop


* Which request user run the command by root