Conditional write processing for a cache structure of a coupling facility
    3.
    发明授权
    Conditional write processing for a cache structure of a coupling facility 有权
    耦合设施缓存结构的条件写入处理

    公开(公告)号:US08838888B2

    公开(公告)日:2014-09-16

    申请号:US13423640

    申请日:2012-03-19

    IPC分类号: G06F12/00

    摘要: A method for managing a cache structure of a coupling facility includes receiving a conditional write command from a computing system and determining whether data associated with the conditional write command is part of a working set of data of the cache structure. If the data associated with the conditional write command is part of the working set of data of the cache structure the conditional write command is processed as an unconditional write command. If the data associated with the conditional write command is not part of the working set of data of the cache structure a conditional write failure notification is transmitted to the computing system.

    摘要翻译: 用于管理耦合设备的高速缓存结构的方法包括从计算系统接收条件写入命令,并确定与条件写入命令相关联的数据是否是高速缓存结构的工作数据集的一部分。 如果与条件写入命令相关联的数据是高速缓存结构的数据的工作集合的一部分,则将条件写入命令作为无条件写入命令进行处理。 如果与条件写入命令相关联的数据不是高速缓存结构的工作数据集的一部分,则将条件写入失败通知传送到计算系统。

    Efficient destaging of updated local cache pages for a transaction in a
multisystem and multiprocess database management system with a
high-speed shared electronic store
    4.
    发明授权
    Efficient destaging of updated local cache pages for a transaction in a multisystem and multiprocess database management system with a high-speed shared electronic store 失效
    对具有高速共享电子商店的多系统和多进程数据库管理系统中的事务进行更新的本地缓存页的有效降级

    公开(公告)号:US5574902A

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

    申请号:US236284

    申请日:1994-05-02

    IPC分类号: G06F11/14 G06F13/14

    摘要: An efficient procedure for determining the set of buffer pool database pages that must be externalized to stable storage and for scheduling their write I/O's before release of a committing transaction's locks. In a multisystem database management system (DBMS) with high-speed shared external storage (SES) environment, a DBMS instance may follow "force-at-commit" protocol for a database that has intersystem read/write interest or may alternatively follow a "no-force-at-commit" policy when operating with a database for which only one system has interest. By introducing the concept of a series of unique ordinal numbers (ORD#) for each database assigned to buffer pool data pages whenever the page state changes from clean to dirty within a single DBMS instance, this procedure maintains a transaction page list (TPL) for each transaction in ORD# order. Because the dirty page list (DPL) pages are queued in ORD# sequence and each TPL includes all modified pages associated with the transaction, a merge scan with DPL entries can be performed for each TPL at the commit time of the corresponding transaction. This searches the DPL in a single pass with minimal DPL latch contention. The TPL pages requiring destaging are distributed to two processing lists; a first list for immediate force to SES and a second list of "in-use" pages that are forced to SES if necessary upon release of existing process latches.

    摘要翻译: 确定缓冲池数据库页面集合的有效过程,必须将其外部化为稳定存储,并在发布提交事务的锁之前调度其写入I / O。 在具有高速共享外部存储(SES)环境的多系统数据库管理系统(DBMS)中,对于具有系统间读/写兴趣的数据库,DBMS实例可以遵循“强制提交”协议,或者可选地遵循“ 使用只有一个系统感兴趣的数据库进行操作时,无需提交“策略”。 通过在单个DBMS实例中页面状态从干净变为脏的情况下,引入分配给缓冲池数据页的每个数据库的一系列唯一序数(ORD#)的概念,该过程维护一个事务页面列表(TPL),用于 每个交易在ORD#订单。 因为脏页面列表(DPL)页面以ORD#序列排队,并且每个TPL包括与事务相关联的所有修改的页面,可以在相应的事务的提交时间为每个TPL执行具有DPL条目的合并扫描。 这将在DPL中以最小的DPL锁定争用进行一次通过。 需要降级的TPL页面分发到两个处理列表; 第一个立即强制执行SES的列表和第二个“使用中”页面列表,如果必要,在发布现有的进程锁存器时被迫使用SES。

    Method, system and program products for managing changed data of castout classes
    6.
    发明授权
    Method, system and program products for managing changed data of castout classes 失效
    用于管理变更数据的方法,系统和程序产品

    公开(公告)号:US06230243B1

    公开(公告)日:2001-05-08

    申请号:US09251888

    申请日:1999-02-19

    IPC分类号: G06F1200

    摘要: Changed data of castout classes of a coupling facility cache are managed in order to be able to efficiently determine the age of the oldest changed data in the cache. A directory entry representing a changed datum is placed in a data structure corresponding to the castout class of the changed datum. The data structure includes an order queue ordered by timestamps and a process queue, having an ordered portion and an unordered portion. When the directory entry is to be added to the data structure, an attempt is first made to place the entry on the order queue. If the entry is not placed on the order queue within a predefined amount of time, then the entry is placed on the process queue, the order of which is maintained by background tasks. In order to return the oldest entry of the data structure, the smallest entry of the process queue is determined and that entry is then compared to the smallest entry of the order queue. The smaller of those two entries corresponds to the oldest entry for the castout class.

    摘要翻译: 管理耦合设施高速缓存的丢弃类的更改数据,以便能够有效地确定高速缓存中最早更改的数据的年龄。 表示更改的数据的目录条目被放置在与改变的基准的castout类相对应的数据结构中。 数据结构包括由时间戳排序的订单队列和具有有序部分和无序部分的处理队列。 当目录条目要添加到数据结构中时,首先尝试将条目放在订单队列上。 如果条目未在预定义的时间内放置在订单队列上,则该条目将被放置在进程队列中,其顺序由后台任务维护。 为了返回数据结构的最旧条目,确定进程队列的最小条目,然后将该条目与订单队列的最小条目进行比较。 这两个条目中较小的条目对应于castout类的最旧条目。

    Page refreshing procedure using two locking granularities to ensure
cache coherency in a multisystem database processing environment having
a high-speed shared electronic store
    8.
    发明授权
    Page refreshing procedure using two locking granularities to ensure cache coherency in a multisystem database processing environment having a high-speed shared electronic store 失效
    使用两个锁定粒度的页面刷新过程来确保具有高速共享电子商店的多系统数据库处理环境中的高速缓存一致性

    公开(公告)号:US5546579A

    公开(公告)日:1996-08-13

    申请号:US236798

    申请日:1994-05-02

    IPC分类号: G06F9/46 G06F12/08 G06F13/364

    摘要: A method for ensuring data coherence while detecting whether the locally cached copy of a data page is invalid and responsively refreshing the locally cached page from a Shared Electronic Store (SES) in a multisystem shared disk environment. Locally cached data pages may become invalid in a multisystem shared disk environment because of transactions executed by other systems for the common database. Thus, whenever a transaction in a database management system (DBMS) instance desires to read or update a record in a locally cached data page, the DBMS must first verify validity for the locally cached copy and, for stale or invalid copies, must re-read and re-register the latest version in the SES. This invention provides a procedure for the necessary verification and refreshing steps that relies on page latching to serialize the combination of local multiuser and global multisystem activities. The procedure of this invention supports both record and page locking granularities.

    摘要翻译: 一种在检测数据页的本地缓存副本是否无效并且在多系统共享磁盘环境中从共享电子商店(SES)中响应性地刷新本地缓存页面的方法。 由于公共数据库的其他系统执行的事务,本地缓存的数据页可能在多系统共享磁盘环境中无效。 因此,每当数据库管理系统(DBMS)实例中的事务需要读取或更新本地缓存的数据页面中的记录时,DBMS必须首先验证本地缓存的副本的有效性,并且对于陈旧或无效的副本, 在SES中阅读并重新注册最新版本。 本发明提供了一种依赖于页面锁定来序列化本地多用户和全局多系统活动的组合的必要的验证和刷新步骤的过程。 本发明的过程支持记录和页面锁定粒度。

    CONDITIONAL WRITE PROCESSING FOR A CACHE STRUCTURE OF A COUPLING FACILITY
    9.
    发明申请
    CONDITIONAL WRITE PROCESSING FOR A CACHE STRUCTURE OF A COUPLING FACILITY 有权
    用于连接设备的缓存结构的条件写入处理

    公开(公告)号:US20130246713A1

    公开(公告)日:2013-09-19

    申请号:US13423640

    申请日:2012-03-19

    IPC分类号: G06F12/08

    摘要: A method for managing a cache structure of a coupling facility includes receiving a conditional write command from a computing system and determining whether data associated with the conditional write command is part of a working set of data of the cache structure. If the data associated with the conditional write command is part of the working set of data of the cache structure the conditional write command is processed as an unconditional write command. If the data associated with the conditional write command is not part of the working set of data of the cache structure a conditional write failure notification is transmitted to the computing system.

    摘要翻译: 用于管理耦合设施的高速缓存结构的方法包括从计算系统接收条件写入命令,并确定与条件写入命令相关联的数据是否是高速缓存结构的工作数据集的一部分。 如果与条件写入命令相关联的数据是高速缓存结构的数据的工作集合的一部分,则将条件写入命令作为无条件写入命令进行处理。 如果与条件写入命令相关联的数据不是高速缓存结构的工作数据集的一部分,则将条件写入失败通知传送到计算系统。