20067

db2 explain result about lock size

Question:

What is Lock List Size, Maximum Lock List Size and Locks Available in the result of explain using IBM data studio.

<img alt="enter image description here" class="b-lazy" data-src="https://i.stack.imgur.com/65k2h.png" data-original="https://i.stack.imgur.com/65k2h.png" src="https://etrip.eimg.top/images/2019/05/07/timg.gif" />

I read some sources from IBM but can not understand the complete concept and different between those.

Please tell any resources about these attributes (also others in the attribute pane)

Thanks

Answer1:

Thanks to Lennart,

Lock list size is Lock list memory in use (Bytes) (see snapshot).

Maximum lock list size is MAXLOCKS, Percent. of lock lists per application (see db cfg) and Locks available is LOCKLIST, Max storage for lock list (4KB) blocks - Lock list size.

Recommend

  • Raise Session_OnStart event from custom ASP.NET SessionStateProvider class
  • How to only store 3 values for a key in a dictionary? Python
  • Why isn't Kubernetes service DNS working?
  • Locating unmatched delimiters in Clojurescript
  • Android: how to determine cold start
  • How do I create an image and save it for later to draw as texture in XNA?
  • CSS Grid, position absolute an element in a css grid item: IMPOSSIBLE
  • What is the equivalent of Android permissions in iOS development? [duplicate]
  • XNU incudes in Kext
  • Upgrade project from WorkLight 6.1 to MobileFirst 7.1
  • TFS - how do I sum child task hours to parent
  • jersey/tomcat Description The origin server did not find a current representation for the target res
  • Deploying a CodeRush plugin from the Community Site
  • how to get data attributes of dynamically generated element
  • “mvn clean generate-source” could not resolve dependencies
  • How to pass solution folder as parameter in command line arguments (for debug)?
  • Magento get URL before current
  • Prevent Tomcat from caching request during starup
  • Pycharm: Marking a folder as 'sources root' is not recursive for subfolders
  • Bash if statement with multiple conditions
  • How do I signal completion of my dataflow?
  • ListItem.Attributes.Add not working
  • JBoss External Properties Files in Classpath
  • Automatically associate new Sonar project with custom quality profile and quality gate
  • How to use JavaScript to determine whether a file exists in a directory?
  • why xml file does not aligned properly after append the string in beginning and end of the file usin
  • Installed module is empty
  • How to change the font size of a single index for UISegmentedControl?
  • Installing Apache MyFaces 2 on WildFly 8.2.0
  • How to define and use opencv mat of user type
  • Using jQuery closest() method with class selector
  • Projection media query: browser support and workarounds?
  • Array.prototype.includes - not transformed with babel
  • HTML download movie download link
  • InvalidAuthenticityToken between subdomains when logging in with Rails app
  • SQL merge duplicate rows and join values that are different
  • NSLayoutConstraint that would pin a view to the bottom edge of a superview
  • Why can't I rebase on to an ancestor of source changesets if on a different branch?
  • LevelDB C iterator
  • Can't mass-assign protected attributes when import data from csv file