DSXchange

Hi There,

We are trying to automate the deployment project where the plan is to script everything which could be run from Command Line (UNIX).

Can anyone throw some light on

1. Template of script for creating a new project (Right now we are using Administrator).

2. Deleting the pre-existing project with same name. We need it for SVT and Testing where we may need to delete and recreate the project several times. (Currently we are using Administrator for the same).

Thanks and regards,

Munish

There's no 'script' to remove or create a new project. And I'm surprised you have a need to delete and recreate test projects 'several times'.

My advice - stick with the Administrator.

Creating a project from command line: eg Deleting a project from command line:
eg The above commands should ideally work from your OS (Unix/ windows) command line if you have necessary permissions (admin user priveleges in datastage)and your 'dsenv' is sourced. As for the scripting and automation part : well you have to check with someone good at unix shell scripting.

Interesting! Not something I was aware of, probably as I've never had a need to pursue this approach. Any idea where this is documented? There are other options here, some of which sound potentially interesting:

-advancedruntime
-customdeployment

And others, so now I'm curious to read about them.

Oh Yeah, i came across these commands pretty recently, probably after reading Vince's blog on Datastage certification, and lo, the secrets of command line interface are revealed in server job developers guide from page 693 of 776 in the pdf document.

Guess I need to revisit that chapter. Usually I'm only there to visit with the 'dsjob' command. Thanks.

Mr. Hulett,

Don't be too hard on yourself, it looks like it didn't make it into the docs until release 7.5.1a or 7.5.2

-Craig

Thanks Guys,
You all are brilliant.
Closing the thread.
Regards,
Munish

For advanced runtime options open any parallel job, open its job properties and find the Execution tab. Then click Help.

ray.wurlod wrote:For advanced runtime options open any parallel job, open its job properties and find the Execution tab. Then click Help.

Wish I could... no got.

Sure you do. razor.

Just to share that it worked fine, I have to make slight modifications to syntax (./ before dsadmin command) (may be Unix specific, not sure though).

Location $DSHome/DSEngine/bin

Delete Project:./dsadmin -deleteproject ProjectTest

Start Project:
./dsadmin -createproject ProjectTest -location /opt/WebSphere/AppServer/Ascential/DataStage/Projects/ProjectTest