Using the Manage Datasources Utility

From DBArtisan
Jump to: navigation, search

Go Up to Datasource and Server Management

The Manage Datasources dialog box lets you manage datasources throughout your enterprise from a single vantage point. It provides concise, relevant information on your datasources in a simple grid format. It provides centralized access to common datasource operations such as adding, modifying, deleting, discovering, importing, and exporting datasources.

To open the Manage Datasources dialog box:

  1. On the Datasource menu, click Manage Datasources.
The Manage Datasources dialog box opens.

am1569bf.jpg

The grid format lets you access and view datasource specifications. datasources are grouped according to the default, DBMS-based folder structure and then within any custom datasource groups you have set up. The table below describes information available for each datasource entry:

Column Description

Datasource Name

Uses an explorer-like interface to display all registered datasources and their groups. You can navigate this column in the same manner as the datasource explorer, by clicking on nodes to expand or collapse your view of the datasources.

Connect String

Displays the full connection string for the datasource.

Default User Id

Displays the Default User ID for the datasource.

Auto-Connect?

Indicates whether the Auto Connect feature is turned on or off.

Host Computer

Displays the name of the Host Computer if one has been configured.

Default Schema

Displays view default schemas for your DB2 datasources.

In addition, you can take the following actions:

Personal tools