Method and system for storing trace events in a database table

• US 8,413,121 B2
• Filed: 07/17/2006
• Issued: 04/02/2013
• Est. Priority Date: 07/17/2006
• Status: Active Grant

• Current Assignee: CA, Inc. (d/b/a CA Technologies) (Broadcom, Inc.)
• Original Assignee: CA, Inc. (d/b/a CA Technologies) (Broadcom, Inc.)
• Inventors: Hinkley, Paul A., Morrison, Charles
• Primary Examiner(s): Khatri, Anil
• Application Number:
  US11/457,926
• Publication Number:
  US 20080016500A1
• Time in Patent Office: 2,451 Days
• Field of Search: 717124-132, 717140-144, 714/38, 707/E17.058
• US Class Current: 717/128
• CPC Class Codes: G06F 11/3476 Data logging G06F11/14, G06F11/2205 take precedence
• CPC Class Codes: G06F 2201/86 Event-based monitoring

Abstract

According to one embodiment, a method for storing trace events in a database table includes reading a group of parameters from the table. The group of parameters includes parameters indicative of the maximum number of records, the most recently added record, and the total number of records in the table. The method further includes receiving a trace event. The method also includes storing the trace event as a record in the table based on the group of parameters. The method further includes updating the group of parameters before receiving the next trace event.

Claims

1. A method for storing trace events in a database table, comprising:

initiating a tracing session;

reading a plurality of parameters from the table, the plurality of parameters comprising a parameter indicative of the maximum number of records, a parameter indicative of the most recently added record, and a parameter indicative of the total number of records;

receiving a first trace event, the first trace event comprising a first condition prior to an error condition;

generating a record number based on the plurality of parameters;

storing the first trace event as a record in the table at the record number based on the plurality of parameters, wherein storing the first trace event as a record comprises adding the record to the table at the record number;

updating the plurality of parameters before receiving a second trace event; and

receiving the second trace event, the second trace event comprising the error condition;

after receiving the second trace event, continuing the tracing session;

displaying a plurality of records corresponding to a selected type of trace information and a selected time range.

2. A method for storing trace events in a database table, comprising:

initiating a tracing session;

reading a plurality of parameters from a database table stored in a storage device the plurality of parameters comprising a parameter indicative of the maximum number of records in the table, a parameter indicative of the most recently added record in the table, and a parameter indicative of the total number of records in the table;

receiving a first trace event, the first trace event comprising a first condition prior to an error condition;

storing the first trace event as a record in the table based on the plurality of parameters, wherein storing the first trace event as a record comprises;

generating a record number based on the parameter indicative of the most recently added record in the table; and

adding the record to the table at the record number;

updating the plurality of parameters using a processor before receiving a second trace event;

receiving the second trace event, the second trace event comprising the error condition; and

after receiving the second trace event, continuing the tracing session.

3. The method of claim 2, wherein storing the first trace event as a record further comprises:

generating a record number based on the parameter indicative of the maximum number of records in the table and the parameter indicative of the most recently added record in the table; and

replacing an existing record with the record at the record number.

4. The method of claim 2, further comprising resizing the table by updating the parameter indicative of the maximum number of records in the table.

5. The method of claim 2, further comprising displaying a plurality of records corresponding to a selected type of trace information and a selected time range.

6. The method of claim 2, further comprising clearing the table by updating the parameter indicative of the maximum number of records in the table.

7. The method of claim 2, wherein the database table comprises a relational database table with standardized I/O routines.

8. A computer system, comprising:

a processor; and

a storage device readable by the computer system, embodying a program of instructions executable by the processor to perform method steps for storing trace events in a database table, the method steps comprising;

initiating a tracing session;

reading a plurality of parameters from the table, the plurality of parameters comprising a parameter indicative of the maximum number of records in the table, a parameter indicative of the most recently added record in the table, and a parameter indicative of the total number of records in the table;

receiving a first trace event, the first trace event comprising a first condition prior to an error condition;

storing the first trace event as a record in the table based on the plurality of parameters, wherein storing the first trace event as a record comprises;

generating a record number based on the parameter indicative of the most recently added record in the table; and

adding the record to the table at the record number;

updating the plurality of parameters before receiving a second trace event;

receiving the second trace event, the second trace event comprising the error condition; and

after receiving the second trace event, continuing the tracing session.

9. The computer system of claim 8, wherein the step of storing the first trace event as a record in the table further comprises:

generating a record number based on the parameter indicative of the maximum number of records in the table and the parameter indicative of the most recently added record in the table; and

replacing an existing record with the record at the record number.

10. The computer system of claim 8, wherein the method steps further comprise resizing the table by updating the parameter indicative of the maximum number of records in the table.

11. The computer system of claim 8, wherein the method steps further comprise displaying a plurality of records corresponding to a selected type of trace information and a selected time range.

12. The computer system of claim 8, wherein the method steps further comprise clearing the table by updating the parameter indicative of the maximum number of records in the table.

13. A non-transitory computer readable medium comprising logic, the logic, when executed by a processor, operable to:

initiate a tracing session;

read a plurality of parameters from a table, the plurality of parameters comprising a parameter indicative of the maximum number of records in the table, a parameter indicative of the most recently added record in the table, and a parameter indicative of the total number of records in the table;

receive a first trace event, the first trace event comprising a first condition prior to an error condition;

store the first trace event as a record in the table based on the plurality of parameters, wherein storing the first trace event as a record comprises;

generating a record number based on the parameter indicative of the most recently added record in the table; and

adding the record to the table at the record number;

update the plurality of parameters before receiving a second trace event;

receive the second trace event, the second trace event comprising the error condition; and

after receiving the second trace event, continue the tracing session.

14. The computer readable medium of claim 13, wherein the operable to store the first trace event as a record in the table is further the logic operable to:

generate a record number based on the parameter indicative of the maximum number of records in the table and the parameter indicative of the most recently added record in the table; and

replace an existing record with the record at the record number.

15. The computer readable medium of claim 13, the logic further operable to resize the table by updating the parameter indicative of the maximum number of records in the table.

16. The computer readable medium of claim 13, the logic further operable to display a plurality of records corresponding to a selected type of trace information and a selected time range.

17. The logic computer readable medium of claim 13, the logic further operable to clear the table by updating the parameter indicative of the maximum number of records in the table.