Good day,

Is there any way I can query for the modified datetime for a table or a column ? I need to query for a list of changes made to columns and tables from a date onward.

I can't locate any modified date in SYSCAT.TABLES and SYSCAT.COLUMNS.

Is there any other syscat tables that I miss out ?

Thanks.

I do not think there is such a timestamp which is probably not much help to you. Just an FYI. We battle this by running a daily db2look script that pulls ddl as well as grants and we store it for 365 days rolling. We did have to use it a few time for varius reasons mostly to prove that users never had access.