We have created a DB2 Triggers to log all the deletion action on each rows from X table.
[CREATE TRIGGER TST.GX
AFTER DELETE ON TST.X
REFERENCING OLD AS O
FOR EACH ROW MODE DB2SQL
INSERT INTO TST.XD
But when we tried to delete rows from table X thru both SPUFI (Manual) and BATCH job execution, we could see both entries "SESSION_USER" values are same as developer id.
Kindly please advise how to store an either PLAN NAME/JOB NAME value in log table to trace the deletion log done by either user or application batch?