I have a job which contains the following stages.
Code: Select all
|----------->delete cust_table (Based on 4 columns)
|------------>delete prod_table (Based on 4 columns)
DB2_source---------->cpystage--------> del cust_table (Based on 4 columns)
|------------>del sales_table(Based on 4 columns
DB2_source contains the select query from a table which contains only 15000 rows.
When i try to delete data in the four tables. the job is running past 3 hours. we are unable to figure the issue beacuse very less number of records.
Based on fourms we have added index on the tables. but still there is no improvement.
I dont know the nature of DB2_UDB_API stage take some steps to delete data in the tables.
Any help greatly appriciated.
Thanks -Suresh