DB2 Version 9.7 for Linux, UNIX, and Windows

Viewing the local or system database directory files

Use the LIST DATABASE DIRECTORY command to view the information associated with the databases that you have on your system.

About this task

To see the contents of the local database directory file, issue the following command, where <location> specifies the location of the database:

   LIST DATABASE DIRECTORY ON <location>

To see the contents of the system database directory file, issue the LIST DATABASE DIRECTORY command without specifying the location of the database directory file.

Before you begin

Before viewing either the local or system database directory files, you must have previously created an instance and a database.