DB2“触发器”关于更新，插入和删除之外的操作 [英] DB2 "Triggers" on actions beyond update, insert and delete
问题描述
在研究触发器之后，我只想出了展示如何更新，插入和删除的内容。似乎这甚至是语法本身的一部分。 触发器上的DB2文档
After researching triggers, I've only come up with thing showing how to update, insert and delete. It seems like that's even part of the syntax itself. DB2 Docs on Triggers
是否有任何触发器或类似的触发器，它可以让我跟踪更多的操作，例如 SELECT 和 ALTER TABLE ？
Is there any kind of trigger, or something similar, which would let me track a larger set of actions, things like SELECT and ALTER TABLE?
我们（不幸的是）与一些我们并不完全相信不做某事的团队共享一个数据库例如在我们不知情的情况下运行疯狂的 SELECT 语句（锁定数据库）或 ALTER TABLE 。我们希望能够跟踪这些情况何时发生以及用户进行了哪些更改。
We (unfortunately) share a database with some teams which we don't strictly trust to not do things like run insane SELECT statements (locking up the databases) or ALTER TABLE without us knowing. We'd like to be able to track when these happen and what user made the change.
请不要提出任何建议我们以某种方式将数据库分开。长期来看，我们正在努力实现这一目标，但短期内需要。
Please, no suggestions recommending we get our database separated in some way. We're working towards that in the long term, but we need this in the short term.
推荐答案
DB2文档的链接在您的帖子中给出指向IBM i的信息。您的数据库DB2是否适用于i？
The link for DB2 docs given in your post points to IBM i. Is your database DB2 for i?
对于IBM i，您可以使用详细的数据库监视器来捕获所有SQL语句，包括DDL命令（如alter table）。但是，为所有用户运行详细的数据库监视器会导致性能问题。
我们处于与您相同的情况，您有多个团队使用相同的服务器作为数据库。我们最终编写了自定义用户出口，以捕获本例中的所有SQL（带有用户详细信息）。
For IBM i, you can use detailed database monitor to capture all SQL statements including DDL commands like alter table. However, running detailed database monitor for all users causes performance problems. We were in same situation as you with multiple teams using same server as database. We ended up writing custom user exits to capture all SQLs (with user details) in our case.
链接到数据库监视器：
https://www.ibm.com/support/knowledgecenter/zh-CN/ssw_ibm_i_72/rzajq/ strdbmon.htm
Link to database monitor: https://www.ibm.com/support/knowledgecenter/en/ssw_ibm_i_72/rzajq/strdbmon.htm
这篇关于DB2“触发器”关于更新，插入和删除之外的操作的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
