Hi!
There are some timestamps in the RTS that could help you but not that much really.
Checksum is not available anywhere. You must code that yourself and is obviously very very cpu intensive...
------------------------------
Roy Boxwell
------------------------------
Original Message:
Sent: Tue October 18, 2022 12:12 PM
From: radhakrishnan thangamuthu
Subject: Finding last updated time and checksum of a DB2 table
I m looking for mechanisms
1) to find the last updated time at which a table got updated by insert/delete/statement statements.
2) to compute the checksum of the table - This is required to detect duplicates in data across tables.
If you know of any mechanism without server side configuration preferably or with server side configuration, please let me know.
Please note that I may not be able to add a row change timestamp column in the table since the table belongs to the end users.
------------------------------
radhakrishnan thangamuthu
------------------------------
#Db2