SAP Basis snippets #1

DB2 database operations

In this post let’s look at some of the basic db2 database commands.

• Logging into database

su - db2<sid>

All the below commands need to be executed as db2<sid> user

• Checking db2 status

db2pd -

• Starting db2

db2start

• Stopping db2

db2stop

• Check the installed db2 version and the path

db2ls