Try:
SELECT MAX(ROW CHANGE TIMESTAMP FOR EMP ) FROM EMP;
2022-04-22-07.54.12.648485
DSNE610I NUMBER OF ROWS DISPLAYED IS 1
DSNE616I STATEMENT EXECUTION WAS SUCCESSFUL, SQLCODE IS 100
-- FOR TABLES WITHOUT A ROW CHANGE TIMESTAMP COLUMN,
-- THE "ROW CHANGE TIMESTAMP" EXPRESSION RETURNS A TIMESTAMP
-- VALUE THAT REFLECTS CHANGES MADE TO THE PAGE INSTEAD OF TO THE ROW.
------------------------------
John Totzke
------------------------------
Original Message:
Sent: Mon October 17, 2022 01:20 PM
From: radhakrishnan thangamuthu
Subject: Finding last updated time of a DB2 table
I m looking for mechanisms
- to find the time at which a table got updated by insert/delete/statement statements.
- 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.
Thanks in advance for any help.
..Radhakrishnan
------------------------------
radhakrishnan thangamuthu
------------------------------
#Db2forz/OS