Hi,
We are using DDF thread in our shop.
We are Db2 Ver 7 and have UDB 6.1
From Websphere the request comes via UDB to DB2.
In our new requirement, we have now huge amount of data to be retrived. When we did a flood test, we found that in Omegamon that threads were going on fine for first few minutes and after some time the number of GETPAGES were slowly reduced for active threads and then the threads hangs in DB2 for good with the status of WAIT-REMREQ.
Have anyone faced this problem before and if so how to resolve the problem?