Browse Prior Art Database

Dynamic Memory Estimation for Database Monitor Snapshot

IP.com Disclosure Number: IPCOM000104241D
Original Publication Date: 1993-Mar-01
Included in the Prior Art Database: 2005-Mar-18
Document File: 1 page(s) / 45K

Publishing Venue

IBM

Related People

Corn, CF: AUTHOR [+2]

Abstract

Disclosed is a method for dynamically estimating the amount of memory required for taking a snapshot of the Database Manager.

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

Dynamic Memory Estimation for Database Monitor Snapshot

      Disclosed is a method for dynamically estimating the amount of
memory required for taking a snapshot of the Database Manager.

      Database Monitor provides statistical information regarding the
operation of the Database Manager.  One of the Database Monitor's
features is to allow the user to take a snapshot of the Database
Manag- er.  The Snapshot Application Programming Interface (API)
collects information about the current operational status of the
Database Manager in real time.  The user can call the Snapshot API to
gather information about the current node, the active databases, and
the applications that are connected to a specific database.  The
collected information is immediately returned to a user-allocated
memory area.  Since the snap- shot is taken in a dynamic environment,
the amount of information returned varies depending on the number of
the active databases, users, tables currently open, etc.

      The Estimate Buffer Size Application Programming Interface
(API) is designed to allow the user to specify in the input parameter
the lev- el(s) of information to be collected and calculates the
required buffer size based on the level(s) of information to be
collected and the number of currently active databases, the number of
applications currently connected to the database, and/or the number
of open tables.  The API also adds allowance to the required buffer
size to accommodate app...