db2cmd | Open DB2 Command line Tool |
db2cc | Open DB2 Control Centre |
db2start | Start Database Normaly |
db2stop | Stop Database Normaly |
db2stop force | Stop Database forcely |
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 <db2sid> | 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 <db2 sid> | Display configuration parameter of an instance |
db2 update dbm cfg using <parameter_name> <new value> | Change value of a database manager configuration parameter. |
db2 update db cfg for <db2 sid> using <parameter_name> <new value> | Change value of a instance configuration parameter. |
db2 drop database <target db2sid> | Delete and instance |
db2 activate db <dbsid> | Activate Database |
db2 deactivate <dbsid> | Deactivate an active database |
db2 rollforward db <SID> to end of logs | Apply all pending logs |
db2 rollforward db <db2sid> query status | Display rollforward status |
db2 backup database <sid> to “disk:\location” | Take an offline backup to specified location |
db2 list utilities show detail | Display Database backup status |
db2 restore db <sid> from “disk:\path” replace history file | Restore database from a backup image |
db2top | Monitor DB2 like active session, primary logs etc. |