Browse Prior Art Database

Remote Database Status

IP.com Disclosure Number: IPCOM000105092D
Original Publication Date: 1993-Jun-01
Included in the Prior Art Database: 2005-Mar-19
Document File: 2 page(s) / 62K

Publishing Venue

IBM

Related People

Devany, EP: AUTHOR [+3]

Abstract

Disclosed is a method to provide status information to a database administrator for remote databases.

This text was extracted from an ASCII text file.
This is the abbreviated version, containing approximately 52% of the total text.

Remote Database Status

      Disclosed is a method to provide status information to a
database administrator for remote databases.

      A remote database administrator needs to collect information
per taining to a database usage by users within a network who have
access to a specific database.  The information collected can be used
to detect bottlenecks, inefficient usage, or users who are
continually locked out for long periods of time.  The following
paragraphs give a brief de scription of the operation of the Database
Manager* and the method used to collect and access the remote status
information.

      Each active database runs in a separate process in the Database
Manager.  An Application Control Block (ACB) is maintained on behalf
of the application connected to the database in that process.  All of
the user status information, as well as application status, is kept
in this ACB while the application is connected.  When an application
makes a request to connect to a remote database, information about
the applica tion, such as the userid and the application's node name,
is sent across to the database server to be stored in that
application's ACB.  All other information is taken from the Database
Manager kernel during transaction processing.

      On a database server, several requester applications in a
network can access a database, each with their own ACB.  A list of
ACB's and their locations is maintained for each database.  The ACB
is allocated in shared memory so that other processes can have access
if needed.  When a request is made by a remote administrator to get
user status on a specified database, several steps take place:...