Configuring a database connection by searching the network using the Configuration Assistant
You can use the Configuration Assistant (CA) to search a network for databases.
Before you configure a database connection by searching the network:
- Ensure that you have a valid DB2® user ID.
- If you are configuring a connection from a system that has a DB2 Server or DB2 Connect™ server product installed, ensure that you have a user ID with SYSADM or SYSCTRL authority for the instance.
The search method feature might be unable to detect a remote system if:
- The DB2 Administration Server (DAS) is not running on the remote system.
- The search times out. By default, the search will scan the network for 1 second; this might not be long enough to detect the remote system. You can set the DB2DISCOVERYTIME registry variable to specify a longer period of time.
- The network that the search is running on is configured so that the search does not reach the remote system desired.
The following points apply to cases where you want to explicitly configure an IPv6 address on a network that supports IPv6:
- The system must be listed under Known Systems.
- Only the Configuration Assistant Advanced View supports explicitly configure an IPv6 connection.
To configure a database connection by searching the network:
- Log on to the system with a valid DB2 user ID.
- Start the CA. The CA can be started from the Start menu on Windows® or using the db2ca command on both Windows and UNIX® systems.
- On the CA menu bar, under Selected, choose Add Database Using Wizard. The Add Database
Wizard opens.
- Select the Search the network radio button and click Next.
- Double-click on the folder beside Known Systems to list all the systems known to your client or double-click on the folder beside Other Systems to list all the systems on the network. If no systems are listed, you can click Add System to specify one. Once you add a system, it will appear in the Known Systems list.
- Expand the entries for the system you are interested in until you see the database you want to add. Select the database. Click Next.
- Type a local database alias name in the Database alias field and optionally type a comment that describes this database in the Comment field.
- If you are planning to use ODBC, register this database as an ODBC data source. ODBC must be installed to perform this operation.
- Click Finish. You can now use the database you added. Click Close to exit the CA.
Parent topic: Client-to-server communications configuration overview
Related tasks
Configuring a database connection manually using the Configuration Assistant
Testing a database connection using the Configuration Assistant