How to reset mload after job?

Question

I am running an mload script on a table that is cleared at the beginning of a job. When the script fails, the error and log tables prevent the job from running a second time. How does one reset mload cleanly after a failure?

Answer 1

You need to drop the work/error/log table

• DROP TABLE UV_mytable;
• DROP TABLE ET_mytable;
• DROP TABLE WT_mytable;
• DROP TABLE LT_mytable;

And then release the load lock:

• RELEASE MLOAD mytable;,

If this fails

• RELEASE MLOAD mytable IN APPLY;

But why does the job fail at all?