DB2 Version 9.7 for Linux, UNIX, and Windows

LIST DCS DIRECTORY command

Lists the contents of the Database Connection Services (DCS) directory.

Authorization

None

Required connection

None

Command syntax

Read syntax diagramSkip visual syntax diagram
>>-LIST DCS DIRECTORY------------------------------------------><

Command parameters

None

Examples

The following is sample output from LIST DCS DIRECTORY:

 
 Database Connection Services (DCS) Directory
 
 Number of entries in the directory = 1
 
DCS 1 entry:
 
 Local database name                = DB2
 Target database name               = DSN_DB_1
 Application requestor name         =
 DCS parameters                     =
 Comment                            = DB2/MVS Location name DSN_DB_1
 DCS directory release level        = 0x0100
 
These fields are identified as follows:
Local database name
Specifies the local alias of the target host database. This corresponds to the database-name parameter entered when the host database was cataloged in the DCS directory.
Target database name
Specifies the name of the host database that can be accessed. This corresponds to the target-database-name parameter entered when the host database was cataloged in the DCS directory.
Application requester name
Specifies the name of the program residing on the application requester or server.
DCS parameters
String that contains the connection and operating environment parameters to use with the application requester. Corresponds to the parameter string entered when the host database was cataloged. The string must be enclosed by double quotation marks, and the parameters must be separated by commas.
Comment
Describes the database entry.
DCS directory release level
Specifies the version number of the Distributed Database Connection Services program under which the database was created.

Usage notes

The DCS directory is created the first time that the CATALOG DCS DATABASE command is invoked. It is maintained on the path/drive where DB2® was installed, and provides information about host databases that the workstation can access if the DB2 Connect™ program has been installed. The host databases can be:
  • DB2 databases on OS/390® and z/OS® host
  • DB2 databases on System i® hosts
  • DB2 databases on VSE & VM hosts