Page 1 of 2
Export Whole Datastage Project in Unix Script
Posted: Fri Dec 02, 2011 3:52 am
by mac4rfree85
Hi Guys,
I am using Datastage 8.5. I am writing a script which will run every sunday to export the whole datastage project.
Is there a option "-export" in dsjob command???
Or how to export the whole project from unix prompt.
Cheers!!!!
Posted: Fri Dec 02, 2011 3:57 am
by meet_deb85
dsjob as the name suggests is used for job related activities like running,reseting the job etc.
Posted: Fri Dec 02, 2011 4:04 am
by meet_deb85
Check the options with istool "-datastage" option.
Posted: Fri Dec 02, 2011 8:24 am
by arvind_ds
Posted: Fri Dec 02, 2011 8:35 am
by arvind_ds
FROM UNIX CLI : You can use the istool command line interface (CLI) to export assets to an archive file. The default extension of the archive file is .isx.
istool export <specify your export options here>
Posted: Fri Dec 02, 2011 4:13 pm
by qt_ky
There are examples of istool export syntax on this web site as well as in the Admin Guide. The dsjob command will not export a project.
Posted: Wed Dec 14, 2011 12:29 pm
by fmou
The default extension of the archive file is .isx.
Is the .isx archive file still text based or now binary?
thx
Posted: Wed Dec 14, 2011 2:12 pm
by chulett
From what I understand (but never tried) it is basically a 'compressed' dsx file and you can unzip it.
Posted: Thu Dec 15, 2011 3:13 am
by eph
Hi,
As I've seen, it's a zip containing xml exports. The odd thing is that this xml export is different from the Desiner one (xml not formated with the same xml tags).
From my experience, I got less problems with isx than dsx, at least for huge exports (whole projet in one file). One can also use the IS Manager to create a backup package, it also use isx files, though I don't know if you can call the manager using command line or script.
Eric
Posted: Thu Dec 15, 2011 9:29 pm
by fmou
Thanks, chulett & eph .
Re: Export Whole Datastage Project in Unix Script
Posted: Fri Dec 16, 2011 11:51 am
by mark1024
I do the same thing, but use it for promotion between environments
istool export -archive Quickwin_jobs.dsx -domain linux50 -u username -p "password -ds ' "linux50/esa_dev/Jobs/QWin_test/*/*.*" -includ
edependent -incexec'
. Dev to test and to prod.
I include the dependents and the executable. that way the other environments don't have to recompile.
Cron job does the backup. putting it to tape.
Posted: Fri Dec 16, 2011 12:01 pm
by pandeesh
DSCMDEXPORT can also be used..
Posted: Fri Dec 16, 2011 2:20 pm
by ray.wurlod
A couple of points.
The dscmdexport command is only available on the client. Therefore it can not be used in a UNIX script.
If you're exporting the whole project (*/*.*) then -includedependent is redundant.
Posted: Fri Dec 16, 2011 7:32 pm
by pandeesh
Yes .he can write a windows batch script and schedule the same
Posted: Fri Dec 16, 2011 7:35 pm
by qt_ky
Yes, but take a look at the name of this topic... dscmdexport is... off-topic.