PBR RPN – Removing Partitioning restrictions in Db2 12 for z/OS

The ability to partition tables has been available since the very earliest releases of Db2 for z/OS, but over the past few releases the number of options has exploded. We’ve seen increases in the number of partitions, Table based rather than Index based partitioning, Data Partitioned Secondary Indexes, UTS objects which are partitioned by Growth or Range, and now in Db2 12 for z/OS Relative Page Numbering. During this session Steve will describe the limitations which still existed before Db2 12 and which led to the design of this new type of partitioned object, and the benefits which can be achieved from using them. We’ll discuss how to create these objects and to convert existing ones, along with other operational considerations. If you ever wanted to create vast DB2 objects, add new partitions in the middle of an existing object or wanted to use different DSSIZEs for each partition then come to this session and find out how to achieve all of these goals and more.