Scribd
Upload
850 views1 page

Db2 List Command

This document lists various DB2 commands and provides a brief description of each command's functionality. Some key commands include db2start to start the database normally, db2stop to stop it normally, db2force application all to close all applications using the database, db2terminate to close a database connection, and db2backup database to take an offline backup of the database to a specified location.

Uploaded by

IT Support
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
850 views1 page

Db2 List Command

This document lists various DB2 commands and provides a brief description of each command's functionality. Some key commands include db2start to start the database normally, db2stop to stop it normally, db2force application all to close all applications using the database, db2terminate to close a database connection, and db2backup database to take an offline backup of the database to a specified location.

Uploaded by

IT Support
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
You are on page 1/ 1

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.

You might also like