Add new parameter and remove default value from Jobs
Moderators: chulett, rschirm, roy
Add new parameter and remove default value from Jobs
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
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 KAMILA
BI, Data Warehouse and Database Consultant
BI, Data Warehouse and Database Consultant
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Re: Add new parameter and remove default value from Jobs
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.
-
- Participant
- Posts: 147
- Joined: Sat Apr 30, 2005 1:23 am
- Location: Bangalore,India
-
- Participant
- Posts: 147
- Joined: Sat Apr 30, 2005 1:23 am
- Location: Bangalore,India
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.
Bestest!
John Miceli
System Specialist, MCP, MCDBA
Berkley Technology Services
"Good Morning. This is God. I will be handling all your problems today. I will not need your help. So have a great day!"
John Miceli
System Specialist, MCP, MCDBA
Berkley Technology Services
"Good Morning. This is God. I will be handling all your problems today. I will not need your help. So have a great day!"
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.
Bestest!
John Miceli
System Specialist, MCP, MCDBA
Berkley Technology Services
"Good Morning. This is God. I will be handling all your problems today. I will not need your help. So have a great day!"
John Miceli
System Specialist, MCP, MCDBA
Berkley Technology Services
"Good Morning. This is God. I will be handling all your problems today. I will not need your help. So have a great day!"
From an email question:
http://www.kennethbland.com/
You'll need to request a password first. Once you have access, you can download the KBA Job Control Utilities.
As noted earlier, from his website: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.
http://www.kennethbland.com/
You'll need to request a password first. Once you have access, you can download the KBA Job Control Utilities.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
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!
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!
Bestest!
John Miceli
System Specialist, MCP, MCDBA
Berkley Technology Services
"Good Morning. This is God. I will be handling all your problems today. I will not need your help. So have a great day!"
John Miceli
System Specialist, MCP, MCDBA
Berkley Technology Services
"Good Morning. This is God. I will be handling all your problems today. I will not need your help. So have a great day!"
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,
viewtopic.php?t=113429&highlight=perl
I hope it help!
Bestest,
Bestest!
John Miceli
System Specialist, MCP, MCDBA
Berkley Technology Services
"Good Morning. This is God. I will be handling all your problems today. I will not need your help. So have a great day!"
John Miceli
System Specialist, MCP, MCDBA
Berkley Technology Services
"Good Morning. This is God. I will be handling all your problems today. I will not need your help. So have a great day!"