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

Views: 39

Reply to This

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

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

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

© 2020   Created by Surekha Parekh.   Powered by

Badges  |  Report an Issue  |  Terms of Service