- stop instance
db2stop force
- start instance
## ipclean
## ipclean -c
db2start
- check instance/db status
db2pd -
netstat -na | grep 50001
db2 get health snapshot for dbm
db2 list active databases
db2 list db directory
- log
/db2home/db2inst1/sqllib/db2dump/db2diag.log
db2 get db cfg for dbname | grep "Path to log files"
db2 get db cfg for dbname | grep "First log archive"
- kill connection
db2 connect to dbname
db2 force application all
db2 list applications | grep LIAMDB1 | awk '{print $3}'
db2 "force application ( 34315,34499 )"
db2 deactivate db dbname
- will be automatically activated if any connection
- stop incoming connection
db2set -null db2comm
db2set db2comm=tcpip
- restart instance to kill existing application
db2 connect to dbname
db2 quiesce db immediate