Articles & Content
Topic: 2010 EMEA
Subtopic: DB2 for z/OS
DATE: 2010-11-10 (15:45 - 16:45)
SPEAKERS: Billy Sundarrajan (Fifth Third Bank)
DB2 v8 for z/OS introduced several key features which enhanced DB2's ability to store large volumes of data: Increased Number of partitions, Table controlled partitioning, DPSIs, and ALTER/ROTATE parts. These new techniques allow the ability to roll off data and add/rotate partitions in a table. Managing multiple multi-terabyte tables in a 24x7 can be a daunting task. At Fifth Third, we have developed innovative approaches to handle the challenges with design, space management and partition management of large multi-terabyte tables. Space management and partition rotation are performed in an automated fashion with zero to minimal DBA intervention. This presentation provides an overview of Table controlled partitioning, understanding logical versus physical partitions, best practices for designing large tables, and detailed information on automating partition maintenance.
EXP. LEVEL: Intermediate,Advanced
-Index controlled tables versus Range/Table controlled partitioned tables; key columns in the catalog tables, physical versus logical partitions
Techniques for Loading/Inserting data and purging data from large tables.
Best practices: pre-loading compression dictionary, PCTFREE/FREEPAGE settings, PRIQTY/SECQTY settings, TRACKMOD settings, statistics maintenance, PIECESIZE settings, Data sharing implications
Identifying partitions which need to be reorged, Rotating parts for new data-Automate the generation of rotate and reorg scripts
DB2 9 enhancements
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.