List DB2 Database Directory

Lists the contents of the system database directory. If a path is specified, the contents of the local database directory are listed. To see what databases are available for your use type:

> db2 list db directory

System Database Directory

Number of entries in the directory = 2

Database 1 entry:

Database alias                       = SID
Database name                        = SID
Local database directory             = /db2/SID
Database release level               = b.00
Comment                              = SAP database SID
Directory entry type                 = Indirect
Catalog database partition number    = 0
Alternate server hostname            =
Alternate server port number         =

Database 2 entry:

Database alias                       = SAMPLE
Database name                        = SAMPLE
Local database directory             = /db2/SID
Database release level               = b.00
Comment                              = A sample database
Directory entry type                 = Indirect
Catalog database partition number    = 0
Alternate server hostname            =
Alternate server port number         =

You May Also Like

Leave a Reply?