Deployment Automation

Munish · Post by **Munish** » Thu Mar 01, 2007 4:22 am

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

chulett · Post by **chulett** » Thu Mar 01, 2007 7:59 am

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.

rameshrr3 · Post by **rameshrr3** » Thu Mar 01, 2007 8:21 am

Creating a project from command line:

Code: Select all

dsadmin -createproject ProjectName [-location ProjectLocation]

eg

Code: Select all

[color=darkred]dsadmin -createproject Test -location /home/dsdev/Test[/color]

Deleting a project from command line:

Code: Select all

dsadmin -deleteproject ProjectName

eg

Code: Select all

[color=darkred]dsadmin -deleteproject Test[/color]

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.

chulett · Post by **chulett** » Thu Mar 01, 2007 8:36 am

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.

rameshrr3 · Post by **rameshrr3** » Thu Mar 01, 2007 8:40 am

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.

chulett · Post by **chulett** » Thu Mar 01, 2007 8:50 am

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

crouse · Post by **crouse** » Thu Mar 01, 2007 9:32 am

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

Munish · Post by **Munish** » Thu Mar 01, 2007 4:51 pm

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

ray.wurlod · Post by **ray.wurlod** » Thu Mar 01, 2007 7:22 pm

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

chulett · Post by **chulett** » Thu Mar 01, 2007 8:05 pm

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.

ray.wurlod · Post by **ray.wurlod** » Thu Mar 01, 2007 8:27 pm

Sure you do. razor.

Munish · Post by **Munish** » Fri Mar 02, 2007 1:05 am

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

DSXchange

Deployment Automation

Deployment Automation

What do you want?