Articles & Content

Archives

Converting Any Table With a 5 Min Outage, Really (B10)

Topic: 2006 NA

Subtopic: Cross Platform DB2 for z/OS & LUW



DATE: 2006-05-10 (02:30 PM - 03:40 PM)
SPEAKERS: Anthony Tichonoff (Florida Hospital)

One of the biggest challenges facing DBAs is minimizing database outages. Converting large tables pose a significant threat to availability. Even with DB2 V8 improvements, partitioned tablespace conversion is still necessary at times. This presentation details a technique to convert even the largest partitioned table with only a 5 minute outage. What's more is it can work for you. Come and see for yourself.

EXP. LEVEL: Intermediate,Advanced

OBJECTIVES:

Non-disruptive unload/drop/create/load concept

Preliminary planning and setup preparations

Creating and synchronizing the new table

Auditing the conversion results non-disruptively

Cutting to the new table, Savor it



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!

Download File
Click to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.