View previous topic :: View next topic |
Author |
Message |
ramu_mohan21 Beginner
Joined: 29 Jun 2004 Posts: 106 Topics: 41 Location: Bangalore, INDIA
|
Posted: Mon Dec 27, 2004 6:04 am Post subject: Need Clarification regarding BMP, DL/I and MPP |
|
|
Hi Board,
I want to get clarified about some information which I knew about BMP, DL/I and MPP.
If we use DL/I mode the database can't be accessed by ONLINE transacation when Batch JOB is updating the same database.
If we use BMP mode the ONLINE transaction can also access the database when Batch JOB is updating the same database.
In our system there are two BMP Jobs are updating the same database. But when both the jobs are updating at the same time they were abended with U0850(Contention).
What I understood here is BMP mode will be helpful when Batch and Online accessing the dabase at the same time(But even DL/I mode will not support this facility).
But this BMP mode can't be helpful when Both Batch Jobs are updating at the same time. I think my assumptions are right. Anyone can support.
PS: Information regarding BMP, DL/I and MPP is available in this forum in different questions. But I need clairification in perspecitve of Online and Batch. _________________ Best Regards,
----------------
Rammohan Pabba
Software Engineer |
|
Back to top |
|
 |
deepeshk79 Beginner
Joined: 20 Jun 2003 Posts: 112 Topics: 48 Location: Bangalore
|
Posted: Wed Dec 29, 2004 2:47 am Post subject: |
|
|
Hi Rammohan,
BMP mode is useful when both Batch Jobs are updating the same database. It infact depends on how we have designed our system. The Contention abends can be avoided by proper design or change in scheduling pattern. Though BMP modes are designed to access databases both online and batch, it is still effective for two batch jobs accessing at the same time.
Regards,
Deepesh |
|
Back to top |
|
 |
ramu_mohan21 Beginner
Joined: 29 Jun 2004 Posts: 106 Topics: 41 Location: Bangalore, INDIA
|
Posted: Wed Dec 29, 2004 5:16 am Post subject: |
|
|
Hi Deepesh,
Thank you for your reply.
Quote: |
The Contention abends can be avoided by proper design or change in scheduling pattern.
|
If we change the Scheduling pattern what is the use of BMP? I can execute Both BMP jobs one after the other.
Quote: |
it is still effective for two batch jobs accessing at the same time.
|
Can you tell me how can we make our programs to work without getting Contention. What kind of things do I need to take into consideration in design pattern. _________________ Best Regards,
----------------
Rammohan Pabba
Software Engineer |
|
Back to top |
|
 |
Bithead Advanced

Joined: 03 Jan 2003 Posts: 550 Topics: 23 Location: Michigan, USA
|
Posted: Fri Dec 31, 2004 11:47 am Post subject: |
|
|
Look into "Block Level Sharing". It may help run BMP and DL/I together. |
|
Back to top |
|
 |
ramu_mohan21 Beginner
Joined: 29 Jun 2004 Posts: 106 Topics: 41 Location: Bangalore, INDIA
|
Posted: Sun Jan 02, 2005 4:12 am Post subject: |
|
|
Hi Bithead,
Thank you very much for reply. I will try to get more information about "Block Level Sharing".
Best Regards, _________________ Best Regards,
----------------
Rammohan Pabba
Software Engineer |
|
Back to top |
|
 |
icon Beginner
Joined: 10 Jun 2003 Posts: 5 Topics: 2
|
Posted: Mon Mar 26, 2007 8:58 pm Post subject: |
|
|
My question is needing further clarification regarding BMP and DL/I. What is the major pros and cons of designing the programs in each mode? Any advantages in terms of checkpoint restarting, recovery, resource/CPU usage?
In the previous company I worked for all the programs are BMP and there is almost zero db downtime. In my current post, there is a mix and they are slowly converting the DL/Is to BMPs. I do not believe data contention is an issue in this shop. Is converting to BMPs the right way to go? |
|
Back to top |
|
 |
|
|