Step 5. catalog the database – IBM GC09-2830-00 User Manual

Page 104

Advertising
background image

program name (

17 ), the mode ( 15 ), and the security type. Enter

the following commands substituting your values from the worksheet

in Table 5 on page 68:

catalog "appn node db2node network SPIFNET remote NYM2DB2

tpname QCNTEDDM mode IBMRDB security PROGRAM"

terminate

Note:

To connect to DB2 for MVS, it is recommended that you use security
PROGRAM.

If you need to change values that were set with the catalog node
command, perform the following steps:

Step 1.

Run the uncatalog node command in the command line
processor as follows:

uncatalog node node_name

Step 2.

Recatalog the node with the values that you want to use.

Step 4. Catalog the Database as a Database Connection Service (DCS) Database

To catalog the remote database as a Data Connection Services (DCS) database,
perform the following steps:

Step 1.

Log on to the system as a user with System Administrative
(SYSADM) or System Controller (SYSCTRL) authority.

Step 2.

Enter the following commands:

catalog dcs db local_dcsname as target_dbname

terminate

where:
v local_dcsname is the local name of the host or AS/400 database.
v target_dbname is the name of database on the host or AS/400

database system.

For example, to make ny the local database name for DB2 Connect,
for the remote host or AS/400 database called newyork, enter the
following commands:

catalog dcs db ny as newyork

terminate

Step 5. Catalog the Database

Before a client application can access a remote database, the database must be
cataloged on the host system node and on any DB2 Connect workstation
nodes that will connect to it. When you create a database, it is automatically
cataloged on the host with the database alias (database_alias) the same as the

92

Quick Beginnings

Advertising