DB2 Performance Issue

noman212 — Fri, 14 Nov 2014 07:50:19 GMT

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.

Re: DB2 Performance Issue

ashfaq_haseeb — Fri, 14 Nov 2014 08:22:23 GMT

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