Implementing Siebel Business Applications on DB2 for z/OS > Migrating Data Using Siebel Enterprise Integration Manager >

Resolving Errors in the EIM Process

Perform the following steps to resolve errors that can 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

  For information about the required permissions, see RUNSTATS Utility. Alternatively, you can run EIM with the UPDATE STATISTICS parameter set to 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 Business Applications require that the parameter RETVLCFK is set to NO. For information on DSNZPARM settings see DSNZPARM Parameter Settings for Siebel Business Applications.

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

  EIM Fails - Max Locks Exceeded on DELETE EXACT

  This termination 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