tag:blogger.com,1999:blog-4516533711330247058.post5733919644066640137..comments2024-03-28T07:32:09.246-07:00Comments on Robert's Db2 blog: DB2 11 for z/OS: Setting Aside Space for UpdatesRoberthttp://www.blogger.com/profile/02058625981006623480noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-4516533711330247058.post-29551010948984913382017-10-11T12:58:33.340-07:002017-10-11T12:58:33.340-07:00Yep, that makes sense. Thanks.Yep, that makes sense. Thanks.Barryhttps://www.blogger.com/profile/16240117815175921213noreply@blogger.comtag:blogger.com,1999:blog-4516533711330247058.post-69662953051859311112017-10-10T11:58:01.880-07:002017-10-10T11:58:01.880-07:00Hey, Barry.
I'd say this was a case of my not...Hey, Barry.<br /><br />I'd say this was a case of my not being as precise with my wording as I should have been. What I meant to convey was that, prior to PCTFREE FOR UPDATE, we didn't have a way of setting aside space in a Db2 for z/OS table space's pages that would be EXCLUSIVELY available for accommodating length-increasing updates. My bad. Thanks for seeking clarification and giving me an opportunity to crisp this up.<br /><br />RobertRoberthttps://www.blogger.com/profile/02058625981006623480noreply@blogger.comtag:blogger.com,1999:blog-4516533711330247058.post-1033413899617832052017-10-09T15:43:22.057-07:002017-10-09T15:43:22.057-07:00Good article Robert. I know it's been a while...Good article Robert. I know it's been a while since you posted it, but i'm a little confused with where you say " it (PCTFREE) didn't apply to UPDATE operations that caused a row's length to increase".<br /><br />Looking at this link for version 10:<br />https://www.ibm.com/support/knowledgecenter/en/SSEPEK_10.0.0/perf/src/tpc/db2z_reservefreespacetable.html<br /><br />it seems to imply in several places that PCTFREE does reduce indirect references caused by size increase (see second bullet under About This Task, and second bullet under Procedure). Is the doc incorrect, or am i misunderstanding/misreading?<br /><br />Thanks for any clarificationBarryhttps://www.blogger.com/profile/16240117815175921213noreply@blogger.comtag:blogger.com,1999:blog-4516533711330247058.post-17705932540964728642017-09-07T06:47:45.350-07:002017-09-07T06:47:45.350-07:00Thanks You!!! it was very helpful!!!Thanks You!!! it was very helpful!!!Anonymousnoreply@blogger.com