The final instalment - DB2 for z/OS Locking for Application Developers Part 10

This is the last article in the series by Gareth Copplestone-Jones on locking for developers, and is a wrap up of miscellaneous points arising from previous articles.

 

Row level locking

The first item under discussion is row-level locking. I mentioned previously that the design default lock size should be page-level, with row-level locking only being used where justified. This is to reduce the CPU and elapsed time overhead typically incurred by row-level locking, and especially to avoid the data sharing overhead involved. The DB2 for z/OS documentation has further information about locking in a data sharing environment, but for the purposes of this article it’s important to stress that row level locking in a data sharing environment can and typically does introduce significant overheads.

Continue reading the final instalment in Gareth Copplestone-Jones series of blogs on DB2 for z/OS Locking for Application Developers. 

 

Views: 56

Add a Comment

You need to be a member of The World of DB2 to add comments!

Join The World of DB2

Latest Activity

Pedro Diaz liked Surekha Parekh's event Interactive Db2 12 Client Panel with John Campbell IBM DE
6 hours ago
An event by Surekha Parekh was featured
Thumbnail

Interactive Db2 12 Client Panel with John Campbell IBM DE at https://ibm.biz/Db212ClientPanel

June 29, 2021 from 11am to 12:30pm
7 hours ago
Carol Davis-Mann posted a blog post
Friday
Carrie Tutino posted events
Thursday
Annette Zawacki added a discussion to the group Data, Analytics and AI on IBM Z
Jun 2
Michael Hardie posted an event

Scottish Db2 User Group - June 22nd 2021 at Virtual via GoToMeeting

June 22, 2021 from 9am to 4:30pm
Jun 1
An event by Surekha Parekh was featured
Thumbnail

What’s new in Db2 AI for z/OS and Watson Machine Learning for z/OS at Virtual LIVE

June 1, 2021 from 11am to 12:15pm
May 27
Annette Zawacki posted an event
May 27
Roger Smith liked Jane Man's blog post Convert JSON data to Relational Format
May 21
Peter E Saxe posted a discussion
May 20
Jim Reed liked Annette Zawacki's discussion Is your Db2 for z/OS data part of your AI strategy? Learn how you can build AI models anywhere and deploy on IBM Z
May 12
Jim Reed liked Diego Cardalliaguet's event EMEA IBM Db2 Analytics Accelerator Users Group meeting 2021
May 12
Jim Reed liked Diego Cardalliaguet's event EMEA IBM Db2 Analytics Accelerator Users Group meeting 2021
May 12
Jim Reed liked Surekha Parekh's event Achieving Optimal Availability, Usability and Performance with Universal Table Space - Part 2
May 12
Profile Icon via Twitter
Join the live launch webcast, "What’s New in Db2 AI for z/OS and Watson Machine Learning for z/OS" June 1 at 11 AM… https://t.co/yvz9t7dwcC
TwitterMay 11 · Reply · Retweet
A blog post by Surekha Parekh was featured
May 11

Bringing Db2 enthusiasts together virtually. Expert or novice, distributed or mainframe, this is the place for everything DB2.

Forum

DB2 Future

Started by Peter E Saxe in Application Development and DB2 May 20. 0 Replies

Has anyone ever submitted ideas of new functions in DBMS software like DB2?   have an idea for a future enhancement to DB2 that I would like to see.  Is this discussion area a good place to discuss this ?  Thanks.Continue

Tags: Enhancements, Future, DB2

who opened the scoring from the penalty spot

Started by long lin in What's hot ? Apr 22. 0 Replies

fotbollströja barn eget tryck Lionel Messi opened the scoring from the penalty spot, but that was as good as it got for Ronald Koeman's side as Mbappe took over to evoke memories of recent defeats to…Continue

© 2021   Created by Surekha Parekh.   Powered by

Badges  |  Report an Issue  |  Terms of Service