DB2 Performance Issue

[noman212]

I am using FileNet DB2 (IBM) , i have made query like this

Select Column1,Column2,Column3,Column4,Column5 from "table" where DateColumn = Trunc(sysdate) and Column1 <> Column2 and Column3 = 'ABC'.

Its return max of 20 rows per reload.

But when i set it to continous Reload on QV server it slow down DB2 performance. its create session on DB2 server.

Is there any way to minimized load on DB2 Server. 

[ashfaq_haseeb · Accepted solution]

Hi noman

Try by adding with ur;

at the end of your script while loading data from DB2.

Let me know if that worked.

Regards

ASHFAQ