Register Login

SAP DB2 Command

Updated May 18, 2018

as a basis consultant what are the frequently used commands on db2

stopping db2, starting db2, how to login to db2, how to switch between sidadm user and db2 user and any other important commands


Comments

  • 13 Feb 2014 10:40 am amit butola Helpful Answer
    Command Description
    db2cmd Open DB2 Command line Tool
    db2cc Open DB2 Control Centre
    db2start Start Database Normaly
    db2stop Stop Database Normaly
    db2stop force Stop Database fiercely
    db2 force application all Close all applications that uses DB2 Database.
    db2level Display DB2 version and fix pack level
    db6level Display DB2 Client Version
    db2 terminate Close the database connection
    db2_kill -all Kill a hanged instance
    db2licm -l View license information
    db2 connect to Establish connection to an instance
    db2 list tablespaces show detail Displays table space information
    db2 get dbm cfg Display configuration parameter of database manager.
    db2 get db cfg for Display configuration parameter of an instance
    db2 update dbm cfg using Change value of a database manager configuration parameter.
    db2 update db cfg for using Change value of a instance configuration parameter.
    db2 drop database Delete and instance
    db2 activate db Activate Database
    db2 deactivate Deactivate an active database
    db2 rollforward db to end of logs Apply all pending logs
    db2 rollforward db query status Display rollforward status
    db2 backup database to "disk:location" Take an offline backup to specified location
    db2 list utilities show detail Display Database backup status
    db2 restore db from “disk:path” replace history file Restore database from a backup image

×