How to get the last timestamp a table was altered?

advidscontact's Avatar

advidscontact

09 Feb, 2017 11:21 AM

Hello,
Db2 8.2.6 on windows
Would like to know how to get the last timestamp a table was altered. I can get get the create_time of table from syscat.tables, but I cannot see anything there as to when a table was altered.
Thanks

For more details check http://blog.advids.co/20-awesome-2d-animated-video-examples-with-production-tips

Reply to this discussion

Internal reply

Formatting help / Preview (switch to plain text) No formatting (switch to Markdown)

Attaching KB article:

»

Attached Files

You can attach files up to 10MB

If you don't have an account yet, we need to confirm you're human and not a machine trying to post spam.

Keyboard shortcuts

Generic

? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac

Recent Discussions

21 Jun, 2019 07:14 AM
05 Apr, 2019 11:38 PM
21 Mar, 2019 03:31 AM
21 Mar, 2019 02:49 AM
20 Mar, 2019 05:41 AM

 

24 Jan, 2019 07:59 PM
09 Jan, 2019 11:10 AM
10 Dec, 2018 01:50 PM
14 Nov, 2018 09:45 PM
14 Nov, 2018 10:11 AM
06 Nov, 2018 07:08 PM