error message UTY0805 RDBMS failure, 2583

Tools & Utilities
Enthusiast

error message UTY0805 RDBMS failure, 2583

i got an error message saying "UTY0805 RDBMS failure, 2583: Worktable is missing for TABLE NAME during MLoad restart" when i ran an MLOAD script.

i have mentioned the work table and both error tables also. but still facing the same problem.

can any one please tell what does the error message represent.

2 REPLIES
Enthusiast

Re: error message UTY0805 RDBMS failure, 2583

Hi,
Drop the existing worktables,errortables and see whether the mload job is released or not by issuing the release mload statement.
Restart the Mload job.If you again get the same error,you have to drop the target table and restart the mload job.

Regards,
Aravind
Enthusiast

Re: error message UTY0805 RDBMS failure, 2583

Thanks Aravind

I dropped all the working, error tables and the Mload table too. After that i again created the same table and rerun the jcl. Its working.

Thankyou once again.