DB2 program connecting to Remote interface tables



IBM's flagship relational database management system

DB2 program connecting to Remote interface tables

Postby meetraju2002 » Wed Apr 11, 2018 6:10 pm

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
meetraju2002
 
Posts: 4
Joined: Tue Sep 20, 2016 12:17 pm
Has thanked: 0 time
Been thanked: 0 time

Re: DB2 program connecting to Remote interface tables

 

Re: DB2 program connecting to Remote interface tables

Postby Magesh23586 » Wed Apr 18, 2018 1:34 am

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

Thanks
Magesh
Magesh23586
 
Posts: 36
Joined: Sat Jul 05, 2014 5:36 pm
Has thanked: 1 time
Been thanked: 3 times


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post