What is the use of clear status file

What is the use of clear status file in DS?How we will use it?explain with examples?

Questions by etl_bhargavi

Showing Answers 1 - 6 of 6 Answers

ketanshah123

  • Feb 19th, 2008
 

When you clear a job’s status file you reset the status records associated with all stages in that job. You should therefore use this option with great care, and only when you believe a job has hung or aborted. In particular, before you clear a status file you should:
1 Try to reset the job
2 Ensure that all the job’s processes have ended

  Was this answer useful?  Yes

nikhilanshuman

  • Dec 30th, 2009
 

If status is cleared for a datastage job,all of its instaces will be deleted.I mean if there is a instance say jobname.inst1 or jobname.inst2  these will be deleted.

The entries for that particular jobs will be cleared from RT_Status(n) table.Here n is the job number.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions