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