Use this page to create the data mart on the WebSphere Commerce Analyzer server.
If you have already created a data mart, creating another one using this page will overwrite your existing data mart. You will be prompted for a response before WebSphere Commerce Analyzer overwrites the data mart.
Notes:
- If you have an existing data mart, you can use it, but you should still complete the information on this page, and choose No when prompted to drop the existing data mart.
- If you are migrating from WebSphere Commerce Analyzer 5.6, follow the instructions in the WebSphere Commerce Migration Guide to migrate the data mart. If you have already migrated the data mart, do not recreate the data mart. Instead, complete the information on this page, and choose No when prompted to drop the existing data mart. Then click Next.
- Creating the data mart might take several minutes while DB2 create and populates several system tables.
- Data mart name
- Type the name for the data mart. This name must be 8 characters or less and must contain only characters in the DB2 character set.
- Data mart user
- Type the name of the Windows administrator who is the data mart user.
- Data mart password
- Type the corresponding password for the data mart user.
- Data mart location
- From the list, select the drive on which the data mart will reside.
Table space type
- From the list, select the type of data storage for DB2 to use when it creates table spaces. You have two options:
- Database Managed Storage (DMS): If you select DMS as your data storage type, the table space is managed by the database administrator. The size of the table space is specified and the space allocated when the tables are created. Data can be stored contiguously, which improves performance when data in the table is updated, deleted, or read.
System Managed Storage (SMS): If you select SMS as your data storage type, the operating system manages the table space, which is limited by the size of the hard disk. Data is stored randomly on the hard disk under the table space's directory container (the directory name in the file system). While the use of this type of data storage requires relatively little maintenance by the administrator, it is not optimized for performance. This can result in a significant reduction in performance when data in the table is updated, deleted, or read.
- Customize
- Clicking Customize launches the Change Initial DMS Values page.
Use the Change Initial DMS Values page to change Database Managed Storage (DMS) table space values.
- Schema name
- From the list, select the schema you are using. Two options are available: WCA (WebSphere Commerce Analyzer) and WSA (Tivoli Web Site Analyzer).
- Name
- The name of the table space. The name of the table space cannot be changed.
- Records
- The number of records a table can store.
- Refresh
- Click Refresh to reload the original values in the window.
- Apply
- Click Apply to apply any changes.
- Configure
- Clicking Configure creates the data mart.