DSXchange

Hi All,

We have different Datastage environments. We have an error that is only happening in one environment (production). We think it may be due to a corrupted job.

Based on this, we have tried to recompile the job, and it did not work. We have tried also to import the job from the previous stage (pre-production) that it is a mirror from production, and it didn't work neither.

Does anybody have any idea about how we can delete the executable?

Thanks a lot in advance.

What happened when you tried to import the job? Did it give you an error or a warning. Posting that here might help. If the design time info is not imported then you wont be able to open the job designer but still be able to delete it from designer. You can delete from manager. Right click on the job name and select delete.

jusami25 wrote:Based on this, we have tried to recompile the job, and it did not work. We have tried also to import the job from the previous stage (pre-production) that it is a mirror from production, and it didn't work neither.

Simply saying "it didn't work" does help us help you at all. What didn't work about it? What errors did you get?

Did you try a Force compile of the allegedly corrupted job?

[sigh]

Saying "the run is bad" isn't any more helpful.

Suggestion: stop focusing on this "delete the executable" topic. Take a step back and explain in detail what the heck "the run is bad" means. What is different about the environment where you are having problems?

You do yourself a great disservice by obsessing on a perceived solution when you don't even know (or can articulate) what is wrong.

What's different between the two environments? ("Nothing" is clearly not the correct answer.)

Please post the precise error messages that the job generates when run in the second environment.

DELETE FROM DS_JOBS WHERE JOBNAME='<jobname>'

Umm... that will delete a wee bit more than just the executable.

DataStage jobs do not just comprise a single executable component. There are configuration records, status records, log records for run time, and of course design time components also stored in Repository database tables as well.

Why, particularly, do you want to delete the executable? Without seeing the exact error messages you received, it's impossible to ascertain whether the executable is at fault. One way would be to delete the entire job (say from Designer) and then import just the job design components.

Deleting the record from DS_JOBS without deleting all the other components is singularly bad advice.