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

SQL Monitoring Area for the OS/2 Database Manager Database Monitor

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

Publishing Venue

IBM

Related People

Jacobs, DC: AUTHOR

Abstract

A method is described which will allow the user of the OS/2* Database Manager Database Monitor Get Database Monitoring Information and the Get Application Information APIs to specify multiple collection options.

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

SQL Monitoring Area for the OS/2 Database Manager Database Monitor

      A method is described which will allow the user of the
OS/2* Database Manager Database Monitor Get Database Monitoring
Information and the Get Application Information APIs to specify
multiple collection options.

      When using the OS/2 Database Manager Database Monitor Get
Database Monitoring  Information and the Get Application Information
APIs, several different levels of information collection may be
desirable.  These levels consist of node-, database-, and
application- related information.
Problem:

      The user may require diverse information relative to the above
levels.  Consider the following example: How  does  a  user  specify
information related to specific entities?  How will the user specify
APP1, APP4, DB2*, and A for data collection.
Solution:

      The  SQL Monitoring Area (SQLMA) will be used on the interface
to the Get Database Monitoring Information.  The SQLMA is  a  dynamic
data  area used  to  identify  what types of information that will be
returned.  The data area description is as follows:

      The first member of the SQLMA structure is obj_num. This member
is set by the user and represents the number of obj_var substructures
in the SQLMA.

      The SQLMA contains an object substructure, obj_var. The first
member of the  structure  contains, obj_type, specifying the type of
object contained in the object member of the obj_var.  The value of
obj_type can be one of the following:
      SQLM_NODE            - node-related information
      SQLM_DBASE           - database-related information
      SQLM_APPL            - application-related information
      SQLM_DBASE SQLM_APPL - all application-related info for
                             a specified database.

      The next member of the obj_var structure is obj_length. This
member represents the length of the data in the object member of the
obj_var structure.

      The last member, object, contains the actual object. It is
either the database name or the application ID for which data
collection is desired.  The member can be up to 8 characters if it is
a database name and is a 9-character string of digits if it is an
application id.

      If obj_type in the obj_var is set exclusively to SQLM_NODE,
anything in the object member of t...