Bookshelf Home | Contents | Index | Search | PDF

Implementing Siebel eBusiness Applications on DB2 UDB for OS/390 and z/OS > Migrating Data Using Siebel EIM > Considerations for EIM Tables >

Resolving Errors in the EIM Process

---

Perform the steps below to resolve errors that might occur during your EIM process:

If EIM aborts with the following generic error, then the user account running EIM does not have EXECUTE privileges on the DSNUTILS stored procedure:

DSNU060I database_alias DSNUGMAP - USER username NOT AUTHORIZED FOR RUNSTATS UTILITY ON

See Using the RUNSTATS Utility for information about required permissions. Alternatively, you can run EIM with the following setting:

UPDATE STATISTICS = FALSE

If your EIM process fails with the following error message, then the DSNZPARM parameter RETVLCFK might be set incorrectly.

EIM-00205 Failed To Load the Application Dictionary

Siebel eBusiness Applications require the setting RETVLCFK=NO. For information on DSNZPARM settings see Preparing for Implementation on the DB2 Host.

If EIM terminates during a DELETE EXACT process involving deletion of child records, the following error indicates that the maximum allowable locks were exceeded:

EIM Fails - Max Locks Exceeded on DELETE EXACT

This causes the child records to be orphaned, because the delete to the parent table has already been committed.

You can avoid this error by specifying the following in your .ifb file:

COMMIT EACH PASS = FALSE

COMMIT EACH TABLE = FALSE

ROLLBACK ON ERROR = TRUE

Bookshelf Home | Contents | Index | Search | PDF