WebSphere

Database

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.

topic Topic topic

Terms of use | Feedback


Timestamp icon Last updated: 26 July 2010


http://publib.boulder.ibm.com/infocenter/dmndhelp/v6r2mx/topic//com.ibm.websphere.wbpmhelp.620.doc/com.ibm.ws.console.wbi.ndtopology/hlp_nd_top_wiz_db.html
Copyright IBM Corporation 2005, 2010. All Rights Reserved.
This information center is powered by Eclipse technology (http://www.eclipse.org).