How to convert datastage assets into .isx file on Windows

kirankumarreddydesireddy · Wed Nov 30, 2011 8:29 am

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

chulett · Post by **chulett** » Wed Nov 30, 2011 9:35 am

See if this helps.

kirankumarreddydesireddy · Wed Nov 30, 2011 9:43 am

Let me try these options from command prompt

Thanks
Kiran

kirankumarreddydesireddy · Thu Dec 01, 2011 5:05 am

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

chulett · Post by **chulett** » Thu Dec 01, 2011 7:30 am

There is nothing different, UNIX to Windows, other than the path to the executable. All those syntax examples are still applicable to you.

kirankumarreddydesireddy · Thu Dec 01, 2011 8:56 am

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

ghila · Post by **ghila** » Thu Dec 01, 2011 9:47 am

Try using -datastage ' -incexec -nodesign "dsetltest2he/<project name>/Jobs/*.*" '

ghila · Post by **ghila** » Thu Dec 01, 2011 9:49 am

or -datastage ' -incexec "<hostname>/<project name>/Jobs/*.*" ' if you want job design with depended objects

kirankumarreddydesireddy · Thu Dec 01, 2011 10:22 am

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

chulett · Post by **chulett** » Thu Dec 01, 2011 1:24 pm

Replace "default" with your actual project name.

ray.wurlod · Post by **ray.wurlod** » Thu Dec 01, 2011 1:49 pm

Project names are case sensitive. Is it possible that your project name is actually "Default" or "DEFAULT"?

kirankumarreddydesireddy · Thu Dec 01, 2011 11:56 pm

The project name given does exist and it is correct.

project name = default

Let me try some other options

Thanks
Kiran