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 version of db2 installed and the path

db2ls