Can you really change DB2 for z/OS Schemas Online?

Date: 
Monday, 13 lipanj, 2011 - 14:15 - 15:15
Speaker: 
Steve Thomas

Ever since I started working with DB2 back in 1989 with Version 1.3, DBAs have needed the ability to change database structures with minimal or zero interruption to the Business Service. Back then almost all you could do was to add new columns to the end of a Table but fortunately the situation has improved significantly over the years and many more schema changes can now be made online. However, just recently I have been speaking to more customers who have needed to change Tablespace characteristics such as DSSIZE or SEGSIZE, or to convert objects to the UTS format introduced in DB2 9 for z/OS. Before the Deferred Alter functionality introduced in DB2 10 for z/OS making any of these changes required you to Unload and Load the data, leading to an extended business outage.

This presentation explains what you can change online and, perhaps more importantly, what you can’t. We also discuss some of the other implications when making a Schema change, such as the impact on Packages, Triggers and Dependent Views. We will discuss a vendor neutral method for reducing the outage required when making changes that cannot be accomplished with an Alter Statement. The session will discuss features available in versions up to and including DB2 10 for z/OS and the new Deferred Alter referred to above.

 

sqladria

SQL Adria is the independent, non-profit organization that gathers relational database users for Croatia and Slovenia. It was founded 1994. and in the same year it has become the regional user group.

Follow us

facebook
linkid
twitter

 

Events in 2023

VODICE -  12th - 15th June 2023