Browse Prior Art Database

Relational Data Base System Operator Performance in the Presence of Faults

IP.com Disclosure Number: IPCOM000059694D
Original Publication Date: 1986-Jan-01
Included in the Prior Art Database: 2005-Mar-08

Publishing Venue

IBM

Related People

Authors:
Haderle, DJ Ku, GT Palmer, S [+details]

Abstract

In the prior art, all information about the relational data base (DB) privileges, including the system operator's (SYSOPR) privileges, was recorded in the DB catalog. Whenever an authorization ID wanted to perform SYSOPR functions, such as issuing DB DISPLAY, TRACE, RECOVER, or STOPALL commands, DB Authorization had to retrieve information from the catalog in order to allow or disallow the authorization ID to perform the requested functions. If the catalog was not available due to some reason, such as a damaged catalog, etc., then DB Authorization could not perform its function normally and SYSOPR IDs could not pass the DB authorization check to perform their functions, which needed to be performed in order to know the DB status. This article relates to a method for eliminating the above problem.