International Business Machines Corporation

Frank Darl Bower

James Zu-Chia Teng

Patrick Dooling Bossman

Jay A Yothers

Karelle Lynne Cornwell

William James Franklin

John Richard Lyle

Saiyin Leung

You-Chin Gene Fuh

Maryela Evelin Weihrauch

Tammie Dang

John Joseph Campbell

Adarsh R Pannu

Euna Park

Terrence P Purcell

Roy James Cornford

Peter Kuang

Roy J Comford

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

Provided is a method for online reorganization and increasing the page size of a DB2 object. A base table and related auxiliary table spaces are reorganized concurrently via a database utility, DB2 REORG utility. The database utility determines which auxiliary tables are related to the base table and automatically includes their respective auxiliary table in the same invocation of the utility. The reorganization is performed via allocated shadow data sets; page size of the allocated shadow data sets is dynamically updated during reorganization. The original data sets are switched with the newly built shadow data sets, and DB2 catalog values and control blocks are updated with new page size values.

Method of changing the page size of a DB2 table space while keeping the object available

An apparatus, system, and method are disclosed for ensuring query execution plan stability in a database management system. The present invention binds a static database query to a new query execution plan (QEP) that produces the same result set as an original QEP bound to the static database query. Next, the present invention identifies one of the original QEP and the new QEP as a primary QEP and automatically collects execution statistics for the original QEP and the new QEP. Finally, the present invention automatically selects one of the original QEP and the new QEP as the primary QEP in response to completion of the automatic collection of execution statistics, the primary QEP selected such that the automatically selected QEP provides optimal execution performance based on performance criteria in comparison to the automatically unselected QEP, the primary QEP selected based on the execution statistics.

Apparatus, system, and method for ensuring query execution plan stability in a database management system

Provided is a method for online reorganization and increasing the page size of a DBobject. A base table and related auxiliary table spaces are reorganized concurrently via a database utility, DBREORG utility. The database utility determines which auxiliary tables are related to the base table and automatically includes their respective auxiliary table in the same invocation of the utility. The reorganization is performed via allocated shadow data sets; page size of the allocated shadow data sets is dynamically updated during reorganization. The original data sets are switched with the newly built shadow data sets, and DBcatalog values and control blocks are updated with new page size values.

Growing community of inventors

San Jose, CA, United States of America

Frank Darl Bower