Exporting Project

datastageETL · Post by **datastageETL** » Tue Aug 18, 2009 12:57 pm

Hi All,
I am using the command to export my project for back up purposes.

E:\apps\IBM\InformationServer\Clients\Classic\dscmdexport.exe /H=AMRNWLW121 /U=username /P=password PROD E:\Tools\Backup\Prod.dsx

user - username is set up as a super operator

I can run this script manually or through vbs file on all our servers (DEQ/QA/Prod)

One of my colleague, who has same permissions as me is able to run this script only on QA but not on DEV and PROD. Also, I cannot run the script through Autosys to perform a scheduled backup.

The following is the error message

Attaching to 'DEV' ...
dscmdexport aborted:
Failed to attach to the project

Could someone let me know if this is because of any permissions issues?

kduke · Post by **kduke** » Tue Aug 18, 2009 12:59 pm

What user does Autosys run as?

Never post user names or passwords. Edit your post please.

chulett · Post by **chulett** » Tue Aug 18, 2009 1:04 pm

From what we've seen here, for 8.x you need to include the "domain" credential as well.

datastageETL · Post by **datastageETL** » Tue Aug 18, 2009 1:37 pm

kduke wrote:What user does Autosys run as?

Never post user names or passwords. Edit your post please.

Autosys runs under a user who has administrative rights

datastageETL · Post by **datastageETL** » Tue Aug 18, 2009 1:38 pm

chulett wrote:From what we've seen here, for 8.x you need to include the "domain" credential as well.

Then, how come I am able to run but not my colleague

chulett · Post by **chulett** » Tue Aug 18, 2009 1:43 pm

Depends on your network topology, it seems. This is exactly what we've seen here, works for some but not for others. Adding the domain option makes it work for everyone.

datastageETL · Post by **datastageETL** » Tue Aug 18, 2009 1:46 pm

chulett wrote:Depends on your network topology, it seems. This is exactly what we've seen here, works for some but not for others. Adding the domain option makes it work for everyone.

oh ok - let me add that and ask my colleague to try it. I will let you know if it works

prolifics · Post by **prolifics** » Tue Aug 18, 2009 2:39 pm

Hi,

Can you please sent me the script for the Exporting the Datastage project .I am new to datastage and need your help.

Appreciate, if you can email at kapeel24@gmail.com

thanks
KJ

chulett · Post by **chulett** » Tue Aug 18, 2009 3:12 pm

It's not a script, just a single command. If you want an actual script that will export all projects on your server to date stamped output files, there's a script on Kim Duke's website in the DS Tips section you can take and modify to your heart's content, if so desired.

datastageETL · Post by **datastageETL** » Thu Aug 20, 2009 6:41 am

I tried with Domain option but it is still the same. My colleague cannot run it and I cannot schedule with Autosys.

datastageETL · Post by **datastageETL** » Thu Aug 20, 2009 6:42 am

prolifics wrote:Hi,

Can you please sent me the script for the Exporting the Datastage project .I am new to datastage and need your help.

Appreciate, if you can email at kapeel24@gmail.com

thanks
KJ

This is what I am using, you can use the same but modify it as per your directory structure

E:\apps\IBM\InformationServer\Clients\Classic\dscmdexport.exe /H=AMRNWLW121 /U=username /P=password PROD E:\Tools\Backup\Prod.dsx

chulett · Post by **chulett** » Thu Aug 20, 2009 7:28 am

Don't see a domain there anywhere.

datastageETL · Post by **datastageETL** » Mon Aug 24, 2009 9:56 am

chulett wrote:Don't see a domain there anywhere.

I replied it to Prolifics on my command. Here is the revised command that I used without any success

E:\apps\IBM\InformationServer\Clients\Classic\dscmdexport.exe /H=AMRNWLW121 /D=AMER /U=username /P=password PROD E:\Tools\Backup\Prod.dsx

chulett · Post by **chulett** » Mon Aug 24, 2009 10:27 am

That domain doesn't look correct. See this thread for what I believe you need to do, including the port number. Yes, it's for dsjob rather than dscmdexport but it still applies as far as I know:

viewtopic.php?t=128912

And this post for the definition:

viewtopic.php?t=110040