The World of DB2
IBM Db2 - The Ultimate Database for Cloud, Analytics & Mobile
Change tracking on DB2 version 11.0 on Z/os
Hi All,
I am from the solution team, we have a requirement to track the changes(UPDATE & INSERT) in a particular column from different tables.
Can this be achieved on DB2 Z/os ?? If yes, please advise.
I have been exploring triggers on DB2 but these have some limitations for BEFORE update or INSERT operation done on tables. I need to hold both the new and old values on to my change tracking table so that it will easy to report things on what has been changed and who has changed it.
I would need some suggestions or guide me through how this can be achieved
Regards,
Rakesh MS
Bringing Db2 enthusiasts together virtually. Expert or novice, distributed or mainframe, this is the place for everything DB2.
Forum
Introducing IBM Db2 for z/OS Developer Extension for Microsoft Visual Studio Code
Started by Calene Janacek in Application Development and DB2 Jul 30. 0 Replies 0 Likes
We are excited to announce that the first iteration of IBM Db2 for z/OS Developer Extension is available now as a free downloadable extension in the…Continue
QMF Governor
Started by Maitena Gallastegi Ginea in Application Development and DB2. Last reply by Maitena Gallastegi Ginea Jul 30. 4 Replies 0 Likes
Hi,We are using QMF Governor to limit the QMF queries of users.We have configured correctly and it is working OK. We want to get statistics of those queries canceled by QMF Governor but we are not able to discover where that information is stored.…Continue
Groups
Top Discussions
Db2 NIghtShow
IBM Big Data & Analytics Hub
PlanetDB2.com [Latest Blogs from the Biggest Names in DB2]
© 2020 Created by Surekha Parekh.
Powered by
