Hi,

Are there indexes defined on both tables?
Have you tried issuing RUNSTATS to help update the database statistics thus allowing the DB2 optimizer to make better decisions?

Thanks,
Raj