Quick Beginnings

Configuring IPX/SPX on the DB2 Connect Server

To access a remote database server through IPX/SPX, you must first have installed and configured communication software for both the client and DB2 Connect server workstations. See "Software Requirements" for the communication protocol requirements for your platform. See "Possible Client-to-DB2 Connect Gateway Connectivity Scenarios" for the supported communication protocols for your particular client and server.

Before completing the steps in this section, be sure that you have completed the instructions in "Setting the DB2COMM Registry Value".

If you are setting up communications for the Administration Server, it was configured for IPX/SPX (using the registered Socket number 87A2) when it was created. There are no further steps required to enable the Administration Server to use IPX/SPX.

Your DB2 Connect server can be set up to support IPX/SPX client communications via Direct Addressing or File Server Addressing.

Direct Addressing:: The client connects to the DB2 Connect server by directly specifying the IPX/SPX internetwork address of the server (bypassing the NetWare file server). Using this method, a NetWare file server is not required on the network. Configure DB2 Connect servers using this addressing method if they will be accessed solely by clients using Direct Addressing.
File Server Addressing:: The DB2 Connect server instance registers its address at the NetWare file server. The client connects to the DB2 Connect server instance through an address stored at a NetWare file server. Configure DB2 Connect servers using this addressing method if they will be accessed by clients using both File Server and Direct Addressing, or just File Server Addressing.

See Table 23 for a list of the supported IPX/SPX addressing methods for your server.

Table 23. IPX/SPX Supported Communication Methods for a DB2 Connect Server

DB2 Connect Server Platform Direct Addressing File Server Addressing
AIX * *
HP-UX * *
OS/2 * *
Solaris *
Window NT *

The following steps are required to set up IPX/SPX communications:

Identify and record parameter values.
Configure the server:
1. Update the database manager configuration file.
2. Register the server on the NetWare file server (for File Server Addressing only).

Step 1. Identify and Record Parameter Values

As you proceed through the configuration steps, complete the Your Value column in the following table. You can fill in some of the values before you start configuring this protocol.

Table 24. IPX/SPX Values Required at the DB2 Connect Server

Parameter Explanation Our Example Your Value
File server name (FILESERVER)

Direct Addressing
A * value indicates that you are using Direct Addressing.
File Server Addressing
The name of the NetWare file server where the database server instance is registered. This parameter must be entered in UPPERCASE.

Direct Addressing
*
File Server Addressing
NETWSRV

DB2 server object name (OBJECTNAME)

Direct Addressing
A * value indicates that you are using Direct Addressing.
File Server Addressing
The database manager server instance, represented as the object OBJECTNAME on the NetWare file server. The server's IPX/SPX internetwork address is stored and retrieved from this object.
This parameter must be entered in UPPERCASE and be unique on the NetWare file server system.

Direct Addressing
*
File Server Addressing
DB2INST1

Socket number (IPX_SOCKET) Represents the connection end point in a DB2 Connect server's internetwork address. It must be unique for all server instances, and all IPX/SPX applications running on the workstation. It is entered in hexadecimal format.
DB2 has registered well known sockets with Novell in the range 0x879E to 0x87A1. If you run more than 4 instances on the server machine, you must prevent socket collisions for instances 5 and up by choosing a socket number that is not 0x0000, in the dynamic socket range 0x4000 to 0x7FFF, or in the range 0x8000 to 0x9100 (these are well known sockets that are registered to various applications). The maximum value for this parameter is 0xFFFF.
879E (default)
IPX/SPX Internetwork Address The internetwork address required when configuring a client to communicate with a server using Direct Addressing. 09212700.400011527745.879E

Parameter	Explanation	Our Example
File server name (`FILESERVER`)	Direct Addressing A `` value indicates that you are using Direct Addressing. File Server Addressing* The name of the NetWare file server where the database server instance is registered. This parameter must be entered in UPPERCASE.	Direct Addressing `` File Server Addressing* `NETWSRV`
DB2 server object name (`OBJECTNAME`)	Direct Addressing A `` value indicates that you are using Direct Addressing. File Server Addressing* The database manager server instance, represented as the object `OBJECTNAME` on the NetWare file server. The server's IPX/SPX internetwork address is stored and retrieved from this object. This parameter must be entered in UPPERCASE and be unique on the NetWare file server system.	Direct Addressing `` File Server Addressing* `DB2INST1`
Socket number (`IPX_SOCKET`)	Represents the connection end point in a DB2 Connect server's internetwork address. It must be unique for all server instances, and all IPX/SPX applications running on the workstation. It is entered in hexadecimal format. DB2 has registered well known sockets with Novell in the range 0x879E to 0x87A1. If you run more than 4 instances on the server machine, you must prevent socket collisions for instances 5 and up by choosing a socket number that is not `0x0000`, in the dynamic socket range `0x4000` to `0x7FFF`, or in the range `0x8000` to `0x9100` (these are well known sockets that are registered to various applications). The maximum value for this parameter is `0xFFFF`.	`879E` (default)
IPX/SPX Internetwork Address	The internetwork address required when configuring a client to communicate with a server using Direct Addressing.	`09212700.400011527745.879E`

Naming Restrictions for File Server Addressing: The following characters are not valid for the File server (FILESERVER) or the DB2 server object name (OBJECTNAME) parameters: / \ : ; , * ?

Step 2. Configure the DB2 Connect Server

The following steps describe how to configure this protocol on the server. Replace the sample values with your values and record them on your worksheet.

A. Update the Database Manager Configuration File

You must update the database manager configuration file with the File server (FILESERVER), DB2 server object name (OBJECTNAME), and Socket number (IPX_SOCKET) parameters.

To update the database manager configuration file, perform the following steps:

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

If you have trouble logging on to the system, see "Logging on to the System".
If you are using UNIX, set up the instance environment and invoke the DB2 command line processor as follows:
1. Run db2profile or db2cshrc as follows:
```
   . INSTHOME/sqllib/db2profile    (for Bourne or Korn shell)
   source INSTHOME/sqllib/db2cshrc (for C shell)
```
  where INSTHOME is the home directory of the instance
2. Start the DB2 command line processor by issuing the db2 command.
In the database manager configuration file, update the File server (FILESERVER), DB2 server object name (OBJECTNAME), and Socket number (IPX_SOCKET) parameters using the following commands in the command line processor:
```
   update dbm cfg using fileserver FILESERVER objectname OBJECTNAME ipx_socket IPX_SOCKET
   db2stop
   db2start
```
Direct Addressing
For example, if you have chosen a value of 879E for the Socket number (IPX_SOCKET) parameter, use:
```
   update dbm cfg using fileserver * objectname * ipx_socket 879E
   db2stop
   db2start
```
File Server Addressing
For example, if the name of the File server (FILESERVER) is NETWSRV, the DB2 server's object name (OBJECTNAME) is DB2INST1, and you have chosen a value of 879E for the Socket number (IPX_SOCKET) parameter, use:
```
   update dbm cfg using fileserver NETWSRV objectname DB2INST1 ipx_socket 879E
   db2stop
   db2start
```

View the database manager configuration file, to ensure that these changes have taken effect, by issuing the following command in the command line processor:

   get database manager configuration

If you are planning to only support clients that use Direct Addressing, you will be required to enter the server's IPX/SPX internetwork address as the DB2 server object name when cataloging the node on the client.

Determine the value for the OBJECTNAME parameter by issuing the db2ipxad command on the server. This command is located in the sqllib/misc/ directory for UNIX platforms, or the sqllib\misc\ directory for all other platforms.

Make note of this output on your worksheet for use when you configure an IPX/SPX client using the command line processor.

If you are planning to support clients using only Direct Addressing, you are now finished the configuration and are ready to install a DB2 client. Go to Chapter 26. "Installing DB2 Clients" for more information.

B. Register the DB2 DB2 Connect Server Instance on the NetWare File Server (for File Server Addressing Only)

The DB2 Connect server must be registered after the database manager configuration file has been updated with the IPX/SPX parameters. To register the DB2 Connect server instance at the NetWare File server, issue the following command in the command line processor:

   register db2 server in nwbindery user USERNAME password PASSWORD

Notes:

USERNAME and PASSWORD must be specified in UPPERCASE.
The USERNAME and PASSWORD are used to log on to the NetWare file server and must have Supervisor/Administrator or Workgroup Manager security equivalence.
If you want to register at a NetWare 4.x file server (which uses directory services and provides bindery emulation capability), the USERNAME used must be created within the same context as the current bindery context used by Directory Services when it does bindery emulation. The bindery emulation context currently in use can be found by checking the bindery emulation setting on the NetWare 4.x file server (for example, by using the SERVMAN utility). For more information, refer to your IPX/SPX documentation.

Now that you have configured the server, you are ready to install a DB2 client. Go to Chapter 26. "Installing DB2 Clients" for more information.

[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]

[ DB2 List of Books | Search the DB2 Books ]

DB2 Connect Server Platform	Direct Addressing	File Server Addressing
AIX	*	*
HP-UX	*	*
OS/2	*	*
Solaris	*
Window NT	*