Creating users and schemas in the database

Use this task to create a schema for the data store.

Before you begin

Before you begin this task, create the database for your messaging engine.

About this task

To connect to WebSphere® Application Server, the database administrator must create at least one user. The number of user IDs you need depends on the database you use:
  • If you are using Derby, DB2® or Oracle, then the messaging engine can be configured to create any additional schemas that may be required for other data stores. That is, if you only create one user, it can have one to many relationships with the schemas in the database. Refer to Configuring a messaging engine to use a data source for details.
  • For all other types of databases, the schema must be created prior to starting the messaging engines that depend on them.

Procedure

  1. Refer to the documentation for your chosen relational database management system (RDBMS) for more information about how to create users and schema. With DB2 databases, you create users and schema in separate steps. With the other databases, there is a one-to-one relationship between a schema and a user.
    Informix tip: The one-to-one relationship between a messaging engine and a data store means that every messaging engine must have its own data store. If you are using the Informix® RDBMS, configure a separate database instance for each messaging engine.
  2. Refer to Database privileges for information about the authorities that you require to access the data store.



In this information ...


Related reference

IBM Redbooks, demos, education, and more

(Index)

Use IBM Suggests to retrieve related content from ibm.com and beyond, identified for your convenience.

This feature requires Internet access.

Task topic    

Terms of Use | Feedback

Last updated: Aug 29, 2010 7:21:45 PM CDT
http://www14.software.ibm.com/webapp/wsbroker/redirect?version=vela&product=was-nd-dist&topic=tjm0070
File name: tjm0070_.html