Managing connections to databases using the Configuration Assistant (Linux and Windows)
The Configuration Assistant (CA) helps you manage your database connections to remote servers. The CA is available as part of the DB2® client. The CA is the preferred method to set up any client to server communications. Note: In previous releases, the DB2 Administration Tools, such as the CA, were supported on all platforms. As of Version 9, the DB2 Administration Tools are supported only on Windows® x86, Windows x64 (AMD64/EM64T), Linux™ on x86, and Linux on AMD64/EM64T. For all platforms, you can use the DB2 command line processor (CLP) to manage connections.
With the CA, you can:
- Catalog databases so that they can be used by applications. Three methods are available:
- Use a profile provided by a database administrator to automatically define your connections. Client access is automatically set up for that database.
- Search the network for available databases and select one. Client access is automatically set up for those databases defined in the profile. DB2 Connect™ Personal Edition cannot search for host or System i™ databases except through a DB2 Connect server that has host or System i databases defined.
- Manually configure a connection to a database by entering the required connection parameters.
- Remove cataloged databases, or change the properties of a cataloged database.
- Export and import client profiles that contain database and configuration information for a client.
- Test connections to local or remote databases identified on your system.
- Bind applications to a database by selecting utilities or bind files from a list.
- Add, change, remove CLI/ODBC data sources, and configure CLI/ODBC configuration settings.
- Tune the client configuration parameters on your system. Parameters are logically grouped and suggested settings are provided on the interface as parameters are selected.
- Update the database server password.
Related concepts
Client-to-server communications configuration overview
Related tasks
Configuring a database connection manually using the Configuration Assistant
Configuring database connections using a client profile with the Configuration Assistant