Change in paramter set not refelecting in the job.

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
rajeshknl
Participant
Posts: 22
Joined: Thu Jul 17, 2008 8:09 pm

Change in paramter set not refelecting in the job.

Post by rajeshknl »

Hi,
Changes made to the parameter set are not reflecting in the parallel jobs.

The parameter set has username,password& schema.

Below is the sequence of events where i am facing issue.

1) Compile & run the job successfully.
2) Change the password/schema name in the parameter set.
3) Run the job without compilation. The job fails in this step.

But if i recompile the job and run it then it runs successfully picking the changed password or schema name.

I am expecting the job to pick the changes to the parameter set during runtime. Is this possible without recompiling? If so is there any environment setting to acheive this?

Thanks in advance to everyone.
shivajid2k
Participant
Posts: 19
Joined: Mon Feb 14, 2005 11:34 pm

Re: Change in paramter set not refelecting in the job.

Post by shivajid2k »

Try by removing the parameter set from the job and add it again..compile and run..
rajeshknl
Participant
Posts: 22
Joined: Thu Jul 17, 2008 8:09 pm

Re: Change in paramter set not refelecting in the job.

Post by rajeshknl »

[quote="shivajid2k"]Try by removing the parameter set from the job and add it again..compile and run..[/quote]

The job runs fine if i compile and run it. The issue is with recompilation. I have a ton of jobs which use the parameter set. I am looking to avoide the recompilation whenever there is a change to the parameter set.
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

You can't avoid that, the default values of a set are compiled into the job. Or go the route of using "$PROJDEF" for all parameter set default values, in which case you wouldn't need to recompile.
Post Reply