DSXchange

Hello DataStage Gurus!!!!!!!!!!!

We have tasks to --
1. Add 2 new job level parameters to 300 DataStage jobs
2. Remove Default Values of Parameters for 300 DataStage jobs

We want to know -- what is easy and safe way to achieve above objectives without manually changing each job. Our colleagues have been taking few options, for example:
1. use utility (CopyParameter) or any other utility available,
2. extract xxx.dsx and manually add the Parameter and manually remove the default value,
3. come up with an awk script the will interrogate and loop thru each job of the xxx.dsx file. Interrogate for changes.

Ray you are DataStage guru. Is it possible for you to suggest a ready made solution which is comparatively safe and less time consuming?

My email is bkamila@optusnet.com.au. Feel free to write to me directly.

Cheers, Bana

Bana, feel free to send money for free receipt !

There is a tool called Parameter Manager for DataStage available from the folks who run this site, but I am not sure that it is still available. There is a forum here at DSXchange relating to it.

Vincent published a blog on hacking job parameters without losing your mind, which might serve as a useful source of ideas.

My business can do that kind of custom coding, but it would perforce be on some kind of commercial arrangement.

I do not think there is a simple way to do it. Just change it one by one, that will only take 2 days for one people.

Ken Bland has a utility that will easily handle #1 and is part of what he gives away for free from his website.

we had same requirment for task2 ( removing default values of parameters). We have contacted IBM for the same and they gave a routine to do that particular task. That was in my previous organisation and i don't remember the routine name now.

we had same requirment for task2 ( removing default values of parameters). We have contacted IBM for the same and they gave a routine to do that particular task. That was in my previous organisation and i don't remember the routine name now.

I wrote a Perl script that does this exact thing, but it is for Server jobs. Does anyone know if the DSX files for Parallel and Server are similar in structure? If so, then I can make the script available to you to use.

I wrote a Perl script that does this exact thing, but it is for Server jobs. Does anyone know if the DSX files for Parallel and Server are similar in structure? If so, then I can make the script available to you to use.

From an email question:

bkamila wrote:Hi Mr Chulett

Do you know the contact details or url of Ken Bland's utility? Please email me, if you know how to download the utility.

As noted earlier, from his website:

http://www.kennethbland.com/

You'll need to request a password first. Once you have access, you can download the KBA Job Control Utilities.

Hi all!

I have had several requests for my Perl script so I will start another thread in the General Section and post it. I will also include my other utilities just in case anyone can use them.

Bestest!

This thread has multiple utilities to work with .dsx and other files (in Perl):

viewtopic.php?t=113429&highlight=perl

I hope it help!

Bestest,