Articles & Content

Archives

DB2 Partitioning: How Do We Tell Them aPART? (A02)

Topic: 2009 EU

Subtopic: DB2 for z/OS



DATE: 2009-10-5 (13:30 - 14:30)
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

OBJECTIVES:

Brief history of DB2 storage techniques beginning with Simple Tablespace through DB2 9 Universal Tablespace

Details of each DB2 storage technique for tablespaces through DB2 9

Details of each DB2 storage techinique for indexes through DB2 9

Impact of DB2 Partitioning schemes on queries and utilities

Discussion of when to use various types of storage techniques depending on processing requirements



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.