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