Is it possible to automate the DataStage export of an entire
Moderators: chulett, rschirm, roy
Is it possible to automate the DataStage export of an entire
Hello all. Is it possible to automate the export of an entire project via a batch job. I would like to run the export of an entire project via a schedule batch process.
Thanks in advance for any help.
Thanks in advance for any help.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Yes it is. Search DSXchange for dscmdexport command, possibly in combination with "BAT".
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Premium Member
- Posts: 232
- Joined: Fri Aug 04, 2006 1:20 am
- Location: Bangalore
Check in Kim Dukes website, he is having a batch utility to export all the projects in a server.
I have problems too
Our version is 8.0.1
I'm trying to do it now, with dscmdexport command and dsexport command, and with both i have the same problem, when the export has finished i can't found some items in it, READ ONLY ITEMS has not been included.
I don't know what is the solution.
I'm trying to do it now, with dscmdexport command and dsexport command, and with both i have the same problem, when the export has finished i can't found some items in it, READ ONLY ITEMS has not been included.
I don't know what is the solution.
Best Regards,
Jorge Calvo
Jorge Calvo
-
- Participant
- Posts: 7
- Joined: Fri Mar 20, 2009 9:09 pm
Re: I have problems too
We have same version running on windows, and we are running auto export job everynight on all our environments. Its running without any issues. Please try to use following command...If you have any problem let me know...
Code: Select all
istool.exe export -dom %Domain% -u %User% -p %Password% -ar %ProjectDir%/%Project%.isx -ds ' -incdep -incexec "%Domain%/%Project%/*/*.*"' >> %ProjLogFileName%
Re: Is it possible to automate the DataStage export of an en
Exactly, in our version we haven't this tool.
Best Regards,
Jorge Calvo
Jorge Calvo
I wonder why I can not get the command functioning. I do have a lot of content in my project, but the export does nothing. It does not even create an empty target file, please see output below.
BTW, what is file extension .isx used here? Is the format supposed to be somehow different from regular .dsx?
BTW, what is file extension .isx used here? Is the format supposed to be somehow different from regular .dsx?
Code: Select all
C:\dsbackup>C:\IBM\InformationServer_v8.1\Clients\istools\cli\istool.exe export
-dom etlmc-t1:9080 -u myusername -p mypassword -ar 001_VVDW_T.isx -ds '"ETLMC-T1.POSTI.FI/001_VVDW_T/*/*.*"'
Beginning Export
Elapsed time: 00:00:06
Exported 0 assets
C:\dsbackup>
I am answering my own question. There seems to be a bug as reported here: viewtopic.php?t=128327&highlight=istools