IBM Mainframe Forum

Hi,

I am developing a DB2 program which will connect to the remote interface tables and will try to get the data from those tables. Required access has been provided but the program is having performance issues, for 3500 records the program is taking 5 hours of time for completion.

Is there any other best approach we can follow in this scenario like mentioned below

1. Create a staging table and load it with required primary key information and let the other interface team load all required information into those tables
2, Request the other interface team to provide the required information in the form of a file

It is a data volume issue so I am not sure other interface teams will be able to handle the large volume of data

Thanks
Rajkumar

Try moving the input records/key field to a temporary table and do a join, will improve the performance.

Thanks
Magesh