DB2 Basic 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
  • =>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

Activate a database

• =>db2 activate db

Deactivate a database

• =>db2 deactivate db

View the DB2 License

• =>db2licm -l

To switch between partitions

• =>db2 terminate; export DB2NODE=