Name: A30 | Partitioning Advances: PBR and PBR RPN
Start: 2025-03-21T16:15:00+1100
End: 2025-03-21T17:05:00+1100

Welcome to the 2025 IDUG AU Db2 Tech Conference! Enjoy two days full of technical sessions in both Sydney and Canberra as well as complimentary workshops in Sydney that are available to all attendees between the two cities.

Friday March 21, 2025 4:15pm - 5:05pm AEDT

Canberra

Partition By Range (PBR) was introduced in Db2 9 and PBR Relative Page Numbering (RPN) was
introduced in Db2 12, but they're basically the same, right? (No, or we wouldn’t have a presentation).
This intermediate level presentation discusses the similarities and explains the important differences
between the two partitioning schemes. We will look at some practical consequences of the different
features and talk about some recent changes to further improve partition handling.
1. Explain the new PAGENUM attribute in DDL and what its different values mean.
2. Explain why it is significant that DSSIZE can now be larger and differ by partition. Discuss the
limits on tablespace size that have been raised.
3. Discuss the meaning and significance of "Seven byte RID".

Speakers

Frank Rhodes

BMC

Frank RhodesSenior Product Development Architect, DB2 Administration ProductsFrank Rhodes started with BMC Software in 1995. In his current role he works to promote cross product coordination between the Database Administration products and the other BMC DB2 products. The products... Read More →

Friday March 21, 2025 4:15pm - 5:05pm AEDT
Canberra

Technical Session

IDUG AU 2025

Frank Rhodes

Attendees (1)

IDUG AU 2025

Frank Rhodes

Attendees (1)

Sign up or log in to save this to your schedule, view media, leave feedback and see who's attending!