Use this page to configure the data sources supporting the deployment
environment and to optionally create the tables in the database that are a
part of the deployment environment. The wizard defines the names of the data
sources and you cannot change the names.
The table displays and allows you to configure all of the data sources
that are part of the deployment environment. You also specify which tables
to create by selecting Create Tables. If you choose
not to create the tables with the wizard you must run the table creation scripts
separately.
- Edit
- Allows you to edit the data source description you selected. Click Select on
the row that contains the data source description to change then click Edit.
- Test Connection
- Allows you to test the connection between the deployment manager and the
database defined in the data source you selected. Click Select on
the row that contains the data source to test then click Test Connection.
You can test multiple data sources at once.
Important: Make sure
to test the connection after changing passwords to verify that the password
gives access to the database.
- Edit Provider
- Allows you to change the provider for the data source you selected. Click Select on
the row that contains the data source description to change then click Edit
Provider.
Parameters in the display table
The table contains
the following information about the databases.
- Select
- Click Select to select a data source to either
edit, reset, test the connection or edit the provider.
- Component
- A name that identifies the WebSphere® component using the data
source described on a row.
- Database Instance
- Specifies the name of the database instance described by this configuration.
Initially, all instances are assigned to the common database. If this assignment
doesn't meet your needs, specify the correct database here.
- Schema
- Specifies the schema name associated with the tables accessed with this
data source definition.
- Create Tables
- Specifies whether to create tables within the database during configuration.
To defer table creation, deselect this control.
- User name
- Specifies a userid with sufficient authorization to access or update the
rows in the database instance. When you select Create Tables the
authorization must include the ability to create tables and create schemas.
- Password
- Specifies the correct password associated with User name that
permit successful access to the database instance.
- Server
- Specifies the server on which the database resides. Server has
the format host:port. To change the default database port,
use the detail page.
- Provider
- Specifies the Java™ database connectivity (JDBC) provider for this
database instance.
- Description
- Specifies a description for the data source instance. This description
is any text that can help identify the data source.