公开(公告)号：CA2279028C

公开(公告)日：2002-09-10

申请号：CA2279028

申请日：1999-07-29

Applicant: IBM CANADA

Inventor： ZHENG ROGER LUO Q ,  WINER MICHAEL J ,  HURAS MATTHEW A ,  MCINNIS DALE M ,  OFER EFFI

IPC: G06F17/00 ,  G06F17/30

Abstract: A database management system having a dropped table recovery flag. If the dropped table recovery flag is on, at the time that a table is dropped an entry will be made in a dropped table history file. The dropped table history file contains a timestamp of the time of table dro p, a unique dropped table identifier, and table definition information. The system includes a command to permit the table space of a dropped table to be restored and rolled forward to the point of t he dropped table drop. The restored and rolled forward dropped table data is written to a flat file. Th e flat file data is loaded into a recreated table in the current table space to recover the dropped table.

公开(公告)号：CA2419883A1

公开(公告)日：2004-08-26

申请号：CA2419883

申请日：2003-02-26

Applicant: IBM CANADA

Inventor： OFER EFFI ,  WINER MICHAEL J ,  HURAS MATTHEW A ,  ZHENG ROGER L Q ,  MCINNIS DALE M

IPC: G06F17/30

Abstract: A system and method for selectively processing log files for enhancing performance of table space recovery by processing only those log files required, as well as choosing which log file to process during recovery for both redo and rollback phases of recover y. The system and method skips the processing of log files that do not contain records of interest for the table space being recovered and determines whether a log file contains anything that nee ds to be played, in particular for the recovery of a subsystem in the database, such as a table space. Pre processing of the log files is not done, rather including tablespace ID correlated with log file ID information is collected while the log files are created. The cross-correlated informati on is used during tablespace recovery to selectively determine which of the log files to process. Some log files may be skipped in cases where not all of the database system is being recovered. A sub set of the database can be recovered, such as a tablespace, and which log files to process is determined based on lock intent.

公开(公告)号：CA2279028A1

公开(公告)日：2001-01-29

申请号：CA2279028

申请日：1999-07-29

Applicant: IBM CANADA

Inventor： ZHENG ROGER LUO Q ,  WINER MICHAEL J ,  MCINNIS DALE M ,  HURAS MATTHEW A ,  OFER EFFI

IPC: G06F17/00 ,  G06F17/30

Abstract: A database management system having a dropped table recovery flag. If the dropped table recovery flag is on, at the time that a table is dropped an entry will be made in a dropped table history file. The dropped table history file contains a timestamp of the time of table dro p, a unique dropped table identifier, and table definition information. The system includes a command to permit the table space of a dropped table to be restored and rolled forward to the point of t he dropped table drop. The restored and rolled forward dropped table data is written to a flat file. Th e flat file data is loaded into a recreated table in the current table space to recover the dropped table.