Browse Prior Art Database

Lotus Notes Metrics Database

IP.com Disclosure Number: IPCOM000015668D
Original Publication Date: 2002-Feb-04
Included in the Prior Art Database: 2003-Jun-20
Document File: 2 page(s) / 69K

Publishing Venue

IBM

Abstract

Disclosed is a system that uses a Lotus Notes database (Metrics Database) to gather client application statistics. The Metrics Database periodically gathers statistics of batch jobs that are run through a CONTROL-M scheduling application to reveal what happened during the processing of each job. CONTROL-M is scheduling software that runs batch jobs for applications like HR payroll, Finance, etc. and runs on a wide variety of operating systems. The Metrics database breaks down the statistics to provide a clear view on how well the batch has run. Viewing the metrics helps determine application problems to be able to reduce the amount of abends and error conditions in order to make the application run smoothly.

This text was extracted from a PDF file.
At least one non-text object (such as an image or picture) has been suppressed.
This is the abbreviated version, containing approximately 50% of the total text.

Page 1 of 2

Lotus Notes Metrics Database

Disclosed is a system that uses a Lotus Notes database (Metrics Database) to gather client application statistics. The Metrics Database periodically gathers statistics of batch jobs that are run through a CONTROL-M scheduling application to reveal what happened during the processing of each job. CONTROL-M is scheduling software that runs batch jobs for applications like HR payroll, Finance, etc. and runs on a wide variety of operating systems. The Metrics database breaks down the statistics to provide a clear view on how well the batch has run. Viewing the metrics helps determine application problems to be able to reduce the amount of abends and error conditions in order to make the application run smoothly.

     There is a batch job runs a Korn shell script interpreter that contains some ISQL statements that gathers and properly formats the files that are going to be processed by the Metrics Database. This is typically done before days end. Once the files are created, Lotus Notes runs an agent in the Metrics Database that FTP's the files over to a Lotus Notes server. Once the files are on a Lotus Notes server they can then be processed by the Metrics Database. One problem addressed by this system is that CONTROL-M does not have a facility for gathering statistics or keeping track of the problems that are occurring within each server or application relating to the jobs. Below is a diagram of the system architecture.

 AIX Management Server running ECS Lotus Notes Server

Sends Production and Development files

CONTROL-M Agent

AgentL-MNTROOC(NT)

CONTROL-M Agent(NT)

(NT)

1

3

Running UNIX Scripts to get the stats from all the other Data

Centers

Reads Contents of the FTP File Splits all the information into fields Creates totals for (Amount OK, Amount Abended, % Abended, etc...) Creates daily, weekly and monthly reports.

Lotus Notes Pump

     Section one represents the server having ECS (Enterprise Control Station) program installed. ECS is used to schedule and view batch jobs provided from CONTROL-M servers. Periodically each CONTROL-M server shown in Section two downloads a file that contains what jobs will run in the next

1

2

                                     CONTROL-M CONTROL-MData Center (Unix) CONTROL-MData Center (Unix)

Data Center (Unix)

CONTROL-M Statistics Database

[This page contains 6 pictures or other non-text objects]

Page 2 of 2

time period, e.g. the next 24 hours. Just before this procedure is initiated, a script that contains ISQL statements is run to gather the job number, the job name, the node ID, the application and group name, the error number and error message.

     Each CONTROL-M server runs jobs on it's associated NT agent by sending requests to it using the Node ID field. All the job information for the jobs on the NT agents are held within a database on the CONTROL-M server. On the server where ECS is installed, an interface file holds the names and the SQL ports used for all the servers that have CONTROL-M installed. The script pr...