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