Articles & Content

Archives

F09 - Partition by Growth - It's a Love/Hate Thing

Topic: Cross Platform DB2 for z/OS & LUW

Subtopic: 2016



Based on extensive user experience, this presentation provides an insight into Partition by Growth (PBG) tablespaces including an overview of how they work; the mechanics of creating or converting to PBG; the decision making process in order to help correctly select a Partition by Growth vs Partition By Range tablespace; the benefits of using PBGs; potential pitfalls and lessons learnt; use, restrictions and performance considerations of utilities against PBGs.



Click Here to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.