DB2 Commands Home 

IBM DB2 for Linux, Unix and Windows Command Examples


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>
          • IBM DB2 UDB for Linux, Unix and Windows Command Reference