Browse Prior Art Database

General database monitoring development environment

IP.com Disclosure Number: IPCOM000194642D
Publication Date: 2010-Apr-06
Document File: 1 page(s) / 20K

Publishing Venue

The IP.com Prior Art Database

Abstract

IBM Tivoli Composite Application Management (ITCAM) for Applications is one of a family of solutions based on Tivoli Monitoring product. ITCAM helps to ensure the availability and performance of critical applications and application middleware in an integratted e-business environment. The capabilities include the following: Auto-discovery of resources to be monitored Problem identification, notification and correction Historical reporting through centralized data warehouse

This text was extracted from a PDF file.
This is the abbreviated version, containing approximately 62% of the total text.

Page 1 of 1

General database monitoring development environment

General database monitoring development environmentGeneral database monitoring development environment

SQL Definition

SQL DefinitionSQL Definition

     In the SQL definition, the developer need to specify the which requirement ID, and which database version this SQL is compliant. The following sample shows the SQL collecting the SGA information in a database version 10.1 and up, and the requirement ID is RDB_SGA_Detail.
<SQL DBVersion="101" SQLText="

SELECT
INST_ID INSTID,
POOL POOLRESIDE,
NAME COMPNAME,
BYTES MEMSIZE,
round(BYTES/1024,2) * 100 MEMKB,
round(BYTES/(1024*1024),2) * 100 MEMMB
FROM GV$SGASTAT
ORDER BY INST_ID,POOL,NAME
"/>

SQL Engine

SQL EngineSQL Engine


The SQL engine takes the SQL definition as the input data, parse the SQL definition, and run the specified SQL at a real database. By analyzing the information returned from database, the SQL engine knows each column's name, type. More on this, the SQL engine knows what's the valid data on this SQL, and how the collected data should be shown. For example, for the datetime type column, the collected data should be shown as the format YYYY-MM-DD.

Base on the SQL definition and information returned from database, the SQL engine can generate the SQL accessing code for developer, generate the data presentation code depends on how developer present the collected data, and generate the automation test case with test data for QA team .

Generated SQL Accessing Code

Generat...