DSXchange

Hi,


I imported a DataStage job from dev to QA.
I cannot see these job in repository. But, when I do following command in unix, it shows me the job under that project
And when I try to import the same job again in QA, it gives me below error.
And during import when I see details, it says that Job Design is missing but Job Executable is present.

Do you guys know how can I delete the existing Job Executable.

Don't forget there are two repositories in play now. Best to get support involved. IMHO.

Craig,

I am also thinking of involving IBM, but before that I want to discuss this with my senior DataStage Developer.

I did some research and I found on IBM's website saying that the project might be corrupted. As I can see the Job present in Director but it is missing in Designer.

http://www-01.ibm.com/support/docview.w ... wg21574001

And when I followed the steps in the below link. I could find the Job a Job Number associated with the Job.(I did not do the delete part)

http://publib.boulder.ibm.com/infocente ... layer.html

Well, from a technical viewpoint, the repository is definitely corrupted in that a job is not represented in its entirety in both the uniVerse and XMETA databases.

However, if it is just a case of a job not being completely stored, there may be a quick fix to resolve that.

Try the following:

1) Create a copy of the job
2) Verify the job looks correct (has all stages, compiles, etc.)
3) Delete the original job
4) Rename the copy

Alternatively:
1) Dump the job to DSX
2) Delete the original job
3) Load the DSX

That usually will resolve the missing pieces in the repository. If, however, it won't let you delete the job or overlay it, then you really do have a corrupted project and will need to run recovery procedures. Don't delay - it will probably get worse over time.

It is not allowing me to delete the job.()

So, I think the only option left is to do the recovery procedure by running the SyncProject Script.