飛小豬

How to create DB

db2 create db <db name>

How to connect DB

db2 connect to <db name>

How to create DB2 administrate server

db2admin create

How to get DB Manager Configuration

db2 get dbm cfg

How to get DB Configuration

db2 get db cfg for <db name>

How to update DB configuration

db2 update db cfg for <db name> using <parameter> <value>

How to get DB2 variables

db2set -all
The environment, denoted by [e]
The node level registry, denoted by [n]
The instance level registry, denoted by [i]
The global level registry, denoted by [g].

How to know instance for DB2

db2ilist

 How to drop instance

db2idrop <instance name>

Invesigate DB2 problem, you can take a look at db2diag.log