View Printable Version

D07 - Best Practices for Minimizing and Eliminating Planned Outages with DB2 LUW

Session Number: 3121
Track: D - DB2 for LUW II
Session Type: Podium Presentation
Primary Presenter: Matt Huras [IBM]
Time: Nov 17, 2015 (02:00 PM - 03:00 PM)

Speaker Bio: Matt Huras is the chief architect of DB2 for Linux Unix and Windows. He was a founding member of the development team, more than 20 years ago, and has played a key role in implementing and/or leading many of DB2's marquee capabilities, including it's multi-threading engine, it's prefetching I/O subsystem, compression, pureScale, and several others. He possesses a Bachelor of Applied Science from the University of Waterloo, and a Master of Engineering from the University of Toronto. Matt is a Distinguished Engineer, Master Inventor, and member of the IBM Academy.
Audience experience level: Intermediate
Presentation Platform: DB2 for Linux, UNIX, Windows
Presentation Category: New DB2 Releases and Features
Audiences this presentation will apply to: Data Architects, Database Administrators
Objective 1: Learn DB2 LUW best practices for minimizing planned outages
Objective 2: Learn selected DB2 LUW internals
Objective 3: Learn DB2 LUW best practices for table and tablespace maintenance
Objective 4: Learn DB2 LUW best practices for configuration change
Objective 5: Learn DB2 LUW best practices for software maintenance

Abstract:  Planned events such as version upgrades, reorgs, and schema changes can be a large source of downtime. This presentation describes the key best practices DB2 LUW DBAs can use to minimize and, in fact, eliminate planned outages. Topics covered include :
- table maintenance and reorganization
- tablespace maintenance
- data load/ingest
- logging, backup and recovery
- fixpack updates and version upgrades
- configuration
- schema change
- avoiding perceived outages associated wtih locking/concurrency
In each area, the best practices DBAs should know will be described, including those that take advantage of features in the latest release. In addition, where appropriate, the fundamental underlying DB2 technology will also be described. This will give the audience a deeper appreciation for the rationale behind the best practice.

For questions or concerns about your event registration, please contact