Articles & Content

Archives

DB2 Partitions - How Do We Tell Them aPART? (A13)

Topic: 2008 NA

Subtopic: DB2 for z/OS



DATE: 2008-05-22 (08:00 AM - 09:00 AM)
SPEAKERS: Rick Weaver (BMC Software)

Things used to be so Simple. The DB2 DBA would CREATE a TABLESPACE, and away we went. With the advent of DB2 9, we now have a wide variety of partitioning and indexing schemes to choose from, including DPSI, NPSI, PBG, and many more. How does a DBA determine the best partitioning/indexing scheme for his application? This presentation will review the various options and discuss the types of application or utility processing that would benefit from each.

EXP. LEVEL: Intermediate,Advanced

OBJECTIVES:

Review DB2 Partitioning and Indexing schemes

Review applications and utility benefits for each scheme

What's new with DB2 9 - UTS, PBR, PBG

Educate DBAs to prevent bad choices

History of partitioning



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.