Search for UDB tools to analyze logs

[Roberto Barraco]

Hi guys,
I have a problem with an application long runnig(24 hours) written in C
language. The logical flow of this application is :
1. Open a cursor in a table (which has an unique index)
2. fetch rows
3. move in its own memory the first 3000 occurrences
4. close the cursor
5. For each element of the array
a. insert one row into another table
b. update of a column (flag = 'Ok' ) (that is the first column of
the field) of the row

IN some circumnstances it seems that DB2 updates the row in the firts
table and doesn't insert the row in the
second one. Because we can't reproduce the problem I need to investigate
the LOGS . I am looking for a tool that can report (starting from tthe
LOGS) what happens to my application.
Anybody can help me

The scenario is :
AIX 4.2.1
UDB 5.2 fixpack 11

Many thanks
Roberto Barraco

[Blair Kenneth Adamache]

DB2 comes with db2flsn (db2 find log sequence number). This utility is
documented in the Command Reference.

You could also do the select and insert in the same unit of work, and commit
only after the insert.

[Roger Zheng]

>>>>> ">" == Roberto Barraco <r...@stserver.conecta.it> writes:

>> Hi guys,
>> I have a problem with an application long runnig(24 hours) written in C
>> language. The logical flow of this application is :
>> 1. Open a cursor in a table (which has an unique index)
>> 2. fetch rows
>> 3. move in its own memory the first 3000 occurrences
>> 4. close the cursor
>> 5. For each element of the array
>> a. insert one row into another table
>> b. update of a column (flag = 'Ok' ) (that is the first column of
>> the field) of the row

>> IN some circumnstances it seems that DB2 updates the row in the firts
>> table and doesn't insert the row in the
>> second one. Because we can't reproduce the problem I need to investigate
>> the LOGS . I am looking for a tool that can report (starting from tthe
>> LOGS) what happens to my application.
>> Anybody can help me

We don't have an offical tool to analyze the logs (db2flsn is only to
report which log file contain the log record identified by a log
sequence number).

But there is an unofficial, unsupported tool. I can email it to you.
--
Roger Zheng
DB2 Development Phone 416-448-2632 Tie Line 778-2632
IBM Toronto Lab rzh...@ca.ibm.com