DB2 Parallel Insert

61 Views Asked by At

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.

0

There are 0 best solutions below