Loading Seed Data

About Loading Seed Data

In the process of creating a database/upgrading it to 9.1.9level, after creating an empty database, you can load the meta model with seed data.

 This task explains the procedure to load seed data:
  1. Log on as cisdba and run edm.sh from $EDS_HOME/bin directory. For additional information, see Using CES Database Manager.

  2. From the EDM main window, select a database which the seed data is to be loaded.

  3. Select Load > Load Explore Seed Data option. The Load Explore Seed Data window appears.

     

    Name Description
    Instance Name The name of the instance appears.
    Database Name The name of the database for which seed data is to be loaded appears.
    Space Management The space management for the predefined CES tablespaces appears here.
  4. Click Load to start the seed data loading process. A confirmation message indicating that the loading of seed data will start and that the process will take some time appears.

  5. Click OK. The Load Explore Seed Data window appears.

  6. The CES system classes, indexes, stored procedures, sequences and triggers are created, and seed data is loaded. After completion of each operation, a check mark appears , which indicates that the operation is complete. Each action that takes place during loading of seed data is written onto log files, which is created in the destination directory. All the actions taking place are also displayed in the bottom panel.

  7. After the seed data has been successfully loaded, click Cancel to return to EDM main window.

Notes:

  1. These error message during creation of stored procedures can be ignored:

    SQL0347W The recursive common table expression
    "CISDBA.CLS" may contain an infinite
    loop.SQLSTATE=01605

  2. These error message in the LSD_LOADALL_<instance name>_<database name>.log can be ignored:

    SQL0100W No row was found for FETCH, UPDATE or DELETE; or the result of a query is an empty table

Note:  To understand how ot upgrade your existing database to the 9.1.9 level, refer to CES Installation Guide : Upgrading the Database for instructions.