DSXchange

Batch::BUIDWHTABLOAD.JobControl (fatal error from DSWaitForJob): Job control fatal error (-99)
(DSGetJobInfo) SAARTTABLELOAD1: RT_STATUS Record for wave 10 not found.
(DSWaitForJob) Error getting status for job SAARTTABLELOAD1

I cleaned up Datastage using CLEAR.FILE command from administrator before starting the process.
Do you have any idea what is the reason for this error? Please let me know?


Thank you ,

Kollurianu,

what file did you execute a CLEAR.FILE on? What does the log file for SAARTTABLELOAD1 show?

RT_STATUS Record for wave 10 not found.
(DSWaitForJob) Error getting status for job SAARTTABLELOAD1

is the error shown on the log .

CLEAR.FILE on the adminstrator for the whole project , does this help?

OR cleaning up the resources form administrator and clearing the status file would help , if so why ?

What could be the reason for the error.

If you cleared the status table (RT_STATUSnn), then you have made it very difficult for DataStage to figure out which unique instance (wave number) to run. Recompiling the job ought to fix things.

Hi Ray ,

thank u very much for ur reply , what does CLEAR.FILE mean , does it mean clearing the status table .

Thank you,
Purna.

Purna,

CLEAR.FILE is the DataStage engine equivalent of an SQL TRUNCATE; in general you should never be doing a manual CLEAR.FILE of any DataStage control file.

thank you very much Arnd. what does clear status file and cleaning up the resourses from director mean?

Thank you,

The Director's "cleanup resources" starts a program that lets you see and and potentially remove DataStage processes and system locks; the Director's "Clear status file" modifies the status file contents, but it does leave certain control entries in the file and is by no means equivalent to a CLEAR.FILE.

Thank you very much Arnd , for ur answer.

Hi Arnd,

What did you mean by potentially removing datatstage processes , like
what processes would be taken out by issuing clean up resources on the director.

which table is truncated when CLEAR.FILE issued?


Thank you,

CLEAR.FILE takes a command line argument indicating the table whose data are to be cleared.

It was you, in your original post, who claimed to have executed a CLEAR.FILE command. If you didn't specify a table name, then the CLEAR.FILE command would have prompted for one. What name did you provide?!!