Create/Load Sample Database
Use the Create Optim Sample Database panel to populate the database with the sample data distributed with Optim™.
The default creatorid is FOPDEMOx; you can change it to something that is appropriate to your environment.
The sample database contains the following DB2® tables, Legacy Tables, and associated indexes:
| Table | DB2 Index |
|---|---|
| FOPDEMO.OPTIM_CUSTOMERS | FOPDEMO.XCUSTPK |
| FOPDEMO.OPTIM_SALES | FOPDEMO.XSALESPK |
| FOPDEMO.OPTIM_SHIP_TO | |
| FOPDEMO.OPTIM_ITEMS | FOPDEMO.XITEMPK |
| FOPDEMO.OPTIM_ORDERS | FOPDEMO.XORDERPK |
| FOPDEMO.OPTIM_SHIP_INSTR | FOPDEMO.XSHIPIPK |
| FOPDEMO.OPTIM_DETAILS | FOPDEMO.XDETLPK |
| FOPDEMO.OPTIM_FEMALE_RATES | |
| FOPDEMO.OPTIM_MALE_RATES | |
| FOPDEMO.OPTIM_STATE_LOOKUP | |
| FOPDEMO2.CUSTOMERS | FOPDEMO2.X2CUSTPK |
| FOPDEMO2.ORDERS | FOPDEMO2.X2ORDRPK |
| FOPDEMO2.DETAILS | FOPDEMO2.X2DETLPK |
| FOPDEMO2.ITEMS | FOPDEMO2.X2ITEMPK |
| FOPDEMO3.ACCOUNTS | FOPDEMO3.XACCTPK |
For a detailed description of the sample database tables, see Appendix A. Sample Database Tables and Structure in the Common Elements Manual.
To create the sample database, the following panel is displayed.
----------- Create Optim Sample Database ----------------------------------- OPTION ===> Sample Table CreatorID ===> FOPDEMO Creating the Sample Database involves the following steps: 1 - Specification of the Storage Group 2 - Specification of the Database 3 - Creation of the Sample Tables 4 - Loading of the Sample Tables 5 - Grant User Authority to Access the Sample Tables DB2 Subsys for Install ===> DSNC Secondary SQLID ===> Load Library DSN ===> 'FOP.VBR3M0.SFOPLLIB' Install Library DSN ===> 'FOP.VBR3M0.SFOPINST' ********************************** N O T E S ******************************** * The authorization level required to complete this process is * * dependent upon the specifications of the various components. * * The details are supplied on the individual specification panels. * *****************************************************************************
In addition to the list of options, you are prompted for the following information only when you are not currently performing a full install or upgrade. Then, these values are specified on the initial menus for install and upgrade. When displayed, you can modify the values on this panel.
- DB2 Subsys for Install
- The DB2 subsystem into which the sample database is to be created. The sample database must be created in each subsystem in which it will be used.
- Secondary SQLID
- Optional name of a secondary SQLID to be used for the install process. If blank, the primary SQLID will be used.
- Load Library DSN
- Fully qualified name of the load library created when Optim™ was installed using SMP/E.
- Install Library DSN
- Fully qualified name of the dataset created when Optim was installed using SMP/E.
The menu lists the steps required to create and load the training database. You can press ENTER each time this panel is redisplayed and you will be prompted automatically through the steps in the listed order. As a result, the sample database creation process can be suspended and restarted later without having to repeat any steps. The system records the last step successfully completed and resumes with the next step in the sequence. The process restarts where you suspended it, provided the same TSO User ID and subsystem name are used. The following sections discuss each step in the order listed on the menu.