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

 

27 Aug, 2018 06:50 PM
19 Aug, 2018 04:13 PM
19 Aug, 2018 04:04 PM
17 Aug, 2018 03:46 PM
12 Aug, 2018 06:10 PM
18 Jul, 2018 03:01 AM