International Business Machines Corporation

Euna Park

Tammie Dang

Maryela Evelin Weihrauch

Fen-Ling Lin

Patrick Dooling Bossman

John Joseph Campbell

Claire Willey McFeely

Shengxi Suo

Frank Darl Bower

Thomas Eng

Peter Kuang

Aspects of the invention include techniques for providing a schema evolution on a live database system without an outage. A non-limiting example method includes initiating a schema change on a live database system. The schema change includes an attribute for a database object. A first application package having a user application that is dependent on the database object and that is bound with a release(deallocate) option is identified. Existing threads and new threads executing the first application package are routed to execute the first application package with a release(commit) option and the schema change on the live database system is completed. One or more additional threads concurrently executing one or more additional application packages remain executing with the release(deallocate) option.

Schema evolution on a live database system without an outage

A database system searches for any statements that satisfy one or more of a set of filtering criteria. When a given dynamic query statement fully satisfies the set of filtering criteria, the given statement is stabilized by persistently storing a bound form of the given dynamic query statement. When the given dynamic query statement partly satisfies the set of filtering criteria, a monitoring request is created with the set of filtering criteria to begin monitoring subsequent executions of the statement, and the statement is linked to the monitoring request. When the given dynamic query statement subsequently fully satisfies the set of filtering criteria, the statement is stabilized by persistently storing the bound form of the statement. When the given dynamic query is re-executed, the stabilized statement is loaded, and the PREPARE process is bypassed.

Method to monitor dynamic SQL statements for automatic stabilization in a data sharing environment

Growing community of inventors

Santa Clara, CA, United States of America

Euna Park