about Datastage Job Backup Automatically

mandyli · Post by **mandyli** » Mon May 15, 2006 12:18 am

Hi

In our project I am taking every week backup of Datastage project using export oprion in DS manager.

my question is any other way automatically take backup of DS project.
b'cus i am planning to write script or routine for taking backup. please help me out for this.

Thanks
Man

ray.wurlod · Post by **ray.wurlod** » Mon May 15, 2006 1:06 am

Quite a few sites of which I am aware use dscmdexport from a BAT file to take an export of their projects. This can be automated through the AT scheduler.

chulett · Post by **chulett** » Mon May 15, 2006 6:18 am

There's quite a nice backup script posted at ADN, if you have a logon there.

mandyli · Post by **mandyli** » Wed May 17, 2006 12:54 am

Hi Chulett,

Thanks for your mail. i amnot able to login ADN b'cus i amnot memeber IBM customer. any other way .

kduke · Post by **kduke** » Wed May 17, 2006 5:58 am

I modified it a little bit and posted it on my tips page.

Lotus26 · Post by **Lotus26** » Wed May 17, 2006 2:50 pm

kduke wrote:I modified it a little bit and posted it on my tips page.

Duke

Can you please tell me how to use this Script. Thanks in Advance

Regards
Lotus

kduke · Post by **kduke** » Wed May 17, 2006 6:48 pm

I create a little batch file like this:

Code: Select all

:: -----------------------------------------------------------------
:: Host is server name
:: User is username to use to attach to DataStage
:: Password   is password to use to attach to DataStage
:: BackupDir is the directory to place the backed up project in
:: -----------------------------------------------------------------
:: Dwn_ExecTCL.exe -n -sMyProject -uuserid -puserPwd UNLOCK READULOCK UV
DataStageBackup.bat MyProject userid userPwd c:\DataStage\KimD\Backups

Uncomment Dwn_ExecTCL.exe if you want to unlock all your jobs. This command needs to be in the folder. There are several posts on this. You need to edit the batch file and figure it out.