International Business Machines Corporation

Trung Q Nguyen

Alan Ray Smith

Dario D'Angelo

Mary Anne Morgan

Thomas J Sullivan

Thomas Richard Sullivan

A user command communicating at least one log record search key is received from a user. A first set of one or more log records matching the log record search key is retrieved. Utilizing one or more fields from these log records, additional search criteria is dynamically composed. A second set of one or more log records matching the additional search criteria is retrieved from the DBMS log file wherein this second set of log records is logically related to the first set of log records and wherein the second set of log records is void of the log record search key. A log retrieval routine or tool deploying the above method is hereinafter referred to as a 'self-learning log retrieval tool'.

Task oriented log retrieval utilizing a self-learning search tool

A log list comprising log identifiers is received, wherein the log list delineates a set of logs to be groomed. A log sequence number and a time-stamp are extracted from the first log record of each log in the set of logs. A system ID is extracted from a log record of each log in the set of logs. An appended log list is created wherein the system ID, time-stamp and log sequence number comprise appended information that is logically appended to each of respective ones of the log identifiers. The appended log list is sorted utilizing at least a portion of the appended information, the result comprising a sorted appended log list. An actual log sequence number is extracted from the last log record of each log in the set of logs. Each of the actual log sequence numbers is compared to a corresponding predicted log sequence number, wherein the corresponding predicted log sequence number is computed utilizing the sorted appended log list. A report is generated wherein range information reflecting all discrepancies between the actual log sequence numbers and the corresponding predicted log sequence numbers are disclosed.

Growing community of inventors

San Jose, CA, United States of America

Trung Q Nguyen