Before you can store connection configurations in a database,
you must perform some setup steps.
Before you begin
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.
Procedure
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.