Dismiss
InnovationQ will be updated on Sunday, Oct. 22, from 10am ET - noon. You may experience brief service interruptions during that time.
Browse Prior Art Database

Get Database Server Application Information for the Os/2 Database Manager

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

Publishing Venue

IBM

Related People

Jacobs, DC: AUTHOR

Abstract

A method is described which will enable the user to get information about all applications/units of work which are executing on an OS/2* Database Manager database server. This information will be used when using the OS/2 Database Manager snapshot monitoring API to gather detailed application/unit of work information about specific database applications running.

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

Get Database Server Application Information for the Os/2 Database
Manager

      A method is described which will enable the user to get
information about all applications/units of work which are executing
on an OS/2* Database Manager database server. This information will
be used when using the OS/2 Database Manager snapshot monitoring API
to gather detailed application/unit of work information about
specific database applications running.

      In the distributed Database Manager (DBM) arena, there can be
several application requesters connected to the same database or
different databases on the database server.  All of the nodes,
databases, and applications in the network environment are
monitorable with the OS/2 Database Manager Database Monitor APIs.
Using these APIs provides information to the DBA so informed changes
can be made to the Database Manager configuration parameters to
increase the throughput of the Database Manager system.  Information
returned will also offer explanation of certain conditions existing
in the DBMS (e.g., bad performance).

      How does a Database Administrator know what nodes,
applications, and or users are attached to the server node in a
distributed database environment?  How does the user get monitoring
information related to specific units of work or applications in that
environment?

      Using the OS/2 Database Manager snapshot APIs, the Database
Administrator could collect information for all applications
connected to the server (which could mean a drastic performance
degradation to the DBM system).  The user would then, within their
application, have to wade through the returned information looking
for the specific information for the application which he is
interested in (which means a painful burden will be placed on the
developer; not very customer driven, or user friendly).

      Consider the example i...