Exporting Project
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 19
- Joined: Tue Jul 28, 2009 1:53 pm
Exporting Project
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?
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?
Last edited by datastageETL on Tue Aug 18, 2009 1:36 pm, edited 1 time in total.
-
- Premium Member
- Posts: 19
- Joined: Tue Jul 28, 2009 1:53 pm
-
- Premium Member
- Posts: 19
- Joined: Tue Jul 28, 2009 1:53 pm
-
- Premium Member
- Posts: 19
- Joined: Tue Jul 28, 2009 1:53 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
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Premium Member
- Posts: 19
- Joined: Tue Jul 28, 2009 1:53 pm
-
- Premium Member
- Posts: 19
- Joined: Tue Jul 28, 2009 1:53 pm
This is what I am using, you can use the same but modify it as per your directory structureprolifics 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
E:\apps\IBM\InformationServer\Clients\Classic\dscmdexport.exe /H=AMRNWLW121 /U=username /P=password PROD E:\Tools\Backup\Prod.dsx
-
- Premium Member
- Posts: 19
- Joined: Tue Jul 28, 2009 1:53 pm
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
viewtopic.php?t=128912
And this post for the definition:
viewtopic.php?t=110040
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers