Page 1 of 1

Is it possible to automate the DataStage export of an entire

Posted: Wed Jun 11, 2008 4:22 pm
by tbtcust
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.

Posted: Wed Jun 11, 2008 4:53 pm
by ray.wurlod
Yes it is. Search DSXchange for dscmdexport command, possibly in combination with "BAT".

Posted: Wed Jun 11, 2008 10:33 pm
by DS_SUPPORT
Check in Kim Dukes website, he is having a batch utility to export all the projects in a server.

Posted: Thu Jun 12, 2008 6:39 am
by tbtcust
Thank you both. This is very good info and should work for me.

Posted: Tue Sep 22, 2009 12:08 am
by mandyli
Hi

In IIS VERSION 8.01 dscmdexport is not working.

Any other option is there for exporting datastage project.

Posted: Tue Sep 22, 2009 12:26 am
by lstsaur
I have no problem to use the dscmdexport (version 8.0.1); it works just fine. What's the error message?

I have problems too

Posted: Tue Oct 13, 2009 5:45 am
by J.Calvo
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.

Re: I have problems too

Posted: Tue Oct 13, 2009 7:18 am
by nirav_2004
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%

Posted: Tue Oct 13, 2009 7:27 am
by chulett
That istool is only available in 8.1.1 with that 'comprehensive' patch installed.

Re: Is it possible to automate the DataStage export of an en

Posted: Tue Oct 13, 2009 9:29 am
by J.Calvo
Exactly, in our version we haven't this tool.

Posted: Mon Nov 02, 2009 2:50 am
by platonfi
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?

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>

Posted: Mon Nov 02, 2009 3:31 am
by platonfi
I am answering my own question. There seems to be a bug as reported here: viewtopic.php?t=128327&highlight=istools

Posted: Mon Nov 02, 2009 7:37 am
by chulett
A known bug with an available patch, yes, as noted in that same thread.