Page 1 of 1

How to convert datastage assets into .isx file on Windows

Posted: Wed Nov 30, 2011 8:29 am
by kirankumarreddydesireddy
We are migrating from Datastage 7.5v server edition(Windows 2003 server) to Infosphere 8.5v server edition(Windows 2008 server)

We have been using Datastage Version Control in 7.5v.We found that this component has been replaced with InfoSphere Information Server Manager

I had did some hands on "InfoSphere Information Server Manager" from the IBM website

http://publib.boulder.ibm.com/infocente ... htool.html

What I didn't understand was that, they initially had the archive file (.isx) and from there, they have explained how to deploy datastage assets between projects.


I am not sure how to generate the .isx file from the datastage jobs that I need to deploy from one project to other.


I did see some needful information on the dsxchange forum using istool command to convert into .isx,however we are using the Windows 2008 server(Infosphere 8.5 server edition).

Can someone explain me how to create the .isx file from the datastage assets(jobs) on Windows server using istool command


Thanks
Kiran

Posted: Wed Nov 30, 2011 9:35 am
by chulett
See if this helps.

Posted: Wed Nov 30, 2011 9:43 am
by kirankumarreddydesireddy
Let me try these options from command prompt

Thanks
Kiran

Posted: Thu Dec 01, 2011 5:05 am
by kirankumarreddydesireddy
As mentioned above,we are using Infosphere 8.5 server edition on Windows 2008 server.

The info you mentioned above was related to Unix server.


Can you please let me how to create the .isx file from the datastage assets(jobs) on Windows 2008 server using istool command?

Or

Is there any other option other than using istool command?



Thanks
Kiran

Posted: Thu Dec 01, 2011 7:30 am
by chulett
There is nothing different, UNIX to Windows, other than the path to the executable. All those syntax examples are still applicable to you.

Posted: Thu Dec 01, 2011 8:56 am
by kirankumarreddydesireddy
Hi Chulett

I have tried the below options from command prompt.

1. istool export -domain dsetltest2he:9080 -username etltestadmin -password xxxxxxx -archive testfile.isx -datastage ' "dsetltest2he.ds.ad.adp.com/default/Jobs/*.*" '

2. istool export -domain dsetltest2he:9080 -username etltestadmin -password xxxxxxx -archive testfile.isx -datastage ' "dsetltest2he.ds.ad.adp.com:9080/default/Jobs/*.*" '


However it gave me below error

"Export failed: Project not found : default"

The project "default" does exist.

I am not sure why it prompting this error.


Thanks
Kiran

Posted: Thu Dec 01, 2011 9:47 am
by ghila
Try using -datastage ' -incexec -nodesign "dsetltest2he/<project name>/Jobs/*.*" '

Posted: Thu Dec 01, 2011 9:49 am
by ghila
or -datastage ' -incexec "<hostname>/<project name>/Jobs/*.*" ' if you want job design with depended objects

Posted: Thu Dec 01, 2011 10:22 am
by kirankumarreddydesireddy
I am still getting the error with the below

istool export -domain dsetltest2he:9080 -username etltestadmin -password xxxxxxx -archive testfile.isx -datastage ' -incexec "dsetltest2he.ds.ad.adp.com/default/Jobs/*.*" '


"Export failed: Project not found : default"




Thanks
Kiran

Posted: Thu Dec 01, 2011 1:24 pm
by chulett
Replace "default" with your actual project name.

Posted: Thu Dec 01, 2011 1:49 pm
by ray.wurlod
Project names are case sensitive. Is it possible that your project name is actually "Default" or "DEFAULT"?

Posted: Thu Dec 01, 2011 11:56 pm
by kirankumarreddydesireddy
The project name given does exist and it is correct.

project name = default

Let me try some other options

Thanks
Kiran