Environment variable transporter

leomauer · Post by **leomauer** » Wed May 07, 2008 6:30 am

I need to move server jobs from DS 7.5.1 without PX(EE) on Windows to DS 8.01 with PX on Linux.
We are using a lot of environment variables. In the past I used environment transport program, but that was between DS 7.5 projects.
Is there anything similar for the conversion that I am doing now?
I can't just copy DSParams file because old installation did not have PX and the new one does.
Thanks.

ray.wurlod · Post by **ray.wurlod** » Wed May 07, 2008 3:40 pm

Just copy those rows from DSParams that you need in the new project, and make sure that they are emplaced in the correct section in that project's DSParams file.

Ideally preserve alphabetical order. This is not essential, it just makes the drop-down lists cleaner when adding environment variables to job designs.

lenny · Post by **lenny** » Mon Jun 02, 2008 1:57 pm

Hello Gurus,

I created a New Project and would like to copy User defined Environment Variable from other project.
As Ray said i copied last lines in DSParams file and past in New Project.
It did not work for me.

ray.wurlod wrote:Just copy those rows from DSParams that you need in the new project, and make sure that they are emplaced in the correct section in that project's DSParams file.

Ideally preserve alphabetical order ...

DO we need to restart the server? or do i need to do anything else

Appreciate your Help

leomauer · Post by **leomauer** » Mon Jun 02, 2008 2:15 pm

lenny wrote:Hello Gurus,

I created a New Project and would like to copy User defined Environment Variable from other project.
As Ray said i copied last lines in DSParams file and past in New Project.
It did not work for me.

DO we need to restart the server? or do i need to do anything else

Appreciate your Help

It worked for me, even thought I do not like this solution and would prefer to have a utility.
But I did not copy the whole file from one project to another. I copied and pasted the sections of this file.
To make it work you have to realize that there are 2 sections to be copied:
One starts with:
[EnvVarDefns]
Be careful, there may be more entries in this session then you need. Copy and paste only user defined variables. And do not override whatever already exists in this section of the new file.
Second section starts with
[EnvVarValues]
Same caution needs to be taken.

And you do not need to restart engine.

lenny · Post by **lenny** » Mon Jun 02, 2008 2:41 pm

Thanks for your quick reply

I got it now

Previously I did not copy from [EnvVarDefns] part in the file.

Just curious to know if there is any other way to copy Environment variable from Project to project

Thank you

ray.wurlod · Post by **ray.wurlod** » Mon Jun 02, 2008 5:19 pm

None of which I am aware.

vmcburney · Post by **vmcburney** » Mon Jun 02, 2008 9:49 pm

Wouldn't be surprised if there was something in 8.1 in the new deployment tool.

vmcburney · Post by **vmcburney** » Mon Jun 02, 2008 9:50 pm

Wouldn't be surprised if there was something in 8.1 in the new deployment tool.

ray.wurlod · Post by **ray.wurlod** » Mon Jun 02, 2008 10:19 pm

Would you be surprised if there isn't?

mandyli · Post by **mandyli** » Tue Jun 03, 2008 2:02 am

Hi

we are also facing same kind of problem. where should i find the DSParams file.

Thanks for your help.

ArndW · Post by **ArndW** » Tue Jun 03, 2008 2:42 am

The "DSParams" is found in the project directory for each project.

lenny · Post by **lenny** » Tue Jun 03, 2008 7:13 am

Thanks to every one for your valuable suggestions

BI-RMA · Post by **BI-RMA** » Wed Feb 02, 2011 10:18 am

Hi everybody,

In the Redbook "Infosphere DataStage: Parallel FrameworkStandard practises" on pages 60 and 68 a so called "Environment variable transporter"developed by CEDI ("Center of Exellence in Data Integration")
is mentioned, which should do exactly what is requeted here.

Problem is, the Redbook does not mention a download location and it does not provide any details who or what exactly CEDI is and how it can be contacted. Does anyone know more about this?

leomauer wrote:
lenny wrote:Hello Gurus,

I created a New Project and would like to copy User defined Environment Variable from other project.
As Ray said i copied last lines in DSParams file and past in New Project.
It did not work for me.

DO we need to restart the server? or do i need to do anything else

Appreciate your Help
It worked for me, even thought I do not like this solution and would prefer to have a utility.
But I did not copy the whole file from one project to another. I copied and pasted the sections of this file.
To make it work you have to realize that there are 2 sections to be copied:
One starts with:
[EnvVarDefns]
Be careful, there may be more entries in this session then you need. Copy and paste only user defined variables. And do not override whatever already exists in this section of the new file.
Second section starts with
[EnvVarValues]
Same caution needs to be taken.

And you do not need to restart engine.

ray.wurlod · Post by **ray.wurlod** » Wed Feb 02, 2011 3:13 pm

The new migration tool, initially supplied through the Concierge service but now generally available, also picks up environment variables.

DSXchange