Articles & Content
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
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!Click to Download
NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.