Connecting to a remote database

If you want to connect the system administration client to a remote database, you must first define a connection between the system administration client and the remote database. If you use the system administration client on multiple computers, you must define connections between each system administration client and each remote database.

If you want to be able to use either the IBM® Content Manager system administration client with a remote database, you must define the connection in both places. You only need to catalog it once, however. If you have stand-alone remote databases, you must set up each database catalog connection separately.

There are two ways to set up your system administration client to connect to a remote database:

• Use a tool to create the configuration:
  1. Gather information about the remote database.
  2. Use the server configuration utility to set up the connection.
• Manually create the connection:
  1. Gather information about the remote database.
  2. For Db2® databases only, catalog the remote node and database:
     • Databases on z/OS®
     • Databases on Linux®, AIX® or Windows™
  3. For Oracle databases only, update the local tnsnames.ora file to include the remote database.
  4. Add the connection information to the database connection parameter file..For IBM Content Manager, the file is: cmbicmsrvs.ini.