Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

How to run the same job in parallel

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
Jain Abhinav

New User


Joined: 20 Dec 2007
Posts: 8
Location: India

PostPosted: Wed Jul 02, 2008 11:53 am    Post subject: How to run the same job in parallel
Reply with quote

Hi,

Please help me with the following situation.

I have a table which has 28 million records. There is a job which updates this table on a monthly basis. The problem is that the job runs for more than 12hrs. I need to optimise the run time for the jobs.

The scope of optimising the Db2 queries is minimal as confirmed by DBAs. I am thinking that if I can run the same job in parallel (may be 4 instances) and each instance updates around 7 million records. Thus instead of table lock, if I can have page locks on DB2 tables.

Has anybody done this in past.

TIA.

Abhinav Jain.
Back to top
View user's profile Send private message

ascelepius

New User


Joined: 16 Jun 2008
Posts: 35
Location: bangalore

PostPosted: Wed Jul 02, 2008 12:35 pm    Post subject: Reply to: How to run the same job in parallel
Reply with quote

Actually what matters here is if you have this data(28 mill records) in a partitioned table. Thus you can ensure that your batch programs run for pre-defined partitions on a monthly basis.

regards,
asci(i)
Back to top
View user's profile Send private message
ksk

Active User


Joined: 08 Jun 2006
Posts: 356
Location: New York

PostPosted: Wed Jul 02, 2008 4:47 pm    Post subject:
Reply with quote

You can partition the table and prepare 4 JObs. These 4 jobs have to be scheduled so that all will run same time and takes less time.
Back to top
View user's profile Send private message
Rajkumar_n

New User


Joined: 07 Dec 2006
Posts: 51
Location: Bloomington

PostPosted: Wed Jul 02, 2008 8:36 pm    Post subject: How to run the same job in parallel
Reply with quote

It may be silly but I would like to know how we can run the same jobs at a time. At least the job names should be different even having the same functionality.
Back to top
View user's profile Send private message
Srihari Gonugunta

Active User


Joined: 14 Sep 2007
Posts: 295
Location: Singapore

PostPosted: Thu Jul 03, 2008 12:15 pm    Post subject:
Reply with quote

Also the jobs should be different as you are going to use four different input files.
Back to top
View user's profile Send private message
ksk

Active User


Joined: 08 Jun 2006
Posts: 356
Location: New York

PostPosted: Thu Jul 03, 2008 2:13 pm    Post subject:
Reply with quote

I have also faced the same situation and done as below.

We had more than 20 million records and divided it into 21 parts. Written a Procedure and written 21 JCLs for 21 different input files. This same procedure was called from each JCL by overriding input files accordingly.
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 -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Query on Parallel processing of Store... rexx77 DB2 1 Thu Aug 14, 2014 12:41 pm
No new posts CA7 - Case where Jobs must NOT run in... thisak CA Products 4 Fri Oct 25, 2013 2:57 pm
No new posts How to read a file in parallel using ... haohao COBOL Programming 9 Thu Mar 28, 2013 9:42 am
No new posts Parallel sysplex connectivity anka All Other Mainframe Topics 10 Wed Aug 10, 2011 1:08 pm
No new posts How to run same JOBNAME parallel zanyzap4u JCL & VSAM 16 Wed Dec 01, 2010 1:20 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us