DSXchange

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?

What user does Autosys run as?

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

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

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

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

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.

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

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

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.

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

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

Don't see a domain there anywhere.

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

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