Some tables are created during the execution of a job, but others must be created by you before the job begins. Target tables must exist on the database when an Update driver job is executed. The log table is created automatically when you run the Update job script. Error tables and work tables are created by the database. Error tables are dropped by the Update driver during the cleanup phase if no errors were detected during the acquisition phase or the application phase. The work table is dropped by the Update driver during the cleanup phase if no errors were detected during the acquisition or the application phase. The log table is dropped by the Update driver after the job completes successfully.
When a job terminates abnormally, the log, error, and work tables may not be dropped depending on where in the job the termination occurred. If you want to restart the job from the beginning, you need to manually drop these tables by running a BTEQ script.