B Appendix: EICS Data Loading Performance Consideration

During data seed import process, the oracle database will validate data integrity via database foreign key 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

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

Select Job Name Database Constraints

From Seed Option drop down list, select Disable Constraint.

Click Start Job button.

Figure B-1 Data Seed

Important: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.