Page 1 of 1

Backup of DataStage environment

Posted: Mon Sep 28, 2009 1:16 am
by Flash
Hi,
I want to find out when backing up the DataStage environment, besides backing up the DS project (ie. where the source codes are), what other files and directories (in the Unix level) do I need to back up? That is, when a DS system file or directory got corrupted, I need to be able to restore it from backup.

The DataStage version that we are using is 7.5.1.A.

Any help will be much appreciated.

Thanks.

Posted: Mon Sep 28, 2009 1:39 am
by ray.wurlod
Welcome aboard.

If you installed DataStage using all defaults, pretty much everything is in one directory (for example /usr/Ascential/DataStage) so backing that up (while there is no DataStage activity) should suffice.

This will change if you have created other directories on other file systems for things such as Data Sets, File Sets and hashed files - you need to keep track of these and back them up also.

Posted: Mon Sep 28, 2009 7:10 am
by chulett
So, one typically takes a 'two pronged' approach - backup everything (Engine, projects, the works) at the filesystem level and also take exports of all projects. With those you should be able to recover from pretty much anything.

Posted: Wed Oct 07, 2009 6:19 pm
by Flash
Thanks guys. This is what I am after.