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