DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
skathaitrooney
Participant



Joined: 06 Jan 2015
Posts: 103

Points: 923

Post Posted: Fri Jul 10, 2020 7:00 am Reply with quote    Back to top    

DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Hello Experts, i want to know if somebody has nice techniques to export DataStage project environment variables from the command line which could then be imported into a target datastage project?

Our team is currently in a phase of migrating DataStage projects from 11.5 to 11.7 version and we do not want to export and import manually via the DSAdministrator client.

I thought of copying DSParams from the 11.5 version to the 11.7 version directly. It works pretty ok to be honest but i dont think IBM encourages to do that,

Does anybody have better ideas on this one ?
qt_ky



Group memberships:
Premium Members

Joined: 03 Aug 2011
Posts: 2897
Location: USA
Points: 21971

Post Posted: Sun Jul 12, 2020 5:49 am Reply with quote    Back to top    

I consider creating environment variables one by one a manual process. The export and import options in the Administrator client save a lot of time. That's the method we are using to migrate now. It's pretty simple work to do and is only done once per project.

The dsadmin command line tool may have the options you could use.

Commands for administering projects
https://www.ibm.com/support/knowledgecenter/SSZJPZ_11.7.0/com.ibm.swg.im.iis.ds.cliapi.ref.doc/topics/r_dsvjbref_Commands_for_Administering_WebSphere_DataStage.html

That said, I suspect that in the time it takes to research automation, someone could quickly and easily grind through and export/import across all projects.

_________________
Choose a job you love, and you will never have to work a day in your life. - Confucius
Rate this response:  
Not yet rated
PaulVL



Group memberships:
Premium Members

Joined: 17 Dec 2010
Posts: 1310

Points: 8608

Post Posted: Mon Jul 13, 2020 8:07 am Reply with quote    Back to top    

I would NOT recommend copying the dsparms file from one project to another. You do not know if the difference in release level of datastage also constitutes new or removed entries in the dsparms file.

You could script it, but then again, you will have trouble separating the user parms vs the default project (tool) parms.

As an administrator of many years... I would not script that (and I love scripting stuff). Use the GUI admin tool, highlight the user section and copy those entries. You can export it into a file and load into the other host/project.

Ask your admin if there were any other non user entries that have been changed from their default values and edit those accordingly.
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours