DB2 Commands Home

Unknown 8:41 AM BASIS , DB2 , MSSQL , SAP Beginners No comments

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 <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>

Popular Posts