Thursday, January 30, 2014

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=
  • No comments:

    Post a Comment

    JMS Messaging - High availability, scalability and Maximo Integration Framework using a single Service Integration Bus

    T he first is configuring the JMS resources for scalability and the second is configuring the messaging engines for highly availability. For...