Monday, October 17, 2011

DB2 Basic Commands



List of Db2 Commands
1. Start DB2 Instance
db2start
2. Stop DB2 Instance
db2stop
db2stop force
if db2 instance is not stoped
3. List Databases in an instances
db2 list db directory
4. List cataloged Node
db2 list node directory
5. Display Database Manager Configuration Settings:
db2 get dbm cfg
6. Display Database level Configuration Settings
db2 get db cfg for <DatabaseName>
7. Activate a Database
db2 activate db <DatabaseName>
8. Deactivate a Database
db2 deactivate <DatabaseName>
9. Catalog a Database

No comments:

Post a Comment