Articles & Content


Partition by Growth: What is it Good For and How Do I Maintain it? (E09)

Topic: 2009 EU

Subtopic: DB2 for z/OS

DATE: 2009-10-7 (08:30 - 09:30)
SPEAKERS: Rick Weaver (BMC Software)

DB2 V9 introduced Partition by Growth (PBG) objects. This presentation covers what they are and how they differ from previous object types. It covers PBG structure and why you should use it and the appropriate types of data for it. Also covered is how to allocate PBG for the most effective use of DASD. Finally, the presentation covers maintenence and migration of data to using PGB.

EXP. LEVEL: Beginner,Intermediate,Advanced


Attendees will know what a Partition by Growth object is, how to create one and what options they should consider when allocating it.

They will know why they should use a PBG and what types of data make the most sense to use it for.

They will understand why different combinations of parameters can effect the amount of data in a PBG and how to maximize the data. The presentation includes a chart for selecting some options.

Users will understand the maintenance considerations of PBG objects. The presentation includes two SPUFI queries to help in maintenance decisions.

Utilities that can be used to facilitate the migration of data from other object types to PBG objects.

This file is being provided by IDUG. We would encourage you to join IDUG to get full access to all of our files and resources. Joining IDUG is FREE and signing up is simple. Click here to join! or login!

Download File
Click to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.