Browse Prior Art Database

Lotus Notes Metrics Database Disclosure Number: IPCOM000015668D
Original Publication Date: 2002-Feb-04
Included in the Prior Art Database: 2003-Jun-20

Publishing Venue



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