IBM Mainframe Forum Index
 
Register
 
IBM Mainframe Forum Index Mainframe: Search Log in to check your private messages Log in
 

CA7 - Case where Jobs must NOT run in parallel


 
IBM Mainframe Forums -> CA Products
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
thisak

New User


Joined: 09 Jun 2006
Posts: 14

PostPosted: Fri Oct 25, 2013 2:57 pm
Reply with quote

Hi,

In my project, there is a scenario where we will receive 8 load files from different external systems between certain time range. We have around 8 DB2 Loader jobs to load the content into a single table (no partition made) in DB2 database. As DB2 Load utility has a constraint that it cannot run concurrently, we see to that no 2 jobs are running at a time.

Moreover, we DO NOT KNOW which of these files will be received first; meaning the 8 files can reach our system in any order on a day. So, as and when the files are received respective jobs should start running and job dependency should be made to avoid parallel running. Is there any built-in feature in CA7 to handle this?
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 8568
Location: Dubuque, Iowa, USA

PostPosted: Fri Oct 25, 2013 3:09 pm
Reply with quote

Talk to your site support group. You need a job class that has only one initiator running, which would limit you to one job at a time. This does not require anything in CA-7 to implement, either.
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8795
Location: Welsh Wales

PostPosted: Fri Oct 25, 2013 3:46 pm
Reply with quote

Or you could read the CA7 manuals for negative dependency
Back to top
View user's profile Send private message
don.leahy

Active Member


Joined: 06 Jul 2010
Posts: 692
Location: Whitby, ON, Canada

PostPosted: Fri Oct 25, 2013 6:51 pm
Reply with quote

MUTEX ? I am not a CA7 guy, but I've heard our production support folks use that term.
Back to top
View user's profile Send private message
Vishnupriyan Pandiyan

New User


Joined: 26 Apr 2011
Posts: 16
Location: India

PostPosted: Fri Oct 25, 2013 9:08 pm
Reply with quote

Yes Thisak, you can use Negative dependency(prevents jobs from executing at the same time).

You can set that up using a slash (/) beside the dependent job.
For example Jobs B and C have the requirement as job A,once job A is done you can avoid B and C running parallel by setting /B as a requirement for Job C.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic All times are GMT + 6 Hours
Forum Index -> CA Products
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Forum Replies
No new posts List of Active Jobs in CTRL-M JCL & VSAM 1
No new posts usage of CASE in WHERE clause DB2 10
No new posts COBOL -DB2 SQL code to have GROUP BY ... DB2 21
No new posts how to synchronize jobs across LPARs ... JCL & VSAM 7
No new posts Introducing new step in set of jobs CLIST & REXX 6

Back to Top