-
公开(公告)号：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
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.
-
公开(公告)号：CA2279051C
公开(公告)日：2004-12-28
申请号：CA2279051
申请日：1999-07-29
Applicant: IBM CANADA
Inventor： WINER MICHAEL J , ZHENG ROGER LUO Q , WONG CATHARINA K , MCKNIGHT KATHY A
Abstract: A lock control data structure for an unit of work of an application program. The unit of work has a set of threads of access for opening a set of objects accessible to th e application program. The lock control data structure has a set of object-specific lock models corresponding to the set of objects, and a lock controller for locking each object in the set of objects . Information regarding the lock requirements for each object are stored in the corresponding object- specific lock model. The lock controller locks and unlocks each object in the set of objects based on the information stored in the corresponding object-specific lock model.
-
公开(公告)号：CA2279051A1
公开(公告)日：2001-01-29
申请号：CA2279051
申请日：1999-07-29
Applicant: IBM CANADA
Inventor： WONG CATHARINA K , WINER MICHAEL J , ZHENG ROGER LUO Q , MCKNIGHT KATHY A
Abstract: A lock control data structure for an unit of work of an application program. The unit of work has a set of threads of access for opening a set of objects accessible to th e application program. The lock control data structure has a set of object-specific lock models corresponding to the set of objects, and a lock controller for locking each object in the set of objects . Information regarding the lock requirements for each object are stored in the corresponding object- specific lock model. The lock controller locks and unlocks each object in the set of objects based on the information stored in the corresponding object-specific lock model.
-
公开(公告)号：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
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.
-
-
-
Search Results
4
records
(took 0.022 seconds)
