17.2.2.1.2 CATALOG DCS DATABASE

This command stores information about remote host (z/OS or OS/390) or iSeries (OS/400) databases in the Database Connection Services (DCS) directory. These databases are accessed through an Application Requester (AR), such as DB2 Connect. Having a DCS directory entry with a database name matching a database name in the system database directory invokes the specified AR to forward SQL requests to the remote server where the database resides.

Note:

If you just need access the data residing on universal system, such as UNIX, Linux, you could use CATALOG DATABASE only.

The CATALOG DCS DATABASE command syntax is as follows:

catalog dcs database [ Database-name ] as [ Target-database-name ] with [comment-string ]

Example:

db2 catalog dcs database db2wasa as qwa1 with "catalog the remote 
host database qwa1 to local db2wasa" 

CATALOG DCS DATABASE takes the following parameters:

Database-name

Specifies the alias of the target database to catalog. This name should match the name of an entry in the database directory that is associated with the remote node.

Target-database-name

Specifies the name of the target host or iSeries database to catalog.