Hi,
I have a table in db2 v9.5 on Linux that multiple programs are updating values. The problem now appears that for some strange reason one of the production application on some rare situation doesn't work as it should, it updates the wrong values to the table.

I have written trigger to insert to new table every value before original table gets updated.

CREATE TRIGGER ADMIN.MYTRIGGER
AFTER UPDATE ON ADMIN.MYTABLE_ORIGINAL
REFERENCING OLD AS OLD
FOR EACH ROW
BEGIN ATOMIC
INSERT INTO ADMIN.MYTABLE_NEW VALUES (OLD.DATE, OLD.COUNTRY);
END
@

Question: Is there any way to get application name that has updated original table? Something like "Application Name" from "db2 list application" command? The idea is to get application name that corrupts data.
Regards

You can try the value of the CURRENT CLIENT_APPLNAME special register, but the application must set it first. It can be done via a CLI call or as a JDBC connection property.

Is there any other way but settings special register in applications? The problem is I don't know which applications are accessing my table.