I have something like this to insert via application into DB2 LUW,
insert into MY_TABLE (CREATION_DATE, MESSAGE, IDENTIFIER) values
(CURRENT_TIMESTAMP, '0', '1b0d7cfb-66ee-4372-913b-2283c6e3f0b5')
,(CURRENT_TIMESTAMP, '1', '1b0d7cfb-66ee-4372-913b-2283c6e3f0b6')
I have also some triggers installed which makes some consistency checks on the inserted row and which takes some time for execution.
CREATE OR REPLACE TRIGGER
BEFORE INSERT ON MY_TABLE
REFERENCING NEW AS NEW
FOR EACH ROW
--some checks takes approx. 10s
END
So how can I achieve that the triggers are executed parallel, do not like to wait for 20s.