Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2004

    Question Unanswered: Query modified datetime of tables and columns

    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 ?


  2. #2
    Join Date
    Nov 2005
    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.
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows

    DB2 v9.7.0.6 os

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts