DB2 Basic Commands
Basic DB2 Commands
- Size of your database:
- =>db2 'call get_dbsize_info(?,?,?,0)'
- Version of DB2 you are running:
- =>db2level
- Stop the db2 instance
- =>db2stop
- Stop an instance that has current connections
- =>db2 force applications all
- =>db2 deactivate db <dbname>
- =>db2 terminate
- =>db2stop force
- =>ipclean
- Start the db2 instance
- =>db2start
Kill a hung instance (last resort)
- =>db2_kill -all
List the databases in an instance
- =>db2 list db directory
List the cataloged nodes
- =>db2 list node directory
Show the database manager configuration settings
- =>db2 get dbm cfg
Show the database level configuration settings
- =>db2 get db cfg for <dbname>
Activate a database
- =>db2 activate db <dbname>
Deactivate a database
- =>db2 deactivate db <dbname>
View the DB2 License
- =>db2licm -l
To switch between partitions
- =>db2 terminate; export DB2NODE=<new-node-num>
###Restart a DB2 DPF system
Stop:
=====
db2stop force
db2_all "ipclean -a"
Start:
======
db2start admin mode user <instance_id> restricted access
db2_all "<<+0< db2 restart db DBNAME"
db2_all "<<-0<||db2 restart db DBNAME"
db2 -v "unquiesce instance INSTNAME"
db2 "activate db DBNAME"
Verification:
=============
1. db2_all "db2 connect to DBNAME; db2 values current node; db2 terminate"
2. db2 "get snapshot for database manager" => should show all nodes are active
IBM DB2 UDB for Linux, Unix and Windows Command Reference