Sysplex shared data coherency method
    2.
    发明授权
    Sysplex shared data coherency method 失效
    Sysplex共享数据一致性方法

    公开(公告)号:US5537574A

    公开(公告)日:1996-07-16

    申请号:US860805

    申请日:1992-03-30

    摘要: A method for controlling coherence of data elements sharable among a plurality of independently-operating CPCs (central processing complexes) in a multi-system complex (called a parallel sysplex) which contains sysplex DASDds (direct access storage devices) and a high-speed SES (shared electronic storage) facility. Sysplex shared data elements are stored in the sysplex DASD under a unique sysplex data element name, which is used for sysplex coherence control. Any CPC may copy any sysplex data element into a local cache buffers (LCB) in the CPC's main storage, where it has an associated sysplex validity bit. The copying CPC executes a sysplex coherence registration command which requests a SES processor to verify that the data element name already exists in the SES cache, and to store the name of the data element in a SES cache entry if found in the SES cache. Importantly, the registration command communicates to SES the CPC location of the validity bit for the LCB containing that data element copy. Each time another copy of the data element is stored in any CPC LCB, a registration command is executed to store the location of that copy's CPC validity bit into a local cache register (LCR) associated with its data element name. In this manner, each LCR accumulates all CPC locations for all LCB validity bits for all valid copies of the associated data element in the sysplex -- for maintaining data coherency throughout the sysplex.

    摘要翻译: 一种用于控制在多系统复合体(称为并行系统复合体)中的多个独立操作的CPC(中央处理复合体)之间可共享的数据元素的相干性的方法,其包含系统复合DASDds(直接访问存储设备)和高速SES (共享电子存储)设施。 Sysplex共享数据元素以独特的sysplex数据元素名称存储在系统复合DASD中,用于进行系统复合相干控制。 任何CPC都可以将任何sysplex数据元素复制到CPC的主存储器中的本地缓存缓冲区(LCB)中,其中具有相关联的系统复合有效性位。 复制CPC执行系统复合一致性注册命令,该命令请求SES处理器验证数据元素名称是否已经存在于SES缓存中,并且如果在SES缓存中存在,则将数据元素的名称存储在SES缓存条目中。 重要的是,注册命令与SES通信包含该数据元素副本的LCB的有效位的CPC位置。 每当数据元素的另一副本存储在任何CPC LCB中时,执行注册命令以将该副本的CPC有效位的位置存储到与其数据元素名称相关联的本地高速缓存寄存器(LCR)中。 以这种方式,每个LCR对于sysplex中相关联的数据元素的所有有效副本累积所有LCB有效位的所有CPC位置,以保持整个系统复杂度的数据一致性。

    Partial page write detection for a shared cache using a bit pattern
written at the beginning and end of each page
    3.
    发明授权
    Partial page write detection for a shared cache using a bit pattern written at the beginning and end of each page 失效
    使用在每个页面的开头和结尾写入的位模式,对共享高速缓存进行局部页写入检测

    公开(公告)号:US5455942A

    公开(公告)日:1995-10-03

    申请号:US955076

    申请日:1992-10-01

    摘要: Disk check bits refer to bit patterns stored in particular bytes of a page which are used to detect errors in writing the page to storage. Every time a page is obtained from storage, changed from the version retained in storage, and written back to storage, the check bit pattern on the changed page is altered to be different from the bit pattern on the storage page. This is because the changed page overwrites the stored page. The invention provides a method for managing the check bits in a multi-DBMS system employing a high-speed shared electronic store as a store-in cache for all pages obtained from disk storage. When a page is first obtained from disk storage by a DBMS and changed, check bit information for the page is maintained in a directory of the storing cache which indicates what the patterns are for the version of the page in the disk storage. All pages which are modified are stored in the store-in cache and are only returned to disk storage from the cache. Therefore, when a page is to be written to disk storage, the DBMS writing the page to storage processes the check bits on the page itself, changing them as required based on the check bit information stored in the directory for the page.

    摘要翻译: 磁盘检查位是指存储在页面的特定字节中的位模式,用于检测将页面写入存储器时的错误。 每次从存储中获取页面时,从存储中保留的版本中更改页面,并将其写回存储器,更改页面上的校验位模式将更改为与存储页面上的位模式不同。 这是因为更改的页面将覆盖存储的页面。 本发明提供一种用于管理采用高速共享电子商店的多DBMS系统中的校验位的方法,作为从磁盘存储器获得的所有页面的存储高速缓存。 当页首首先由DBMS从磁盘存储器中获取并更改时,检查页面的位信息是否保存在存储缓存的目录中,该目录指示磁盘存储器中页面版本的模式。 被修改的所有页面都存储在存储缓存中,只能从高速缓存返回到磁盘存储。 因此,当将页面写入磁盘存储器时,将页面写入存储器的DBMS处理页面本身的校验位,根据存储在页面目录中的校验位信息根据需要进行改变。

    Computer program product for off-loading host-based DBMS predicate
evaluation to a disk controller
    4.
    发明授权
    Computer program product for off-loading host-based DBMS predicate evaluation to a disk controller 失效
    用于将基于主机的DBMS谓词评估卸载到磁盘控制器的计算机程序产品

    公开(公告)号:US5586315A

    公开(公告)日:1996-12-17

    申请号:US513696

    申请日:1995-08-11

    IPC分类号: G06F12/00 G06F11/14 G06F17/30

    摘要: A computer program product, such as a pre-recorded software program on a floppy disk, is disclosed, for use with a processing and database system for off-loading, to disk controller, the extraction of committed data. Responsive to the pre-recorded program instructions, the system first picks a Commit.sub.-- LSN value and insures all the data modified prior to the Commit.sub.-- LSN value is processed following the DBMS policy of reducing some disk I/Os or not for the modified pages cached in the system. If the policy is not to do disk I/Os for such pages, then the system places the identifiers of those pages in an ignore list. Otherwise, the system writes those pages to disk and empties the ignore list. Afterwards, the system forwards the ignore list and the Commit.sub.-- LSN along with information regarding the data to be processed to the controller. The controller performs the off-load function by reading from disk every page identified by the system except those in the ignore list, and determining, for each page, if the page's Page.sub.-- LSN value is less than the Commit.sub.-- LSN. If it is, then the controller processes the page and adds any qualifying data from that page to a defined answer set. Otherwise, the controller adds the Page.sub.-- ID for that page to a defined exception list. The controller than passes the answer set and the exception list to the system. The system processes the pages identified in the exception list and those in the ignore list. The system consolidates these answers with the answer set returned by the controller for presentation to the user.

    摘要翻译: 公开了一种计算机程序产品,例如软盘上的预先记录的软件程序,用于与用于卸载的处理和数据库系统一起用于磁盘控制器提取已提交的数据。 响应于预先记录的程序指令,系统首先选择一个Commit-LSN值,并确保在Commit-LSN值之前修改的所有数据在遵循减少某些磁盘I / O的DBMS策略之后被处理 缓存在系统中。 如果策略不为这些页面执行磁盘I / O,则系统将这些页面的标识符放置在忽略列表中。 否则,系统将这些页面写入磁盘并清空忽略列表。 然后,系统将忽略列表和Commit-LSN以及有关要处理的数据的信息转发给控制器。 控制器通过从除了忽略列表中的系统之外的系统识别的每个页面读取磁盘来执行卸载功能,并且为每个页面确定页面的页面-LSN值是否小于Commit-LSN。 如果是,则控制器处理该页面并将该页面中的任何限定数据添加到定义的答案集。 否则,控制器将该页面的Page-ID添加到定义的异常列表中。 控制器将答案集和异常列表传递给系统。 系统处理异常列表中标识的页面和忽略列表中的页面。 系统将这些答案与控制器返回的回答集合合并,以呈现给用户。

    Method and means for archiving modifiable pages in a log based
transaction management system
    5.
    发明授权
    Method and means for archiving modifiable pages in a log based transaction management system 失效
    在基于日志的事务管理系统中归档可修改页面的方法和手段

    公开(公告)号:US5455946A

    公开(公告)日:1995-10-03

    申请号:US66360

    申请日:1993-05-21

    摘要: A method and means for achieving files of modifiable pages in a log based phased commit transaction management system (TMS) in which those pages which have been modified since the last full or incremental backup donot require during the copy operation any modifications to the page itself but merely to a common status page. This is accomplished by management of a pair of global log sequence numbers. Comparison between a first number (ICBU.sub.-- LSN) and each data page LSN as the page is modified permits the common status page to be updated to correctly reflect the changed status. Subsequent modifications to the same page donot require amendment of the status page. The status page indicia are reset as part of the backup procedure and for ascertaining the page copy set for incremental copying. The ICBU LSN assumes one of two values as a function of the copy operation and another value for processing page modifications after the copy operation. A second number (ICRF.sub.-- LSN) is used in the restoration of a file after the file has been partially restored by a page merge in page number order from full and incremental copies. In this case, the ICRF.sub.-- LSN defines the point in the log for redo since the most recent copy was made.

    摘要翻译: 一种用于在基于日志的分阶段提交事务管理系统(TMS)中实现可修改页面的文件的方法和手段,其中自上次完全备份或增量备份之后修改的页面在复制操作期间需要修改页面本身但是 只是一个共同的状态页面。 这是通过管理一对全局日志序列号来实现的。 第一个数字(ICBU-LSN)和页面修改的每个数据页面LSN之间的比较允许更新公共状态页面以正确反映已更改的状态。 对同一页面的后续修改不需要修改状态页面。 状态页标记被重置为备份过程的一部分,并用于确定用于增量复制的页面副本集。 ICBU LSN假定作为复制操作的函数的两个值之一,以及在复制操作之后处理页面修改的另一个值。 第二个数字(ICRF-LSN)用于在从完整版本和增量副本以页码顺序的页面合并部分恢复文件之后恢复文件。 在这种情况下,ICRF-LSN定义了从最近的拷贝进行的日志中的重做点。

    Fast intersystem page transfer in a data sharing environment with record
locking
    7.
    发明授权
    Fast intersystem page transfer in a data sharing environment with record locking 失效
    在具有记录锁定的数据共享环境中快速进行系统间页面传输

    公开(公告)号:US5327556A

    公开(公告)日:1994-07-05

    申请号:US59734

    申请日:1993-05-11

    摘要: A fast technique for transferring units of data between transaction systems in a shared disk environment. The owning system, having updated the page, generates a version number for the page which is stored with a lock possessed by the owning system. When a requesting system seeks a record on the page, its request for a lock illicit an indication that a more recent version of the page is required in the local memory. The buffer management component of a DBMS, with assistance from the lock management, triggers a memory to memory transfer of the page from the owning DBMS to the requesting DBMS using a low overhead communication protocol. The transfer of page is without disk I/O or the log I/O for the updates made to the page.

    摘要翻译: 一种用于在共享磁盘环境中的事务系统之间传输数据单元的快速技术。 拥有该系统的页面更新后,会生成一个版本号,用于存储拥有系统所拥有的锁的页面。 当请求系统寻求页面上的记录时,其对锁的请求非法地指示在本地存储器中需要更新版本的页面。 DBMS的缓冲区管理组件在锁定管理的帮助下触发内存,使用低开销通信协议将页面从拥有的DB​​MS内存传输到请求DBMS。 页面的传输没有磁盘I / O或用于对页面进行更新的日志I / O。

    Method for managing database recovery from failure of a shared store in
a system including a plurality of transaction-based systems of the
write-ahead logging type
    8.
    发明授权
    Method for managing database recovery from failure of a shared store in a system including a plurality of transaction-based systems of the write-ahead logging type 失效
    用于从系统中的共享存储器的故障中管理数据库恢复的方法,包括多个基于事务的预写记录类型的系统

    公开(公告)号:US5280611A

    公开(公告)日:1994-01-18

    申请号:US790241

    申请日:1991-11-08

    摘要: In a multi-system data sharing complex, a database system can write updated pages to a shared electronic store for a fast write. Other database systems can obtain pages written to the shared store for further modification without the pages first being written to stable storage. However, pages are eventually written to the stable storage in a castout process. Recovery of a database from failure of the shared store is bounded by determination of a recovery boundary which, when applied to the union of database system transaction logs, establishes a point in front of which are found log records of modifications to pages which were in the shared store when it failed. These log records are applied to page versions obtained from stable storage to recover from failure of the shared store.

    摘要翻译: 在多系统数据共享复合体中,数据库系统可以将更新的页面写入共享电子商店以进行快速写入。 其他数据库系统可以获得写入共享存储区的页面,以便进一步修改,而无需首先将页面写入稳定存储。 但是,页面最终会在castout进程中写入稳定存储。 通过确定恢复边界来限制数据库的恢复,该恢复边界在应用于数据库系统事务日志的并集时建立一个前面的点,找到对位于 共享存储失败时。 这些日志记录应用于从稳定存储获得的页面版本,以从共享存储的故障中恢复。

    Non-blocking serialization for caching data in a shared cache
    9.
    发明授权
    Non-blocking serialization for caching data in a shared cache 失效
    用于在共享缓存中缓存数据的非阻塞序列化

    公开(公告)号:US5276835A

    公开(公告)日:1994-01-04

    申请号:US628211

    申请日:1990-12-14

    摘要: A method of controlling entry of a block of data is used with a high-speed cache which is shared by a plurality of independently-operating computer systems in a multi-system data sharing complex. Each computer system has access both to the high-speed cache and to lower-speed, upper-level storage for obtaining and storing data. Management logic in the high-speed cache assures that the block of data entered into the cache will not be overwritten by an earlier version of the block of data obtained from the upper-level storage.

    摘要翻译: 一种控制数据块的输入的方法与由多系统数据共享复合体中的多个独立操作的计算机系统共享的高速缓存一起使用。 每个计算机系统都可以访问高速缓存和用于获取和存储数据的低速,高级存储。 高速缓存中的管理逻辑确保输入到高速缓存中的数据块不会被从较高级别存储获得的数据块的早期版本覆盖。