Find the List of Active DB2 Databases

Posted by ITsiti — December 19, 2013 in DB2 — Leave a reply

You can use below command determine the list of all the active DB2 databases (in case you are installing multiple DB2 databases on single host).

The command’s output will display the database name, number of applications connected currently and database path.

db2 => LIST ACTIVE DATABASES

                           Active Databases

Database name                              = ARA
Applications connected currently           = 17
Database path                              = /db2/ARA/db2ara/NODE0000/SQL00001/

db2 active database