DataStage Export

rpdeepak.kumar · Post by **rpdeepak.kumar** » Thu Feb 14, 2008 5:24 am

Hi.

can you please tell me about Incremental Backup of Datastage jobs.

How do we do Incremental backup.

Thanks
RP

ArndW · Post by **ArndW** » Thu Feb 14, 2008 5:30 am

I assume that you mean incremental backups in a project, where a subsequent backup only saves those jobs which have changed or been added since the last backup.
The mechanisms that support automated backups of DataStage unfortunately do not have such a capability.
It is possible, through use of the documented API routine calls and through reading the DS_AUDIT hashed file, to put together some code or scripts that will allow incremental backups. I don't think that the effort is worth it, though, since doing a complete project backup and compressing the resulting .dsx file results in a relatively small daily file, and it is much easier to restore from a full backup set than it is to trace back through incremental updates in order to find a specific job.

ray.wurlod · Post by **ray.wurlod** » Thu Feb 14, 2008 6:10 am

How soon is the interview?

JoshGeorge · Post by **JoshGeorge** » Thu Feb 14, 2008 4:43 pm

Version Control tool in DataStage Release 7x is worth looking into. There is a good post in FAQ section. Many uses this tool for backups as well.