Articles & Content


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

Topic: 2010 EMEA

Subtopic: DB2 for z/OS

DATE: 2010-11-11 (11:15 - 12:15)
SPEAKERS: Steve Thomas (BMC Software)

Ever since I started using DB2 V1.3 in 1989, DBAs have needed the ability to change database structures with minimal interruption to the Business Service. Sadly back then almost all you could do was to add new columns to the end of a Table. Fortunately the situation has improved signifcantly over the years and many if not most schema changes can now be made online. However, recently I have seen more customers needing to change Tablespace characteristics such as DSSIZE or SEGSIZE, or to convert objects to the new UTS format introduced in DB2 9 for z/OS. Currently all these changes still require you to Unload and Load the data, leading to a siginficant outage.This presentation explains what you can change online and what you can't, and describes a vendor neutral method for reducing the outage required when making some of the changes that have not yet been addressed by improvements to DB2. The session will include features up to and including DB2 9 for z/OS. Changes planned for DB2 10 for z/OS can only be covered if it's been Announced or made Generally Available due to Non-Disclosure Agreements, but will be included if permitted to do so by the date of the Conference.

EXP. LEVEL: Beginner,Intermediate


Learn what Schema Changes can be made Online using different releases of DB2 for z/OS

Understand what cannot be changed without incurring a significant outage

Describe a Vendor neutral method to reduce the outage in many cases when making changes that are not permitted by DB2

Cover the new features introduced in DB2 9 for z/OS, and, if permitted by IBM announcements and release schedules, DB2 10 for z/OS


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.