Computer Associates Think, Inc.

Stephen J Weaver

Amando B Isip, Jr

Christopher F Parker

Liza N Ramos

Steve Donovan

Joseph Zelenka

Amando Isip

A method of reorganizing a tablespace in a database may include reading a row of data from the database, analyzing the row of data read out from the database, determining whether to eliminate or retain the row of data based on at least one predetermined rule, reloading the row of data into the database when it is determined that the row of data complies with the at least one predetermined rule, eliminating the row of data when it is determined that the row of data does not comply with the at least one predetermined rule, and rebuilding an index related to the database to include keys that correspond to the reloaded row of data. The determining, reloading, eliminating and rebuilding steps are repeated for each row of data in the database.

Method and system for reorganizing a tablespace in a database

Data to be loaded into a table of a database is read from an input file by a LOAD utility including a CHECK subutility that performs constraint checking on each row prior to loading the row into the table. During initialization of the CHECK subutility, the DB2 catalog is read to identify any constraints that apply to the data to be loaded. If any check constraints apply, check constraint routines are built and compiled by the CHECK subutility. If any referential integrity constraints apply, the key values for the parent index of each referential integrity constraint are read and stored in an additional dataspace allocated by the CHECK subutility so that the foreign key values from each row to be loaded can be located by the CHECK subutility and compared against the parent index values prior to loading the data into the table. When the constraint checking for the loading of data is complete, the additional dataspace allocated by the CHECK subutility is released.

Method for loading rows into a database table while enforcing constraints

A recover or reload utility determines if a check utility is to be executed. If a check utility is to be executed, the recover or reload utility records the dependent tablespace names to virtual storage allocated to a job step instead of to virtual storage allocated to a subtask. After the recover or reload utility performs its function, if a check utility is next, the database operating system will not freemain the virtual storage (e.g, data area) into which the recover or reload utility has recorded the names of the dependent tablespaces when the subtask ends. Upon termination of the recover or reload utility, the persistent data area is available for the check utility to use.

Growing community of inventors

Lisle, IL, United States of America

Stephen J Weaver