International Business Machines Corporation

Yoshinobu Ueno

Jack Chiu-Chiu Yuan

Jack C Yuan

Michael Richard Artobello

Kevin Richard Stewart

Steve T Kuo

Gerald Dean Hughes

James Edward Zimmer

Andrew Daniel Tollerud

Getachew G Birbo

Joyce Yuan-Sheng Hsiao

Sandra L Sherrill

Michael R Artobbello

Paul Dennis Seyforth

Stephen Paul Nathan

An apparatus, system, and method are provided for sharing a cached security profile in a database environment. The apparatus, system, and method include a cache module for caching a security profile accessible to primary tasks and secondary tasks. An identification module is provided that distinguishes between primary tasks authorized to refresh the security profile and secondary tasks. A refresh module cooperates with the cache module and identification module to selectively refresh the security profile in response to a refresh request and expiration of the security profile such that an old version of the security profile is retained for use by secondary tasks until an execution window closes.

Apparatus and method for sharing a cached security profile in a database environment

An apparatus, system, and method are provided for automatically freeing locked server resources using a timeout value closely related to actual real-time message delays plus a delta value that can be adjusted at a plurality of levels. The levels include default, server, connection, and transaction. The apparatus includes a timer, a communication module, a computation module, and a lock handler. The timer determines a timeout value for communications from a client to a server. The communication module sends an output message to the client and locks a server resource in anticipation of an acknowledgement (ACK) message from the client. The computation module, which calculates an ACK timer, includes a difference between a send time and a current time. If no ACK message has been received from the client and the ACK timer exceeds the timeout value, the lock handler may free the locked server resource.

Apparatus, system, and method for automatically freeing a server resource locked awaiting a failed acknowledgement from a client

Apparatus, system, and method for sharing a cached security profile in a database environment

A request is received from a user associated with the client and a transaction aging value is copied to a security aging value associated with the cached user security profile if the transaction aging value is specified with the user request. A decay time is calculated utilizing a profile refresh time stamp associated with the cached user security profile and a system clock. The cached user security profile is then refreshed if a refresh event occurs.

Multi-level security profile refresh

Growing community of inventors

San Jose, CA, United States of America

Yoshinobu Ueno