Bmc Software, Inc.

Oscar J Garza

Kenneth M McDonald

Kenneth J Durfee

Michael J Hanus

Yanmin Liu

Mohamad A Elhage

Described systems and techniques enable log recovery that spans inter-tablespace movement of one or more tables within a database. Log-related processing, including, e.g., system recovery, auditing, or reporting, may be maintained, even when such inter-tablespace table movements occur within a time window defined for the log-related processing. A table movement of a moved table from a source tablespace to a target tablespace within a database may be identified. Within a plurality of log records of the database, pre-move log records identifying the moved table as being included within the source tablespace may be identified, and post-move log records identifying the moved table as being included within the target tablespace may be identified. The pre-move log records may be updated to obtain updated pre-move log records identifying the moved table as being included within the target tablespace.

Log recovery for inter-tablespace table migration

Systems, methods, and computer readable media for automatically generating Data Definition Language (DDL) commands from database log information is described. In general, techniques are disclosed for analyzing database log entries to identify those associated with targeted DDL commands and associating those entries with a DDL command object. The DDL command object may be used (immediately or at some later time) to generate a DDL commands corresponding to the (possibly many) aggregated log records associated with the command object. The use of multiple database log entries as described herein enables the generation of DDL commands that capture database activity occurring over a period of time (full time context auditing) and can, therefore, naturally account for database schema changes.

Log-based DDL generation

In one general aspect, an apparatus can include a completion identifier configured to identify, for completion processing, a large object (LOB) deleted from an auxiliary table within a DB2 database environment based on a space map record associated with the large object where the auxiliary table functions as an auxiliary space to a base table. The apparatus can also include a completion analyzer configured to identify a resource where an image of the large object is stored at a time before the deletion of the large object from the auxiliary table.

Growing community of inventors

Cedar Park, TX, United States of America

Oscar J Garza