Recover the deleted job
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 17
- Joined: Mon Sep 10, 2007 3:24 am
Recover the deleted job
I accidentally deleted one category.Is there any way to recover that?I am using datastage 7.5.2.help me to solve this.
-
- Participant
- Posts: 17
- Joined: Mon Sep 10, 2007 3:24 am
asorrell wrote:Once the job is deleted there's no way I know of to recover it other than your normal system backups. That's why I have created an automated job that backs up every job in every project every single day (In Development).
If i made the server backup whether i can able to recover that job.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
If nothing else has changed in the interim, make sure no-one is using the project and no jobs are running, then rename the following objects then restore the originals from backup:
DS_JOBS
DS_JOBOBJECTS
I_DS_JOBS
I_DS_JOBOBJECTS
If that is successful (in terms of recovering the deleted category), delete the renamed objects at some convenient time.
DS_JOBS
DS_JOBOBJECTS
I_DS_JOBS
I_DS_JOBOBJECTS
If that is successful (in terms of recovering the deleted category), delete the renamed objects at some convenient time.
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.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
It's a matter of priorities. If you restore from backup as indicated, you get back the system as at the time of backup (assuming that the backup is a good one) and lose anything created/amended since that time.
Of course, were you to export the newer objects/changed objects before attempting the above process, you could have your cake and eat it.
Of course, were you to export the newer objects/changed objects before attempting the above process, you could have your cake and eat it.
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.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
A heavier emphasis is probably indicated on the fact that this solution is for versions earlier than 8.0 only.
It's rather more difficult once you have version 8.0 and the unified metadata repository - so greater care should be taken in backing up - in taking regular exports of projects in which changes are being wrought.
It's rather more difficult once you have version 8.0 and the unified metadata repository - so greater care should be taken in backing up - in taking regular exports of projects in which changes are being wrought.
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.