Portal | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Forum Index
 
Register
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
CA7 - Case where Jobs must NOT run in parallel

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> CA Products
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    Post subject: CA7 - Case where Jobs must NOT run in parallel
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: 8567
Location: Dubuque, Iowa, USA

PostPosted: Fri Oct 25, 2013 3:09 pm    Post subject:
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: 8796
Location: Welsh Wales

PostPosted: Fri Oct 25, 2013 3:46 pm    Post subject:
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    Post subject:
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    Post subject:
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    IBMMAINFRAMES.com Support Forums -> CA Products All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts List of Active Jobs in CTRL-M Vineet JCL & VSAM 1 Mon Sep 21, 2020 7:58 pm
No new posts usage of CASE in WHERE clause abdulrafi DB2 10 Wed Mar 18, 2020 4:25 pm
No new posts COBOL -DB2 SQL code to have GROUP BY ... vinu78 DB2 21 Wed Oct 23, 2019 7:00 pm
No new posts how to synchronize jobs across LPARs ... jzhardy JCL & VSAM 7 Sun May 12, 2019 6:49 am
No new posts Introducing new step in set of jobs ravikumar15 CLIST & REXX 6 Wed Oct 17, 2018 2:22 am

Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us