Export Whole Datastage Project in Unix Script

mac4rfree85 · Post by **mac4rfree85** » Fri Dec 02, 2011 3:52 am

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!!!!

meet_deb85 · Post by **meet_deb85** » Fri Dec 02, 2011 3:57 am

dsjob as the name suggests is used for job related activities like running,reseting the job etc.

meet_deb85 · Post by **meet_deb85** » Fri Dec 02, 2011 4:04 am

Check the options with istool "-datastage" option.

arvind_ds · Post by **arvind_ds** » Fri Dec 02, 2011 8:24 am

Use below.

http://publib.boulder.ibm.com/infocente ... 2%74%22%20

arvind_ds · Post by **arvind_ds** » Fri Dec 02, 2011 8:35 am

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>

qt_ky · Post by **qt_ky** » Fri Dec 02, 2011 4:13 pm

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.

fmou · Post by **fmou** » Wed Dec 14, 2011 12:29 pm

The default extension of the archive file is .isx.

Is the .isx archive file still text based or now binary?

thx

chulett · Post by **chulett** » Wed Dec 14, 2011 2:12 pm

From what I understand (but never tried) it is basically a 'compressed' dsx file and you can unzip it.

eph · Post by **eph** » Thu Dec 15, 2011 3:13 am

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

fmou · Post by **fmou** » Thu Dec 15, 2011 9:29 pm

Thanks, chulett & eph .

mark1024 · Post by **mark1024** » Fri Dec 16, 2011 11:51 am

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.

pandeesh · Post by **pandeesh** » Fri Dec 16, 2011 12:01 pm

DSCMDEXPORT can also be used..

ray.wurlod · Post by **ray.wurlod** » Fri Dec 16, 2011 2:20 pm

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.

pandeesh · Post by **pandeesh** » Fri Dec 16, 2011 7:32 pm

Yes .he can write a windows batch script and schedule the same

qt_ky · Post by **qt_ky** » Fri Dec 16, 2011 7:35 pm

Yes, but take a look at the name of this topic... dscmdexport is... off-topic.

DSXchange

Export Whole Datastage Project in Unix Script

Export Whole Datastage Project in Unix Script

Re: Export Whole Datastage Project in Unix Script