US 12,189,585 B2
Schema evolution on a live database system without an outage
Tammie Dang, San Jose, CA (US); Thomas Eng, San Jose, CA (US); Shengxi Suo, San Jose, CA (US); Euna Park, Santa Clara, CA (US); Fen-Ling Lin, San Jose, CA (US); Claire McFeely, San Jose, CA (US); and John Joseph Campbell, Alton (GB)
Assigned to International Business Machines Corporation, Armonk, NY (US)
Filed by International Business Machines Corporation, Armonk, NY (US)
Filed on Mar. 23, 2023, as Appl. No. 18/188,690.
Prior Publication US 2024/0320197 A1, Sep. 26, 2024
Int. Cl. G06F 17/30 (2006.01); G06F 9/48 (2006.01); G06F 16/21 (2019.01)
CPC G06F 16/213 (2019.01) [G06F 9/4843 (2013.01)] 20 Claims
OG exemplary drawing
 
1. A computer-implemented method comprising:
initiating a schema change on a live database system, the schema change comprising an attribute for a database object;
during the schema change, identifying a first application package comprising a user application that is dependent on the database object, the first application package bound with a release (deallocate) option;
during the schema change, routing existing threads and new threads executing the first application package to execute the first application package with a release (commit) option; and
completing the schema change on the live database system;
wherein one or more additional threads concurrently executing one or more additional application packages remain executing with the release (deallocate) option.