IBM GC09-2830-00 Catalog the Database, catalog dcs db localdcsname as targetdbname terminate

Models: GC09-2830-00

1 196
Download 196 pages 29.94 Kb
Page 104
Image 104
catalog dcs db local_dcsname as target_dbname terminate

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:

vlocal_dcsname is the local name of the host or AS/400 database.

vtarget_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

92Quick Beginnings

Page 104
Image 104
IBM GC09-2830-00 manual Catalog the Database, catalog dcs db localdcsname as targetdbname terminate