Export Job (DSX) command on Unix

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
nishtala
Participant
Posts: 19
Joined: Thu Oct 25, 2007 10:51 am

Export Job (DSX) command on Unix

Post 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
ebmusa
Participant
Posts: 8
Joined: Fri Oct 05, 2007 3:38 pm

Post by ebmusa »

Here is the command for export:

dscmdexport /H hostname /U username /P passowrd /O Omitflag project pathname /V
gateleys
Premium Member
Premium Member
Posts: 992
Joined: Mon Aug 08, 2005 5:08 pm
Location: USA

Re: Export Job (DSX) command on Unix

Post 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.
gateleys
nishtala
Participant
Posts: 19
Joined: Thu Oct 25, 2007 10:51 am

Re: Export Job (DSX) command on Unix

Post by nishtala »

The above commands given are to run on windows, Can we do this on Unix box also ?
Last edited by nishtala on Tue Nov 13, 2007 3:08 pm, edited 1 time in total.
flashgordon
Premium Member
Premium Member
Posts: 99
Joined: Tue Aug 17, 2004 7:50 am
Location: Boulder, Colorado

Post 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
Flash Gordon
Hyperborean Software Solution
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post 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).
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply