Thursday, September 24, 2015

List all databases in an instance

1. LIST DATABASE DIRECTORY

db2 => list database directory

 System Database Directory

 Number of entries in the directory = 1

Database 1 entry:

 Database alias                       = UNICADB
 Database name                        = UNICADB
 Local database directory             = /apps/db2data/unicadb
 Database release level               = 10.00
 Comment                              =
 Directory entry type                 = Indirect
 Catalog database partition number    = 0
 Alternate server hostname            =
 Alternate server port number         =


2. LIST ACTIVE DATABASES
    (An active database is available for connection and use by any application)

db2 => list active database
SQL0104N  An unexpected token "database" was found following "ACTIVE". 
Expected tokens may include:  "DATABASES".  SQLSTATE=42601
db2 => list active databases

                           Active Databases

Database name                              = UNICADB
Applications connected currently           = 1
Database path                              = /apps/db2data/unicadb/db2inst1/NODE0000/SQL00001/MEMBER0000/


No comments:

Post a Comment