Kenneth Duane Mcdonald

US Patent:

7133884, Nov 7, 2006

Filed:

Nov 26, 2003

Appl. No.:

10/723677

Inventors:

Michael S. Murley - Austin TX, US
Thomas G. Price - Austin TX, US
Kenneth M. McDonald - Cedar Park TX, US
Stanley J. Dee - Austin TX, US
Linda S. Ball - Austin TX, US

Assignee:

BMC Software, Inc. - Houston TX

International Classification:

G06F 17/00

US Classification:

707202, 711162

Abstract:

Techniques to create physically and transactionally consistent copies of one or more database objects without impacting the availability of the target database objects are described. In one technique, a consistent copy is created as of the time a copy utility is executed. In another technique, a consistent copy is created as of an arbitrary specified time. This approach modifies a prior copy to bring it “up-to-date. ” In yet another technique, a consistent copy is created by starting with a current snapshot of the target database objects and selectively removing updates from it back to a user specified arbitrary point-in-time. Each of the described techniques generate consistent copies of the target database objects without blocking users from accessing the target objects during the copy operation.

US Patent:

7730044, Jun 1, 2010

Filed:

Apr 2, 2007

Appl. No.:

11/695114

Inventors:

Michael J. Hanus - Cedar Park TX, US
Kenneth M. McDonald - Cedar Park TX, US
Kenneth J. Durfee - Round Rock TX, US
Bobby B. Baty - Austin TX, US

Assignee:

BMC Software, Inc. - Houston TX

International Classification:

G06F 17/30

US Classification:

707695, 707741, 707795, 707954

Abstract:

A mechanism works in conjunction with a DB2 Log and an analysis tool, such as BMC's Log Master™, to handle logged data for Large Objects (LOBs) stored in tables of a DB2 database system. A plurality of controls track data logged for the LOBs. The mechanism reads log records from a DB2 Log and uses the controls to determine which of the tracked LOBs is associated with the log records and obtains data from those associated log records. The mechanism builds keys to index the data and stores the keys and the data in a Virtual Storage Access Method store having Key Sequenced Data Sets maintained separate from the log record store for the DB2 Log. When requested by the analysis tool, the data in the store can be reassembled using the keys and map records in the first store that map the logged data for the tracked LOBs.

US Patent:

7769718, Aug 3, 2010

Filed:

Sep 28, 2006

Appl. No.:

11/536490

Inventors:

Michael S. Murley - Austin TX, US
Thomas G. Price - Austin TX, US
Kenneth M. McDonald - Cedar Park TX, US
Stanley D. Dee - Austin TX, US
Linda S. Ball - Austin TX, US

Assignee:

BMC Software, Inc. - Houston TX

International Classification:

G06F 7/00
G06F 17/00

US Classification:

707649

Abstract:

Techniques to create physically and transactionally consistent copies of one or more database objects without impacting the availability of the target database objects are described. In one technique, a consistent copy is created as of the time a copy utility is executed. In another technique, a consistent copy is created as of an arbitrary specified time. This approach modifies a prior copy to bring it “up-to-date. ” In yet another technique, a consistent copy is created by starting with a current snapshot of the target database objects and selectively removing updates from it back to a user specified arbitrary point-in-time. Each of the described techniques generate consistent copies of the target database objects without blocking users from accessing the target objects during the copy operation.

US Patent:

8121992, Feb 21, 2012

Filed:

Apr 19, 2010

Appl. No.:

12/762592

Inventors:

Michael J. Hanus - Cedar Park TX, US
Kenneth M. McDonald - Cedar Park TX, US
Kenneth J. Durfee - Round Rock TX, US
Bobby B. Baty - Austin TX, US

Assignee:

BMC Software, Inc. - Houston TX

International Classification:

G06F 7/00
G06F 17/00

US Classification:

707695, 707741, 707795, 707954

Abstract:

A mechanism works in conjunction with a DB2 Log and an analysis tool, such as BMC's Log Master™, to handle logged data for Large Objects (LOBs) stored in tables of a DB2 database system. A plurality of controls track data logged for the LOBs. The mechanism reads log records from a DB2 Log and uses the controls to determine which of the tracked LOBs is associated with the log records and obtains data from those associated log records. The mechanism builds keys to index the data and stores the keys and the data in a Virtual Storage Access Method store having Key Sequenced Data Sets maintained separate from the log record store for the DB2 Log. When requested by the analysis tool, the data in the store can be reassembled using the keys and map records in the first store that map the logged data for the tracked LOBs.

US Patent:

8595190, Nov 26, 2013

Filed:

Aug 4, 2011

Appl. No.:

13/198369

Inventors:

Oscar J. Garza - Cedar Park TX, US
Michael J. Hanus - Cedar Park TX, US
Kenneth M. McDonald - Cedar Park TX, US
Kenneth J. Durfee - Round Rock TX, US

Assignee:

BMC Software, Inc. - Houston TX

International Classification:

G06F 7/04
G06F 17/30

US Classification:

707648, 707649, 707640, 707609

Abstract:

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.

US Patent:

20120246179, Sep 27, 2012

Filed:

Mar 23, 2011

Appl. No.:

13/070388

Inventors:

Oscar J. Garza - Cedar Park TX, US
Yanmin Liu - Austin TX, US
Kenneth M. McDonald - Cedar Park TX, US

Assignee:

BMC SOFTWARE, INC. - Houston TX

International Classification:

G06F 17/30

US Classification:

707752, 707E17045

Abstract:

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.