Automizing parameter values with a concurrent architecture

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
ds_is_fun
Premium Member
Premium Member
Posts: 194
Joined: Fri Jan 07, 2005 12:00 pm

Automizing parameter values with a concurrent architecture

Post by ds_is_fun »

Re-posting as there was no answer on this since yesterday. Any solution response would be appreciated.
-------
We currently have an architecture where we will be running batch loads based on a RUNDATE on a daily basis.
There are three stages that the data batch needs to pass through.
Stage 1. Source - Standardization
Stage 2. Standardization - Cleansing
Stage 3. Cleansing - Target
In the first stage we extract based on a parameter RUNDATE.

Going forward from Stage 1-2, Stage 2-3 Im currently placing the RUNDATE, Batch_LoadID in a hash file for all the transformation required.
If another job is started at the sametime then it is possible that it would incorrectly refer to that hash file.
What is a good method to prevent this non-concurrent method in a DS architecture design? where no third party tool is used for scheduling and only Job sequence, DS designer is relied upon.
Thanks
DeepakCorning
Premium Member
Premium Member
Posts: 503
Joined: Wed Jun 29, 2005 8:14 am

Post by DeepakCorning »

May be u can try to use a SEQUENTIAL file which gets locked automatically if one job is using it. Or research on lockign the file till the frst job is complete.
Thanks
Deepak Patil

Convince Them Confuse Them .. What's the difference?
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

You should create your job sequence such that operations can NOT occur in the wrong order.

You could also use any of the public semaphores (task synchronization locks) within your job design. These are described in the DataStage BASIC manual.

Neither your question nor this answer appear to have any relationship to the subject of this thread. Parameter values do not appear to have been mentioned.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply