DB2 Basic Commands

DB2 Basic Commands

Start DB2 instance:
      db2start

Stop DB2 instance
        db2stop

Connect to Database: 
           db2 connect to <database_name> user <user_id> using <Password>

List tables in the database
       db2 list tables

List Cataloged node
       db2 list node directory

List Database in an instance
       db2 list db directory

Display fields from the table
          db2 describe table <table_name>


List database manager configuration settings:
           db2 get dbm cfg


List database configuration settings:
       db2 get db cfg for <databasename>


Activate a  database:
       db2 activate db <database_name>


Deactivate  a database:
      db2 deactivate db <database_name>


DB2 Version:
      db2level


Database size:
     db2 'call get_dbsize_info(?,?,?,0)'