Browse Prior Art Database

OS/2 Database Manager Database Event Monitor

IP.com Disclosure Number: IPCOM000121480D
Original Publication Date: 1991-Sep-01
Included in the Prior Art Database: 2005-Apr-03
Document File: 2 page(s) / 85K

Publishing Venue

IBM

Related People

Jacobs, DC: AUTHOR [+2]

Abstract

A method is described which will: - Provide information to the Database Administrator (DBA) so that 'educated' changes can be made to the OS/2* EE Database Manager configuration parameters to increase the throughput of the Database Manager System (DBMS). - Provide the user with information which may offer explanation for certain conditions existing in the DBMS (for example, poor performance). - Provide a mechanism with which the user can "trace" SQL statements which are executed on a database. - Give the DBA information which can be used for accounting purposes relative to database activity. With the same information, the DBA may decide to change the structure of the database to increase attention on certain objects.

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

OS/2 Database Manager Database Event Monitor

      A method is described which will:
      -  Provide information to the Database Administrator (DBA) so
that 'educated' changes can be made to the OS/2* EE Database Manager
configuration parameters to increase the throughput of the Database
Manager System (DBMS).
      -  Provide the user with information which may offer
explanation for certain conditions existing in the DBMS (for example,
poor performance).
      -  Provide a mechanism with which the user can "trace" SQL
statements which are executed on a database.
      -  Give the DBA information which can be used for accounting
purposes relative to database activity.  With the same information,
the DBA may decide to change the structure of the database to
increase attention on certain objects.
      -  Give the user information which may be helpful in
identifying the tables that are in need of reorganization.
      -  Provide information which may aid the application developer
in tuning SQL statement structure.

      In the Database Manager (DBM) arena, the performance of the
system is very important.  In fact, the throughput of the system is
one the major considerations of the user when purchasing a DBM
system.  The OS/2 EE Database Manager is a "tuneable" program, and
based on the fact that the user application will have to be
configured differently to insure the maximum throughput of the
Database Management System.
Problem

      With past releases of the OS/2 EE Database Manager, the DBA
would have to surmise what changes to make to the system to increase
performance.  There was considerable guess work involved which
resulted in a very time consuming and frustrating iterative process.
To tune the system properly, information is required when certain
critical events happen within the DBMS.  If the information can not
be gathered when these events occur, it is not retrievable.
Consequently, because this vital and important data is lost, the DBMS
could not be tuned properly and effectively without considerable
amounts of trial and error.

      In  addition, in the previous releases of the D...