Close X

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


Presentation

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.

(ID)

Stream: DB2
Room: Nurburgring
Time: 15:00 - 16:00

Attachments

GSE17 ID.pdf

Speakers


  • Steve Thomas at CA Technologies
  • Steve is a Principal Engineering Services Architect at CA Technologies, reporting into R&D. This role involves helping to influence future product strategy and working with customers to ensure they get the most value out of their investment with CA. Steve has been a DB2 Specialist for over 25 years, an IBM Champion for Analytics since 2009 and is a regular speaker at User Groups and events around the globe. He has been a member of the Conference Planning Committee for IDUG EMEA for over 10 years and was honoured to serve as Chairman of the 2015 event in Dublin.


    Email: steve.thomas@ca.com

  • Steve Thomas at CA Technologies
  • Steve is a Principal Engineering Services Architect at CA Technologies, reporting into R&D. This role involves helping to influence future product strategy and working with customers to ensure they get the most value out of their investment with CA. Steve has been a DB2 Specialist for over 25 years, an IBM Champion for Analytics since 2009 and is a regular speaker at User Groups and events around the globe. He has been a member of the Conference Planning Committee for IDUG EMEA for over 10 years and was honoured to serve as Chairman of the 2015 event in Dublin.


    Email: steve.thomas@ca.com

    Feedback

    Click here to give some Feedback so we can make it even better next year!