Page 1 of 1

Export Job (DSX) command on Unix

Posted: Tue Nov 13, 2007 10:50 am
by nishtala
Hi All,

Is there a command which I can run on unix environment to create .DSX file (export) every night.

And is there a possible way to automate this process daily.

Thanks in advance
Nishy

Posted: Tue Nov 13, 2007 11:00 am
by ebmusa
Here is the command for export:

dscmdexport /H hostname /U username /P passowrd /O Omitflag project pathname /V

Re: Export Job (DSX) command on Unix

Posted: Tue Nov 13, 2007 11:05 am
by gateleys
nishtala wrote: And is there a possible way to automate this process daily.
Yeah, wrap it up in an Execute Command Stage in a sequence job, and schedule the sequence every night.

Re: Export Job (DSX) command on Unix

Posted: Tue Nov 13, 2007 2:40 pm
by nishtala
The above commands given are to run on windows, Can we do this on Unix box also ?

Posted: Tue Nov 13, 2007 2:41 pm
by flashgordon
Hi,

This is something I did with a bat file that made the dsx file name unique every night. Does anyone know how to exclude the "binaries" with dscmdexport. Does anyone know when Ascential is going to make the backup work on the server machine?

set /A MM = %DATE:~4,2%
set /A DD = %DATE:~7,2%
set /A YR = %DATE:~10,4%


"C:\Program Files\Ascential\DataStage7.5.2\dscmdexport.exe" /H=server.domain.com /U=uid /P=pw MyProjectNameHere c:\xDSBackup\bkpINSTALL%YR%%MM%%DD%.dsx

Posted: Tue Nov 13, 2007 4:09 pm
by ray.wurlod
Never, because Ascential no longer exists. :wink:

If enough people ask for it, IBM may do so. Submit enhancement requests through your support provider or through DSXchange or through DeveloperWorks (if it still exists).