tag:blogger.com,1999:blog-4516533711330247058.post6612181770677565227..comments2024-03-28T07:32:09.246-07:00Comments on Robert's Db2 blog: Db2 for z/OS: Using the Profile Tables to Direct DDF Applications to Particular Package CollectionsRoberthttp://www.blogger.com/profile/02058625981006623480noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-4516533711330247058.post-82789654037239872812021-08-20T04:49:22.980-07:002021-08-20T04:49:22.980-07:00Thanks RobertThanks RobertAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-4516533711330247058.post-47894874193832143722021-08-18T19:24:27.757-07:002021-08-18T19:24:27.757-07:00With the cursor stability isolation level in effec...With the cursor stability isolation level in effect, an associated S-lock will be released when Db2 for z/OS moves off of whatever has been S-locked. If page-level locking is in effect then the S-lock on a page acquired as part of cursor processing will be released when Db2 moves off of the page in question and on to another page. If row-level locking is in effect then an S-lock on a row will be released when Db2 moves from that row to another row.<br /><br />Robert Roberthttps://www.blogger.com/profile/02058625981006623480noreply@blogger.comtag:blogger.com,1999:blog-4516533711330247058.post-71168882586769392562021-08-17T07:56:26.511-07:002021-08-17T07:56:26.511-07:00Hi Rob,with cursor stability -cs and locksize -pag...Hi Rob,with cursor stability -cs and locksize -page .how will the isolation level behave/act.Since lock is held for whole page ,and cursor stability act for one row at a time,will the cs be ignored? .how this works.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-4516533711330247058.post-4251718849344967752019-05-10T10:39:57.077-07:002019-05-10T10:39:57.077-07:00Very informative for alternate implementation of H...Very informative for alternate implementation of High Performance DBATs as well as setting default application behavior to alternate values thru the use of Profile Tables. Looks like Profiles tables will be the method to managing and controlling behavior of DDF threads.Anonymoushttps://www.blogger.com/profile/11690409348979892845noreply@blogger.com