Browse Prior Art Database

The function to dump the history of databases access in case of program failure without impact to the on-line system's performance

IP.com Disclosure Number: IPCOM000033101D
Original Publication Date: 2004-Nov-25
Included in the Prior Art Database: 2004-Nov-25
Document File: 2 page(s) / 17K

Publishing Venue

IBM

Abstract

Disclosed is a function that obtains histories of database access in case of program failure. This function has no impact on the performance of an on-line transaction system. It means that this function is available in production system as a method for finding the cause of program failure briefly.

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

Page 1 of 2

The function to dump the history of databases access in case of program failure The function to dump the history of databases access in case of program failureThe function to dump the history of databases access in case of program failure The function to dump the history of databases access in case of program failure without impact to the on without impact to the onwithout impact to the on without impact to the on -

---line system's performanceline system's performanceline system's performance line system's performance

Overview of the function

Overview of the functionOverview of the function
Overview of the function :

:::

This function preserves histories of database access, e.g the I/O areas and the parameters for segment search, into storage buffer during the on-line transaction processing. If a program failure occurs during on-line services, this function performs an output operation of the preserved histories with formatting so as to enable a user to find the cause of the program failure easily.

Many preexisting functions to obtain such a history had a lot of impacts on the performance of the on-line transaction system. So, those functions are rarely available in a production system and it takes too much time to find the cause of program failure. On the contrary, if a function can obtain such a history without a huge impact on the system and easily, the user can use the function and find the cause of program failure quickly.

The function of the invention is available in the production system because the algorithm for preserving the history has high performance.

The work flow of the function

The work flow of the functionThe work flow of the function
The work flow of the function :

:::

A user specifies the size of the buffer to preserve the histories of database access by

an on-line program (by an IMS dependent region).

This function preserves the histories (e.g the I/O areas and the parameters for

segment search) in the buffer if the on-line program performs the database access.

If the buffer is full, this function overwrites the oldest history to preserve the latest


3.

history by, so called, 'wrap-around method'.

If the program failure occurs during the on-line services, this function performs the


1.


2.


4.

output operation of the preserved histories from the buffer to SPOOL in the MVS ESTAE routine (program recovery routine). The output is formatted so that the user can easily find out the cause of program failure from the database access.

The concept and the feature of the buffer to preserve the histories The concept and the feature of the buffer to preserve the historiesThe co...