Tuesday, May 26, 2009

DB2 command

LIST DATABASE DIRECTORY Command
Lists the contents of the system database directory. If a path is specified, the contents of the local database directory are listed.

Scope
If this command is issued without the ON path parameter, the system database directory is returned. This information is the same at all database partitions.

If the ON path parameter is specified, the local database directory on that path is returned. This information is not the same at all database partitions.

Authorization
None

Required connection
None. Directory operations affect the local directory only.

Command syntax
>>-LIST--+-DATABASE-+--DIRECTORY--+---------------+------------><
'-DB-------' '-ON--+-path--+-'
'-drive-'