Page 1 of 1

How to take backup of only few Categories of a project

Posted: Thu Jun 08, 2006 8:57 am
by reddy
Hello sir,

Currently i am taking backup of my windows server where my datastage installed (all projects) every week.
But in one of my project(HR) i have to take backup of 2 Categories every day.
Currently i am using windows batch file that contains following code:
*****************************************************
:: Supply values to paramters.
SET Host=156.80.214.58
::SET Host=dwetl-prod.bah.com
SET User=dsadmin
SET PW=adm1n
::SET BackupDir=c:\temp
SET BackupDir=d:\DSETLBackUp\Project
:: SET CompTog=%5
:: GOTO Syntax
:: *****************************************************
:: Hard-coded values. Dependent on each computer.

SET DsxCmd=C:\Progra~1\Ascential\DataStage7.5.1\dscmdexport.exe
::SET DsxJob=C:\Progra~1\Ascential\DataStage\dsjob.exe
SET TempFile=%BackupDir%\ProjList.txt
SET BadFile=%BackupDir%\BadProj.txt
SET GoodFile=%BackupDir%\GoodProj.txt
SET DSLog=BackupLog
:: SET CompScri=gzip --name -3
:: ******************************************************
Can you guys help me out how to take only few categories of one of my project.

Thanks in advance
Narasa

Posted: Thu Jun 08, 2006 9:00 am
by DSguru2B
command line backup is project wide and cannot be done (as per my knowledge) on a category or job basis.

Posted: Thu Jun 08, 2006 9:02 am
by reddy
Thanks alot for quick response.
Any other thoughts please.
Thanks
Narasa

Posted: Thu Jun 08, 2006 9:06 am
by kumar_s

Code: Select all

DSExport /U=%UserName% /P=%Password% /H=%Host% /JOB=JobName %Project% FileName 
Use the above option to export job wise. You can pass the list of jobs in a category as parameter.

Posted: Thu Jun 08, 2006 9:20 am
by DSguru2B
So we can do it on a per job basis. All this time i was under the impression that it could only be done project wide. Thanks for the insight Kumar. :)