Sample Database

A sample database is distributed with the Optim solution.

The sample database is created as part of the installation and is described fully in the Common Elements Manual. The sample database provides data for training and allows you to experiment with the solution without fear of disrupting your production database.

The sample database is used in the sample session in Session Overview and in other examples in this manual. This database includes the following DB2® tables (names are prefixed with the Creator ID FOPDEMO):

OPTIM_CUSTOMERS
OPTIM_ORDERS
OPTIM_DETAILS
OPTIM_SALES
OPTIM_ITEMS
OPTIM_SHIP_TO
OPTIM_SHIP_INSTR
OPTIM_FEMALE_RATES
OPTIM_MALE_RATES
OPTIM_STATE_LOOKUP

The tables in the following chart are used in this manual. The chart shows these tables and the relationships among them. The arrows indicate the flow from parent to child. (In the chart, the OPTIM_ prefixes for table names are not shown.)

Figure shows the relationship between the sample tables used in this documentation.

If you use the Session Overview as a tutorial, note that relationships may have been added to the sample database at your facility during training or other activities. The table names in the sample scenario are shown without the OPTIM_ prefix. To use the scenarios, prefix the table names with OPTIM_