Mass change of user id and password
Posted: Thu Dec 15, 2005 4:48 pm
Hi,
The question i am going to ask is all ready been discussed in this message board but i have doubt.
I got a requirement that i need to change the User Id and Password for DataStage jobs and sequencers.
I have lot of jobs to make the above changes.
Case -1:-
When i looked at the Job Sequencers they did not have any parameters defined for that Job Sequencers - for each Job Activity which calls a DS Job, those DS Jobs has parameters, but who ever coded did not bother to add those parameters to the Job Sequencer, they just did "Set all to Default".
My question is - if i export only the Job Sequencer to .dsx file and replace all User Id's and Passwords to new and Import back to project, Will those changes all the User Id and Password parameters of DS Jobs which are in Job Seq or not ?
Case-2:-
There are some Job Sequencer's which followed the correct process to add Job Activity DS Job Parameters to the Job Sequencer.
My Question is - If i Export the Job Sequencers and make changes to User Id and Password with new once, and Import back to project - WILL IT CHANGE THE DS JOB PARAMETERS automatically or not?
Or Can i Export only the DS Jobs and change to new parameters and Import it back, does it change Job Sequencer automatically in above both cases? Or do i need to change both DSJobs and Job Sequencers?
Any recommendation for the task i am planning to do. Or shall i Just do it manually job by job and seq by seq.
Any help is appreciated!!!
Thanks
The question i am going to ask is all ready been discussed in this message board but i have doubt.
I got a requirement that i need to change the User Id and Password for DataStage jobs and sequencers.
I have lot of jobs to make the above changes.
Case -1:-
When i looked at the Job Sequencers they did not have any parameters defined for that Job Sequencers - for each Job Activity which calls a DS Job, those DS Jobs has parameters, but who ever coded did not bother to add those parameters to the Job Sequencer, they just did "Set all to Default".
My question is - if i export only the Job Sequencer to .dsx file and replace all User Id's and Passwords to new and Import back to project, Will those changes all the User Id and Password parameters of DS Jobs which are in Job Seq or not ?
Case-2:-
There are some Job Sequencer's which followed the correct process to add Job Activity DS Job Parameters to the Job Sequencer.
My Question is - If i Export the Job Sequencers and make changes to User Id and Password with new once, and Import back to project - WILL IT CHANGE THE DS JOB PARAMETERS automatically or not?
Or Can i Export only the DS Jobs and change to new parameters and Import it back, does it change Job Sequencer automatically in above both cases? Or do i need to change both DSJobs and Job Sequencers?
Any recommendation for the task i am planning to do. Or shall i Just do it manually job by job and seq by seq.
Any help is appreciated!!!
Thanks