DB2

DB2 is IBM's offering to the highend database market. The latest version of DB2 (Universal Database) is ideal for OLTP, Data Warehousing, Decision Support and everything in between. It's well priced, extremely scalable and runs on virtually every platform out there from handhelds to mainframes.

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,

Related Links

Current time and timestamp
To define the table in DB2 cache or memory
questions about answer
Get information about a table
Is creating indexes on date cols fo MAX /MIN aggregate functions good?
Sql prepare and the optimizer
Is there any command in UDB/Linux to List all mount points for a given instance?
sql stored procedure default parameter
Z/os Db2 Unload Utility Question
getting current time in SQL
Get diagnostics exception - error line
I need to force application one bye one as script in Solaries
S04E for COBOL/DB2 stored procedure
Is Reorg needed after table LOAD?
AUTORESIZE in DB2 V8.2
question about IDENTITY

Categories

DataBase Dev
MongoDB
Adabas
DB2
Informix
Microsoft SQL Server
MySQL
Oracle
Pervasive.SQL
PostgreSQL
Sybase
Other
ASP
Crystal Reports
Delphi, C etc
JAVA
Perl and the DBI
PHP
ANSI SQL
Unix Shell Scripts
Visual Basic
Brilliant Database
Corel Paradox
FileMaker
Microsoft Access
Microsoft Excel
Other PC Databases
New Members & Introduc...
Applications & Tools
Database Concepts & De...
Chit Chat
Marketplace
Job Opportunities
Suggestions & Feedback

Resources

Mobile Apps Dev
Database Users
javascript
java
csharp
php
android
MS Developer
developer works
python
ios
c
html
jquery
RDBMS discuss
Cloud Virtualization
Database Dev&Adm
javascript
java
csharp
php
python
android
jquery
ruby
ios
html
Mobile App
Mobile App
Mobile App