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.

Languages :  Polski Session Category :  Wrocław 2017 

By continuing to use the site, you agree to the use of cookies. więcej informacji

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.