How to import datastage job

[suneel Pocha]

Hi All,

I Import datastage jobs.But i want old job.I don't have backup.
So Please tell me how to retrive old jobs.

thanks in advancde

regards,
Sunil

[jhmckeever]

Hi Sunil ,

Without a backup of your old job then I think you're out of luck. Importing a job (or any other object, for that matter) into the repository replaces identically named objects irreversibly.

Are you sure you definitely don't have a DSX somewhere that contains the prior job definition?

Do you have a backup of the entire project? (If not, I suggest you implement a backup strategy immediately!) If you do, you could perform a restore from that, however you'd obviously loose all changes made since that repository backup was taken.

J.

[ray.wurlod]

It's not irreversible, but does require expert help. Involve your support provider.

Most of what has to be done may be found in my paper onrecovering after deleting a DataStage project

[jhmckeever]

Thanks for that Ray - That's news to me!

So if I (or the OP) have a project containing version 1 of a job and I then import into the same project a version 2 of this job (with the same name) then there's still scope for recovering the original version from somewhere within the repository (i.e. without having a backup DSX)?

That certainly changes my view of how the repository works, or am I misunderstanding your response?

Thanks again,
JMcK.

[ray.wurlod]

No, it's much harder at the individual component (object) level. To do that, you'd need to restore your backup elsewhere (with more things to fix, such as the index headers using SET.INDEX) then export from the restored project before you could import into your current project.

Like I said, it's doable but it requires expertise.

[chulett]

In other words, all recovery comes from a backup. How you use that backup is what Ray is writing about.