Find the List of Active DB2 Databases



Share this article :

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/

Related posts

DB2 Backup, Restore & Recovery Operations Monitoring
How to Access DB2 SQL Mode
Determine Network Response Time between Client & DB2 Database
Find the DB2 Database License Status
© 2017 ITsiti. All Rights Reserved
Powered by KEEM