您是否启用了日志功能并捕获了映像前后的信息？如果是，您可以从日志中获取与数据更改相关的所有信息。

我认为触发器最适合您。请注意，系统将需要投入资源来跟踪这些，所以请让您的系统操作员知道！。
我会这么做：
1.创建要跟踪其更改的文件的副本：

CREATE TABLE LIB.TABLEHST AS (SELECT * FROM LIB.TABLE) WITH NO DATA;

1.为操作和日期时间添加列：

ALTER TABLE LIB.TABLEHST
ADD COLUMN OPERATION CHAR(10),
ADD COLUMN DATEMODIFIED TIMESTAMP DEFAULT '1970-01-01 00:00:00';

1.创建触发器以跟踪插入：

CREATE TRIGGER LIB.TABLEINS
AFTER INSERT ON LIB.TABLE
REFERENCING NEW AS M
FOR EACH ROW
BEGIN ATOMIC
INSERT INTO LIB.TABLEHST (COLUMN1, COLUMN2, OPERATION, DATEMODIFIED)
VALUES (COLUMN1, COLUMN2, 'INSERT', CURRENT TIMESTAMP);
END;

1.创建触发器以跟踪更新：

CREATE TRIGGER LIB.TABLEUPD
AFTER UPDATE ON LIB.TABLE
REFERENCING NEW AS M
FOR EACH ROW
BEGIN ATOMIC
INSERT INTO LIB.TABLEHST (COLUMN1, COLUMN2, OPERATION, DATEMODIFIED)
VALUES (COLUMN1, COLUMN2, 'UPDATE', CURRENT TIMESTAMP);
END;

1.创建触发器以跟踪删除：

CREATE TRIGGER LIB.TABLEDEL
AFTER DELETE ON LIB.TABLE
REFERENCING NEW AS M
FOR EACH ROW
BEGIN ATOMIC
INSERT INTO LIB.TABLEHST (COLUMN1, COLUMN2, OPERATION, DATEMODIFIED)
VALUES (COLUMN1, COLUMN2, 'DELETE', CURRENT TIMESTAMP);
END;

1.编辑：通过插入、更新和删除来测试并确保一切都正常工作！
如果有帮助，请告诉我！

删除的触发器需要引用OLD而不是NEW。

CREATE TRIGGER LIB.TABLEDEL
AFTER DELETE ON LIB.TABLE
REFERENCING**OLD**AS M
FOR EACH ROW
BEGIN ATOMIC
INSERT INTO LIB.TABLEHST (COLUMN1, COLUMN2, OPERATION, DATEMODIFIED)
VALUES (COLUMN1, COLUMN2, 'DELETE', CURRENT TIMESTAMP);
END;