DB2 Connect User's Guide

Creating a Database Locator Object

The database locator object is used to define a DB2 Connect Enterprise Edition server to its clients. For your DB2 Connect workstation, use the DCE command cdscp create object to create a database locator object. For example:

cdscp create object object_global_name

Add the following attributes to the object:

DB_Object_Type

L for locator object

DB_Communication_Protocol

Following is the information that you need to set up each communication protocol between the DB2 Connect workstation and remote clients.

The following summarizes protocol support by platform:

• On OS/2: APPC, IPX, NETBIOS, and TCP/IP
• On Windows 32-bit operating systems: APPC, IPX, NETBIOS, NPIPE, and TCP/IP
• On UNIX: APPC and TCP/IP

For APPC:

1. The communication protocol (APPC)
2. The network ID of the DB2 Connect workstation
3. The LU name for the DB2 Connect workstation
4. The transaction program name for connections from remote clients
5. The mode name
6. The security type, as described in Security with DCE Directory Services.

For TCP/IP:

1. The communication protocol (TCPIP)
2. The host name of the DB2 Connect workstation
3. The connection port used by the DB2 Connect workstation to accept connections from remote clients
4. Type of connection (whether using SOCKS or NONE). This is optional. If not specified, NONE is used.

For IPX/SPX:

1. The communication protocol (IPXSPX)
2. The file server name. Use * for direct addressing
3. The object name. Use the internetwork address for direct addressing.

For Named Pipes:

1. The communication protocol (NPIPE)
2. The computer name of the DB2 Connect workstation.
3. The instance name.

For NETBIOS:

1. The communication protocol (NETBIOS)
2. The NNAME for the server or DB2 Connect Enterprise Edition gateway.

For example, you could put the following lines into a file:

   create object /.../cdscell1/subsys/database/DBAIX01
   add    object /.../cdscell1/subsys/database/DBAIX01 DB_Object_Type= L
   add    object /.../cdscell1/subsys/database/DBAIX01 DB_Communication_Protocol=\
             TCPIP;AIX001;3700
   add    object /.../cdscell1/subsys/database/DBAIX01 DB_Communication_Protocol=\
             APPC;SPIFNET;NYX1GW01;NYSERVER;IBMRDB;NONE

Then, enter the command:

   cdscp < filename

On Windows 32-bit operating systems, you can specify a named pipe in a similar manner. For example:

   add    object /.../cdscell1/subsys/database/DBAIX01 DB_Communication_Protocol=\
              NPIPE;computer_name;instance_name

On OS/2, you can specify the protocol in the DB_Communication_Protocol attribute. For example:

    - IPXSPX;fileserver;objectname
    - NETBIOS;nname