Database considerations when creating WebSphere Commerce instances
There are three aspects required for setting up the database portion of a WebSphere Commerce instance.
- Setting up the database and in some cases, the table spaces. You can have the instance creation process skip this step if your organization chooses to customize the database.
- Creating the basic schema (the tables, indexes, and so on that are used by WebSphere Commerce). This step can be customized. You can have the instance creation process skip this step if your organization chooses to customize the schema.
- Creating triggers and populating the objects inside the schema. This step cannot be skipped.
As a part of the WebSphere Commerce instance creation process the Configuration Manager creates the WebSphere Commerce instance database, creates the WebSphere Commerce schema, and populates the objects in the database for you automatically. You can choose to create a new database or use an existing database. You can choose to create a new schema or use an existing schema. You cannot choose to skip the creation of the triggers or the loading of the data.
If you are using an existing database, the database user ID must be the same as the schema name. Do not use a database user ID that is different from the schema name; this is not a supported configuration.
The option to skip database and schema creation exists so that your database administrator can have additional control over the creation of the database and the schema. The option is not meant to allow an existing WebSphere Commerce database to be used with a new WebSphere Commerce instance.
To use an existing database, you must customize it so that it can be used with the WebSphere Commerce instance. To manually create a WebSphere Commerce database, use the information contained in this section as a reference.