We have a Log Analyzer Tool running on our DB2 OLTP hosted on the z/OS - the tool captures the date/time of change to every record in every table the tool is configured to monitor.

HOWEVER!!!! the field that captures the timestamp of the change is CHAR(08) is HH:MMS - clearly a lot of times, this is not enough precision to be able to distinguish between successive changes made to the same record in a table.

Question - is there a way of bumping up the LAT TIME precision to include microseconds????

No response?????

Have you asked your tool vendor? You do not even tell us what log analysis tool you are using.

Dave Nance

A RFI (request for Information) is in queue ... as I dont have a very good experience with the turnaround from IBM on RFIs, I thought I'd check with gurus in the forum

Also, I did mention the name of the product (perhaps not articulate enough - so my apologies) - it is called IBM DB2 Log Analysis Tool.

Please share any insights you might have - THANKS AS ALWAYS!

- G