Recover the deleted job

ithirak_17 · Post by **ithirak_17** » Fri Jan 08, 2010 12:08 pm

I accidentally deleted one category.Is there any way to recover that?I am using datastage 7.5.2.help me to solve this.

IBM Analytics Champion 2009 - 2020 · Post by **asorrell** » Fri Jan 08, 2010 1:22 pm

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).

ithirak_17 · Post by **ithirak_17** » Fri Jan 08, 2010 2:46 pm

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.

chulett · Post by **chulett** » Fri Jan 08, 2010 3:17 pm

A filesystem level backup of the entire server? No, I don't believe so, not just those few jobs. If you had an export of your projects, then yes and that is what Andy was referring to, I'd wager.

ray.wurlod · Post by **ray.wurlod** » Fri Jan 08, 2010 5:14 pm

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.

chulett · Post by **chulett** » Fri Jan 08, 2010 10:19 pm

Heavy, heavy emphasis on the "If nothing else has changed in the interim" part.

ray.wurlod · Post by **ray.wurlod** » Fri Jan 08, 2010 10:52 pm

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.

ray.wurlod · Post by **ray.wurlod** » Fri Jan 08, 2010 10:54 pm

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.