Page 1 of 1

DataStage Export

Posted: Thu Feb 14, 2008 5:24 am
by rpdeepak.kumar
Hi.

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

How do we do Incremental backup.

Thanks
RP

Posted: Thu Feb 14, 2008 5:30 am
by ArndW
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.

Posted: Thu Feb 14, 2008 6:10 am
by ray.wurlod
How soon is the interview?

Posted: Thu Feb 14, 2008 4:43 pm
by JoshGeorge
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.