Cannot open file DS_JOBOBJECTS

[giusdepinto]

Hi all,
I have an error on DataStage Designer that does not allow to open and to modify all the jobs on the DS Repository.
The error is "cannot open file DS_JOBOBJECTS"
Someone could help me?

G.

[ray.wurlod]

Welcome aboard! :D

This message is usually the harbinger of bad news. DS_JOBOBJECTS is the pivotal table in the DataStage repository, and this message suggests that it has somehow become corrupted. Or, perhaps, that you lack permission to use it (in which case you'd be getting lots of other errors too!).

Can you open the Director client (which does not use DS_JOBOBJECTS)?

Open the Administrator client Command window on the project, and use the following command to determine whether DS_JOBOBJECTS is intact or corrupted. Note that it must be all upper-case.

Code: Select all

SELECT COUNT(*) FROM DS_JOBOBJECTS;

If you get an error mentioning forward link (flink) or backward link (blink) errors, probably the best thing to do is to create a new project and import all components into that from a prior export of your now ruined project.

If you don't have an export file, disconnect all DataStage clients, rename the project directory, then restore the project directory to its exact original location from a system backup.

If you don't have a system backup or an export of the project, you're totally out of luck.

If there are no errors from the query then it may be that the index to DS_JOBOBJECTS is in need of re-building. Ensure that there are no other clients than your Administrator connected, and execute the command

Code: Select all

DS.REINDEX DS_JOBOBJECTS