B Appendix: EICS Data Loading Performance Consideration

During normal data seed import process, the oracle database will validate data integrity via database foreign key constraints.

Disabling Constraints

For initial data seeding into EICS, disable the database constraints prior to running initial data seeding. Enable the database constraints after initial inventory entities and data seeding is complete.

To disable database constraints:

1. Login Oracle Enterprise Inventory Cloud Service page as ECIS System Ops user.

2. On Main Menu, Select Admin/ Technical Maintenance/Job Admin.

3. On Job Admin Screen, click Data Seed, this will bring you to the Data Seed screen.

4. Select Job Name Database Constraints.

5. From Seed Option drop down list, select Disable Constraint.

6. Click Start Job.

Figure B-1 Data Seed

Enabling Constraints (Critical Process)

After data seeding, the EICS database constraints must be enabled. When this occurs, the data that was seeded into the EICS tables will be validated during the enabled of the database constraints.

To enable database constraints:

1. On Job Admin Screen, click Data Seed, this will bring you to the Data Seed screen.

2. Select Job Name Database Constraints.

3. From Seed Option drop down list, select Enable Constraint.

4. Click Start Job.