Abstract: 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.

Abstract: A selective execution system allows a user to grant a lesser authority to individuals for normal use, but allow them the ability to use a higher level of authority while completing dependent object redefinition. The present system grants the limited ability to recreate dropped objects or views without allowing the user to redefine the object or view. A modification detection code (MDC) is generated for each statement in the tables and dependent views and written to the electronic media. Each party or program along the execution path can read the statement and validate its integrity by regenerating a MDC for the statement and comparing it to the original. If the MDCs match, the statement's integrity is assured and processing can take place accordingly. If the MDCs do not match, alternative processing can take place. Just prior to an statement's execution, the MDC comparison is made to ensure the statement is unaltered and can be processed as desired, such as with the higher authority.