Problem in Insert queries on table having triggers on it , Using ESQL.
I have 2 tables(Master and Child) which have primary and foreign key relationship. A trigger is applied on the Master table which inserts data into some Back up table. Also before the delete is performed on the Master and Child table the foreighn key constraint is removed and then a delete is performed for both the tables and then a commit is done.This delete is performed as the first step to clear the dB.All these thinmgs are done in ESQL code in Message Broker tool kit. When I am passing small input to the Message Broker Flow which insert 100-200 rows in the table the complete operation is done in 1 min. But when I pass a bulk input which inserts some 80,00 rows it takes 2 hours. When the triggers is removed from the Master table same bulk input when it is passed it inserts 80,000 records in 5 mins. What can be the problem and how can I rectify it. Thanks,
How to access tomy db2 database Version 7.1 under windows
DB2 - enable and disable constraints
Restoring a database
Convert Date to Varchar
how to copy dbm cfg parameters?
How can we convert SMS tablespace to DMS Tablespace (Automatic Storage)
Timestamp column and null indicators
Looking for DB2 UDB 7.1 Trial Version
Weird Problem while retrieving data via php
Migrate DB2 8.1 Tables to DB2 9.5 with partitioning
Federated Stored Procedure - parameters
Federation Server to Oracle 10g - Sequences
ADM1832E error got ????