Installing and Configuring DB2 Clients
This section assumes that IPX/SPX is functional on the client and DB2
server workstations. See "Software Requirements" for the communication protocol requirements for your platform. See "Possible Client-to-DB2 Server Connectivity Scenarios" for the supported communication protocols for your particular client and
server.
A client can access a DB2 server via Direct Addressing or File Server
Addressing. See Table 16 for a list of the available IPX/SPX clients and their supported addressing
methods. For a description of Direct Addressing or File Server
Addressing, refer to the Quick Beginnings manual.
|
You need to know the IPX/SPX addressing method that was used to configure
the server before you configure your DB2 client. If the DB2 server was
configured to use Direct Addressing, you must configure your client to use
Direct Addressing to communicate with the server. If the DB2 server was
configured for File Server Addressing, you can choose to configure your client
to use either Direct Addressing or File Server Addressing, provided that your
client supports the method that you want to use. See Table 16 for a list of client specific IPX/SPX supported addressing methods.
Compare the IPX/SPX parameters in the database manager configuration file
on the server machine, with those sample values in Table 17, to determine which addressing method the server was configured to
support.
|
Table 16. IPX/SPX Supported Communication Methods for a DB2 Client
| Client Platform
| Direct Addressing
| File Server Addressing
|
| Macintosh
| no support
|
| OS/2
| *
| *
|
| SCO OpenServer
| *
|
|
| UNIX (except SCO OpenServer)
| no support
|
| Windows 3.x
| *
| *
|
| Windows 95
| *
|
|
| Windows NT
| *
|
|
The following steps are required to set up a DB2 client to use IPX/SPX
communications:
- Identify and record parameter values.
- Configure the client:
- Catalog the IPX/SPX node.
- Catalog the database.
- Test the connection between the client and server.
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 17. IPX/SPX Values Required at the Client
| Parameter
| Description
| Sample Value
| 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.
Locate this parameter in the database manager configuration file on the
server.
|
- Direct Addressing
- *
- File Server Addressing
- NETWSRV
|
|
| DB2 server object name (OBJECTNAME)
|
- Direct Addressing
- The DB2 server's IPX/SPX internetwork address of the form:
netid (8 byte).
nodeid (12 byte).
socket # (4 byte)
To resolve this parameter, issue the db2ipxad command at the
server. See "A. Catalog the IPX/SPX Node" for more information.
- 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.
Locate this parameter in the database manager configuration file on the
server.
|
- Direct Addressing
- 09212700.400011527745.879E
- File Server Addressing
- DB2INST1
|
|
| Node name (Node_name)
|
A local alias, or nickname, that describes the node where the database
resides. You can choose any name you want, however, all Node name
values within your local node directory must be unique.
| db2node
|
|
The following steps describe how to configure this protocol
on the client. Replace the sample values with your worksheet
values.
You must add an entry to the client's node directory
to describe the remote node.
This entry specifies the chosen alias (Node_name), the File server
name (FILESERVER), and the DB2 server object name
(OBJECTNAME) that are to be used to access the remote DB2
server.
To catalog the IPX/SPX node, perform the following steps:
- Log on to the system as a user with System Administrative (SYSADM) or
System Controller (SYSCTRL) authority.
- If you are using UNIX, set up the instance environment and invoke the DB2
command line processor as follows:
- 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
- Start the DB2 command line processor by issuing the db2
command.
- Catalog the node by issuing the following commands in the command line
processor:
catalog ipxspx node Node_name remote FILESERVER server OBJECTNAME
terminate
- Direct Addressing Example
-
You must assign a * to the FILESERVER parameter and
specify the server's IPX/SPX internetwork address value as the
OBJECTNAME parameter on the client.
To determine the value for the OBJECTNAME parameter, issue the
db2ipxad command on the server. (This command is located in
the sqllib/misc/ directory for UNIX servers, and the sqllib\misc\ directory
for all other DB2 servers.)
Make note of the output that is generated, and use that value in place of
the sample value (09212700.400011527745.879E) in the
example that follows.
To catalog a remote node called db2node, using the IPX/SPX
internetwork address 09212700.400011527745.879E as the
OBJECTNAME, use:
catalog ipxspx node db2node remote * server 09212700.400011527745.879E
terminate
- File Server Addressing Example
- To catalog a remote node called db2node at the file server
NETWSRV, under a DB2 server object named DB2INST1,
use:
catalog ipxspx node db2node remote NETWSRV server DB2INST1
terminate
|
If you need to change values that were set with the catalog node
command, first run the uncatalog node command in the command line
processor as follows:
uncatalog node Node_name
Recatalog the node with the value that you want to use.
|
Before a client application can access a remote database, the database must
be cataloged on the server node and on any client nodes that will connect to
it. When you create a database, it is automatically cataloged on the
server with the Database alias (Database_alias) the same as the Database name
(Database_name). The information in the database directory, along with
the information in the node directory, is used on the client to establish a
connection to the remote database.
To catalog a database on the client, perform the following steps.
- Log on to the system as a user with System Administrative (SYSADM) or
System Controller (SYSCTRL) authority.
- Fill in the Your Value column in the following
worksheet.
Table 18. Parameter Values for Cataloging Databases
| Parameter
| Description
| Sample Value
| Your Value
|
| Database name (Database_name)
| The Database alias (Database_alias) of the remote
database. When you create a database, it is automatically cataloged on
the server with the Database alias name (Database_alias) the same as the
Database name (Database_name).
| sample
|
|
| Database alias (Database_alias)
| An arbitrary local nickname for the remote database, on the
client. If you do not provide one, the default is the same as the
Database name (Database_name). This is the name that you use
when connecting to a database from a client.
| tor1
|
|
| Node name (Node_name)
| The name of the node directory entry that describes where the database
resides. Use the same value for Node name (Node_name) that you
used to catalog the node in the previous step.
| db2node
|
|
- If you are using UNIX, set up the instance environment and invoke the DB2
command line processor as follows:
- 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
- Start the DB2 command line processor by issuing the db2
command.
- Catalog the database by issuing the following commands in the command line
processor:
catalog database Database_name as Database_alias at node Node_name
terminate
For example, to catalog a remote database called sample so that
it has the alias tor1, on the node db2node, use:
catalog database sample as tor1 at node db2node
terminate
|
If you need to change values that were set with the catalog
database command, first run the uncatalog
database command in the command line processor as
follows:
uncatalog database Database_alias
Recatalog the database with the value that you want to use.
|
When the configuration of the client is complete, use the
following steps to verify that you can access data from a remote
database:
|
You will need to connect to a remote database to test the
connection. If you do not have a database on the server, create the
sample database on the server to test the connection. Refer to the Quick Beginnings manual for more information.
|
- Start the database manager by issuing the db2start command on
the server (if it was not automatically started at boot time).
- Issue the following command in the client's Command Center or command
line processor to connect the client to the remote database:
connect to Database_alias user userid using password
The values for userid and password must be valid for the
system on which they are authenticated. By default, authentication
takes place on the SERVER. If the database manager is configured for
CLIENT authentication, the userid and password must be valid
on the client.
If the connection is successful, you will get a message showing the name of
the database to which you have connected. You are now able to retrieve
data from that database. For example, to retrieve a list of all the
table names listed in the system catalog table, enter the following SQL
command in the Command Center or command line processor:
"select tabname from syscat.tables" (for UNIX-based platforms)
select tabname from syscat.tables (for other platforms)
When you are finished using the database connection, issue the connect
reset command to end the database connection.
If the connection fails, check the following items:
At the server:
- The DB2COMM registry parameter includes the value
ipxspx.
- The FILESERVER, OBJECTNAME, and IPX_SOCKET
parameters were updated correctly in the database manager configuration
file.
- The database was created and cataloged properly.
- The security service was started (issue the net start
db2ntsecserver command-for Windows NT servers only).
- If you are using File Server Addressing, ensure that the DB2 server was
registered at the NetWare file server after the database manager
configuration file was updated with the required IPX/SPX parameters.
For more information, refer to the Quick Beginnings manual.
- The database manager was stopped and started (issue the db2stop
and db2start commands on the server).
|
If there are problems starting a protocol's connection managers, a
warning message is displayed and the error messages are logged in the
db2diag.log file. The location of this file depends on your
operating system.
- UNIX-based Platforms
- $HOME/sqllib/db2dump directory, where $HOME is home directory of
the instance owner.
- Other Platforms
- x:\sqllib\%db2instance% directory, where x: is the
drive that the client is installed and %db2instance% represents the
DB2 instance.
Refer to the Troubleshooting Guide for information on the db2diag.log file.
|
At the client:
- If you are using Direct Addressing, check that the node was cataloged with
a value of * for FILESERVER, and the correct IPX/SPX internetwork
address value for the OBJECTNAME parameter.
- If you are using File Serving Addressing, check that the
FILESERVER and OBJECTNAME parameters, used to catalog the
node, match those configured on the server.
- The Node name (Node_name), specified in the database directory,
points to the correct entry in the node directory.
- The database was cataloged properly, using the server's
Database alias (Database_alias) that was cataloged when the database
was created on the server, as the Database name (Database_name) on
the client.
After you verify these items, refer to the Troubleshooting Guide if the connection still fails.
[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]
[ DB2 List of Books |
Search the DB2 Books ]
