Sample tables are distributed with the Optim™ solution. Generally, you load this sample data when you configure the first workstation, however, you can load it independently or when you configure an additional workstation.
You can load, refresh, or drop sample data by selecting the Load/Drop Sample Data option, which guides you through the process. You can start this process by selecting Load/Drop Sample Data from the Tasks menu, or by selecting the Configuration Assistant from the Help menu.
A DB Alias is required to access the sample tables. The DB Alias, which is used as a high-level qualifier for the table names, provides a single-name association for parameters that are needed to connect to the database. The DB Alias and other Optim objects, created when the sample tables are created, are stored in an Optim Directory.
Use the Specify Optim Directory dialog to select the name of the Optim Directory. Click Proceed to open the next dialog.
Use the Create/Select DB Alias) dialog to specify the DB Alias for the sample tables. Click Proceed to open the next dialog.
After you select the DB Alias for the sample tables, the Configuration program opens the Load/Drop Sample Tables dialog. If you are creating or refreshing the tables, you must specify an identifier (such as a Creator ID, Schema Name, Database Name, or Owner ID) and Tablespace if appropriate. If you are dropping sample tables, only the identifier is required.
After you load or drop sample tables that are associated with a particular DB Alias, the Configuration program displays the Load/Drop Sample Data for Another DB Alias dialog. You are then prompted to load or drop the sample tables for a different DB Alias. If you choose to load or drop for another DB Alias, the Create/Select DB Alias dialog opens to restart the process. Otherwise, the process completes and returns to the main window.