DB2 Universal Database V8.1 Certification Exam 700 Study Guide

Aside from the fact that neither the Control Center nor the Configuration Assistant can be used, the process used to catalog a Database Connection Services (DCS) database is very similar to the process used to catalog a regular DB2 UDB database. A DCS database is cataloged by executing the CATALOG DCS DATABASE command. The syntax for this command is:

CATALOG DCS [DATABASE DB] [ Alias ] <AS [ TargetName ]> <AR [ LibraryName ]> <PARMS [ ParameterString ]> <WITH "[ Description ]">

where:

Alias

Identifies the alias of the target database to be cataloged. This name should match an entry in the system database directory associated with the remote node.

TargetName

Identifies the name of the target host or iSeries database to be cataloged.

LibraryName

Identifies the name of the Application Requester (AR) library loaded and used to access the remote database listed in the DCS directory.

ParameterString

Identifies a parameter string to be passed to the AR when it is invoked. The parameter string must be enclosed by double quotation marks.

Description

A comment used to describe the database entry that will be made in the DCS directory for the database to be cataloged. The description must be enclosed by double quotation marks (").

So, if you wanted to catalog a DCS database that has the name TEST_DB and is a DB2 for z/OS database, you could do so by executing a CATALOG DCS DATABASE command that is similar to this:

CATALOG DCS DATABASE TEST_DB AS DSN_DB WITH "DB2 z/OS database"

Keep in mind that an entry for the database TEST_DB would also have to exist in the system database directory before the entry this command creates in the DCS database directory could be used to connect to the z/OS database.

Entries in the DCS database directory can be removed by executing the UNCATALOG DCS DATABASE command. The syntax for this command is:

UNCATALOG [DATABASE DB] [ DatabaseAlias ]

where:

DatabaseAlias

Identifies the alias assigned to the DCS database to be uncataloged.

Thus, if you wanted to uncatalog the DCS database cataloged in the previous example, you could do so by executing an UNCATALOG DCS DATABASE command that looks like this:

UNCATALOG DCS DATABASE TEST_DB

Related

Категории