IDUG DB2 Tech Conference EMEA 2011
Clarion Congress Hotel, Prague, Czech Republic
14 - 18 November, 2011

View Printable Version

Deep dive in DB2 LUW's offline table reorg and index reorg

Session Number: 2098
Track: DB2 for LUW Lessons Learned (D)
Session Type: Podium Presentation
Primary Presenter: Saeid Mohseni [Head of database team - Folksam]
Time: Nov 16, 2011 (11:00 AM - 12:00 PM)
Room: Stella

Speaker Bio: Head of database team at Folksam Insurance Co. in Sweden. Saeid has over 30 years of experience in the Information Technology field, and 23 years of experience with the DB2 family of products. His area of expertise include database administration / database architect with focus on performance tuning in OLTP and BI from SQL and DB2 LUW engine’s point of view, database recovery and system development using DB2. Saeid is former IBM employee and DB2 LUW specialist. He is DB2 LUW instructor - has been teaching IBM’s DB2 LUW public classes for more than a decade in Sweden and other Nordic countries. Saeid is co-author of IBM redbook (DB2 UDB V8 non-DPF Performance Guide for High Performance OLTP and BI). He is frequently speaker at RUG and member of IDUG – EMEA CPC.
Audience experience level: Intermediate, Advanced
Presentation Category: Data Management
Presentation Platform: Select a Value
Audiences this presentation will apply to: Data Architects, Database Administrators, Systems Programmers
Technical areas this presentation will apply to: Disaster Recovery (DB2 for z/OS), High Availability (DB2 for LUW), New Release (DB2 for LUW), Tools and Utilities, Triggers, Stored Procedures, UDFs
Objective 1: Offline table reorg and index reorg overview
Objective 2: Offline table reorg indepth
Objective 3: Index reorg indeapth
Objective 4: Offline table reorg - index reorg and recovery
Objective 5: Online table move and table reorg

Abstract:  In this presentation reviews offline table and index reorg in detail. You learn the offline table reorg phases, when tempspace is used, how much extra storage is needed and sort / no-sort scenarios during table reorg - you get more knowledge about index online and offline reorg. The presentation covers even locking, logging and rollforward recovery/crach recovery scenarios from reorg perspective. We end this session by looking closer to DB2 V9.7 procedure ADMIN_MOVE_TABLE's reorg option.

For questions or concerns about your event registration, please contact