Browse Prior Art Database

Database Administrators Utility (DBA Platform)

IP.com Disclosure Number: IPCOM000122051D
Original Publication Date: 1991-Oct-01
Included in the Prior Art Database: 2005-Apr-04
Document File: 1 page(s) / 45K

Publishing Venue

IBM

Related People

Devany, EP: AUTHOR [+4]

Abstract

This disclosure describes a method which provides administrative tools for the Database Manager. Operational status information is collected and returned to System Administrators and Database Administrators for both Local and Remote databases.

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

Database Administrators Utility (DBA Platform)

      This disclosure describes a method which provides
administrative tools for the Database Manager.  Operational status
information is collected and returned to System Administrators and
Database Administrators for both Local and Remote databases.

      Prior to the implementation of this function very limited tools
were available to aid System/Database Administrators in providing
status information on the operation of their databases.  This status
information can be used to adjust configuration parameters and
application programs for optimum database performance.

      Four functions are defined to provide the status information
required for the user:
  Collect Database Status:
     This function takes a 'snapshot' of the requested activity and
status.  If database status is requested, that information is also
returned in the caller's buffer.
  Get Next Database Status Block:
      This function can be used to return status for one or more
databases collected from a previous Collect Database Status call.
This function is used only if all the information was not returned on
the first Collect Database Status call.
  Get User Status:
      If user status was requested to be collected on the Collect
Database Status call, this function will return status information
for all users connected to a specified database.
  Terminate Database Status:
      When the caller is finished with this sta...