High Speed Structure Change in DB2 9 with BMC

 DB2 9 introduced Universal Table Spaces which provide better performance and easier space management. It is to your advantage to convert to this new definition, but doing so could require a large amount of down time for your production data. This presentation will discuss the High-speed Structure Change process which allows you to convert to this new data definition with minimal outage and reduced CPU requirements.

• Learn how customers currently change the physical attributes of table space and indexes.
• Learn how the High-speed Structure Change process helps you change the physical attributes of your table spaces and indexes while providing high availability to your data and requiring less CPU.
• Understand the steps required to change the physical attributes of your table space and indexes while allowing read only access during theconversion.
• Understand the steps to change the physical attributes of your table space and indexes while allowing update access during the conversion.
• Compare performance statistics on the three different processes.