Before you can store connection configurations in a database, you
must perform some setup steps.
Before you begin
Prerequisite: The following types of data sources can be used
as configuration repositories. You can use any version of each database that
is supported by your product. Refer to the list of supported data sources
for your product in the system requirements documentation for more details.
- DB2® for Linux®,
Unix, and Windows®
- DB2 for z/OS®
- DB2 for i5/OS® (iSeries®)
- Informix® Dynamic
Server
About this task
Before you can store connection configurations in a configuration
repository, you must set up a database that will be used as the configuration
repository. This database should be accessible by all team members to facilitate
sharing the connection information. You can run a script to set up the database
with the correct structure.
To set up a configuration repository database
to store connection configurations:
- In the Data Source Explorer, connect to the database that you want
to use as a configuration repository.
- Right-click the connection in the Data Source Explorer, and select Set
up Configuration Repository.
In the editor that
opens, you can customize the setup script to specify different table spaces
for the configuration tables, based on your need to backup and share the connection
configurations.
Important: Do not change the names of the
data objects that are created.
- Right-click in the editor and select Run SQL to
set up the configuration repository. Verify that the script
ran successfully by checking the SQL Results view. If the script runs successfully,
you should also be able to see the new tables in the Data Source Explorer.
- Add this database as a configuration repository:
- Right-click the Configuration Repositories folder
in the Data Source Explorer and select New.
- In the window that opens, select the database on which you ran
the setup script, and click Finish.
What to do next
After the configuration repository is set up and you have populated
it with database connection configurations, notify team members and provide
them with the information that they need to connect to this configuration
repository.