Joining to DB2 on Mainframes

k_vk2000 · Post by **k_vk2000** » Thu Nov 12, 2009 12:24 pm

Hi All,

I have a source which is in Oracle DB and will have 1000 records which needs to Join with DB2 which is on Mainframes. The amount of Data Present in the DB2 Table are 8 billions.There is no search criteria provided so that we can fetch only subsetpart.

The Jobs are taking lot of time as fetching of Huge Data and then Joining.

We are using DB2 API . There is no possiblity of using the Sparse look up also as we cannot use in Mainframes.

Can any one help us how to fine tuned these Jobs.

Thanks a lot.

Regards
Vijay

ray.wurlod · Post by **ray.wurlod** » Thu Nov 12, 2009 1:24 pm

If "they" have given you no means to select a subset, then you are limited to processing all eight billion rows. That's just how it is. Read (select) only the columns that you actually need in the job design.