DB2 Performance Features in DB2 V9 for z/OS – Part 7

As I talked about in the previous weeks, DB2 Version 9 for z/OS has over 50+ great new DB2 performance features. Many of these features can really benefit your standard DBA operations; improve application performance and overall availability of your systems and data.

Another one of the enhancements with DB2 Version 9 for z/OS that helps with the every possible table in your environment are the new DB2 Partition-by-Growth and Universal Tablespaces.  These new tablespaces offer many new options that make your life easier through better growth and performance.

This new universal tablespace type combines the advantages and features of the segmented tablespaces with the various capabilities of partitioned tablespaces. Each universal tablespace partition has segmented space map pages.  By having segmented space maps within each partition DB2 knows the pages that are immediately available for inserts improving application and DB2 performance.

The other type of new DB2 tablespace is the new partition-by-growth (PBG) tablespace.  PBG leverages the new universal tablespace with segmented partitions, but allows the user to define the tablespace with no partitioning key. The tablespace starts out as a single tablespace partition and grows by expanding to multiple partitions.  This tablespace uses the MAXPARTITIONS keyword instead of the NUMPARTS/KEY RANGE definitions to determine the number of partitions to dynamically add.  By providing the ability to grow the tablespace naturally this type of tablespace can be designed to naturally partition your data over time. This can help manage your DB2 performance by naturally segmenting your data.  The DB2 performance and features of this tablespace are good that in DB2 Version 9 it is now the default tablespace.

These additional features provide a nice DB2 performance improvement for the standard tablespace.  While you are looking at all the simple tablespaces that need to be converted in your migration to DB2 Version 9 check out these new universal and partition by growth tablespaces that can help your DB2 performance.

Leave a Reply

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>