shsandeep wrote:
> The ETL application loaded around 3000 rows in 14 seconds in a Development
> database while it took 2 hours to load in a UAT database.
>
> UAT db is partitioned.
> Dev db is not partitioned.
You should make your dev system partitioned as well. 2 logical
partitions would do.
> the application looks for existing rows in the table...if they already
> exist then it updates otherwise inserts them.
>
> The table is pretty large, around 6.5 million rows.
> Due to RI, it is looking up into parent tables which possibly reside of
> different nodes.
Show us the statements you run and the plans (db2exfmt output).
How big are the parent tables? Often parent tables are small and should
be replicated on all partitions.

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

WAIUG Conference
http://www.iiug.org/waiug/present/Fo...Forum2006.html