Loading the sample databases for DB2 OLAP Server

To prepare the sample databases for use, you must load data into them. Each of the sample databases has a corresponding data load file.

Each of the sample databases has a corresponding data load file. Table 20 shows the sample applications, the databases that are contained within them, and their corresponding data load files:

Table 20. Sample databases and data load files
Application Database Data load file
Sample Basic Calcdat
Interntl Currcalc
Xchgrate Rates
Demo Basic Data
Samppart Company Calccomp
Sampeast East Calceast
Sample_U Basic Calcdat.txt
DMDemo Basic Dmdemo.txt
ASOsamp Simple dataload.txt1
Notes:
  1. The ASOsamp database must be loaded using the rules file, dataload.rul. The other samples do not require rules files to be loaded.

If you are loading data into the Partitioning sample databases, you must first create a partition user or other user name. See Setting the environment for the partitioning sample applications for detailed information and instructions.

To load data into the sample databases, choose an application and database and the corresponding data load file from Table 20 and complete these steps.

  1. Open the Administration Services Console.
  2. From Enterprise View, find the appropriate Analytic Server and application.
  3. From the Databases node, select the database.
  4. Right-click and select Load data.
  5. In the Data Load dialog box, select Load data.
  6. In the Data files list box, click the Find button to locate a data file to load. The Open dialog box is displayed.
  7. Select the Analytic Server tab.
  8. Ensure that List Files of Type is set to Data files (*.txt).
  9. Select a data load file and click OK to close the dialog box and load the data.
  10. Click OK to load the data. The Data Load Completed dialog box is displayed.