Some jobs had the OCI Stage in it while we developed. Suddenly all the Databse Stages have greyed out. It is throwing this message while opening the already developed jobs."When I try to open my jobs it gives a message that "Record PxOracle in file DS_STAGETYPES does not exist".and I dont see Oracle stage in my jobs" which was exisisting before.
Regards
Pratim
Problem with Oracle Stage
Moderators: chulett, rschirm, roy
-
ray.wurlod
- Participant
- Posts: 54595
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Welcome aboard. :D
This behaviour suggests that the index on DS_STAGETYPES needs to be rebuilt. You need to find a time when no client connection exists into DataStage in that project, and issue the command DS.REINDEX DS_STAGETYPES
You may as well make sure they're all intact: prefer DS.REINDEX ALL as the command.
This behaviour suggests that the index on DS_STAGETYPES needs to be rebuilt. You need to find a time when no client connection exists into DataStage in that project, and issue the command DS.REINDEX DS_STAGETYPES
You may as well make sure they're all intact: prefer DS.REINDEX ALL as the command.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.