Adding a database

A remote database must be cataloged in the system database directory before it can be accessed. Use the Add Database window to catalog a remote database in the local system database directory.

Fields and controls

Authorities and privileges

To add a database:

1. Open the Add Database window.
2. Type the name of the database you want to add in the Database name field.

   If the DISCOVER configuration parameter for the instance is set to either known or search, you can select Refresh to get a list of the remote databases for the instance. You can then select one of the databases from the list below the Database name field.

3. Optional: Enter an alias for the database. If nothing is entered, the alias will be the same as the database name.
4. Optional: For a local instance, select the Default drive that the database is on.
5. Optional: Enter a comment to be associated with the database.
6. Select Apply to add the database to the system database directory.

Related information

• Adding an instance
• Adding a system
• Showing Commands or SQL