View previous topic :: View next topic |
Author |
Message |
pundareekam Beginner
Joined: 13 Jun 2007 Posts: 9 Topics: 3
|
Posted: Tue Sep 18, 2007 12:53 am Post subject: Row level locking on DB2 verion 3 |
|
|
Is the DB2 version 2 or 3 will support row level locking? if no, could you please let me know how we can achieve through cobol program?
Thanks for you help in advance. |
|
Back to top |
|
|
CZerfas Intermediate
Joined: 31 Jan 2003 Posts: 211 Topics: 8
|
Posted: Tue Sep 18, 2007 4:25 am Post subject: |
|
|
In DB2 versions not providing row level locking, the only thing you can do is:
Make the row so large, that only one row fits into one data page.
Often you need row level locking in tables with administrative data not containing millions of rows. In that scenario, the hint with the length of the row is usable. Applying it on large tables is surely not recommendable.
regards
Christian |
|
Back to top |
|
|
pundareekam Beginner
Joined: 13 Jun 2007 Posts: 9 Topics: 3
|
Posted: Tue Sep 18, 2007 6:27 am Post subject: |
|
|
How about cursor with update option? does it work on older DB2 versions? |
|
Back to top |
|
|
vkphani Intermediate
Joined: 05 Sep 2003 Posts: 483 Topics: 48
|
Posted: Tue Sep 18, 2007 6:28 am Post subject: |
|
|
pundareekam wrote: | How about cursor with update option? does it work on older DB2 versions? |
which version do you have in your shop? |
|
Back to top |
|
|
pundareekam Beginner
Joined: 13 Jun 2007 Posts: 9 Topics: 3
|
Posted: Tue Sep 18, 2007 6:34 am Post subject: |
|
|
DB2 version 3.. |
|
Back to top |
|
|
vkphani Intermediate
Joined: 05 Sep 2003 Posts: 483 Topics: 48
|
Posted: Tue Sep 18, 2007 6:37 am Post subject: |
|
|
pundareekam wrote: | DB2 version 3.. |
I think it supports. Why don't you just try and check? |
|
Back to top |
|
|
pundareekam Beginner
Joined: 13 Jun 2007 Posts: 9 Topics: 3
|
Posted: Tue Sep 18, 2007 6:39 am Post subject: |
|
|
Which one will support? is it CURSOR WITH UPDATE or Row Level Locking it self? |
|
Back to top |
|
|
vivek1983 Intermediate
Joined: 20 Apr 2006 Posts: 222 Topics: 24
|
Posted: Tue Sep 18, 2007 6:42 am Post subject: |
|
|
pundareekam,
I think "CURSOR WITH UPDATE" should go fine.
Give it a try and post the results.
Vivek G _________________ Vivek G
--------------------------------------
A dream is just a dream. A goal is a dream with a plan and a deadline. (Harvey Mackay) |
|
Back to top |
|
|
pundareekam Beginner
Joined: 13 Jun 2007 Posts: 9 Topics: 3
|
Posted: Tue Sep 18, 2007 6:43 am Post subject: |
|
|
This is some thing client is asking and we are proposing with COBOL solution for this. Any how thanks very much. |
|
Back to top |
|
|
vkphani Intermediate
Joined: 05 Sep 2003 Posts: 483 Topics: 48
|
Posted: Tue Sep 18, 2007 6:43 am Post subject: |
|
|
pundareekam wrote: | Which one will support? is it CURSOR WITH UPDATE or Row Level Locking it self? |
CURSOR WITH UPDATE |
|
Back to top |
|
|
kolusu Site Admin
Joined: 26 Nov 2002 Posts: 12376 Topics: 75 Location: San Jose
|
Posted: Tue Sep 18, 2007 7:08 am Post subject: |
|
|
pundareekam,
DB2 version 2 or 3 ? I don't think they are even supported any more by IBM.
Kolusu _________________ Kolusu
www.linkedin.com/in/kolusu |
|
Back to top |
|
|
|
|