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