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

13 Jan, 2018 06:26 AM
12 Jan, 2018 02:45 PM
12 Jan, 2018 04:48 AM
30 Dec, 2017 05:39 AM
15 Dec, 2017 12:58 PM

 

30 Nov, 2017 08:34 PM
20 Nov, 2017 09:02 AM
10 Oct, 2017 10:57 AM
09 Oct, 2017 05:47 PM
27 Sep, 2017 02:31 PM
26 Sep, 2017 07:20 AM