What is the difference between Reset and Clear Status file

[singhald]

Hi All,

I want to know the difference between reseting a job and clear the status file using datastage director.
--if a job is in running status. we want to stop that job . should we use stop job or clear status file.

what does it means to claer a status file and reseting a job .

because when we reset a job it usually show some messages.
when we clear status file it also set the job in reset mode. but dont show any message axcept one message "clearing file RT_STATUSxx"

Can any one tell me something more about RESETING AND CLEARING STATUS FILE.

SINGHAL

[kcbland]

A job is responsible for updating its own internal status, config, and log file during execution. If the job dies tragically, those files remain in their last state. Clearing the status is ONLY used to cleanup a job that didn't die gracefully. You can clear the status file while a job is running, which is a bad idea. Using kill -9 on a main job process is one way to cause this situation.

Resetting is used to put a job in a runnable state after it has gracefully "died". Not finding a file or bad SQL or bad connection or too many errors are still conditions that are handled by the job.

[kumar_s]

Clearing the status would be more dangerous than reseting. By CLEARing the status, the status might have turned to Reset, but at background the process would still be running or still have the connection open. Which will be one of the cause for a zombie process to be created. Which will inturn create cumbursome while restarting the server.

[ray.wurlod]

Have you read about each option in online help or in the manual (Director Guide (dsopsgde.pdf) )?