Some useful DB2 command
Some useful DB2 command
| 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 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. |
Tidak ada komentar :
Posting Komentar