Just started playing with the 400 and DB2 and am trying to find out
what could be causing some of our issues. We developed a web app on
Domino using LotusScript Agents that pulls data from multiple logical
files and we find that the optimizer spends time looking through the
entire table instead of the directed key. This happens on some tables,
but not others. Is there anyway to shut off the optimizer.
What about the order of your SELECT? In other languages this matters,
what about DB2?
In addition, we find that it takes 6 second to open each connection.
Is there any tricks other that IBM's recommendations to tune the 400 to
reduce that 6 seconds. I would imagine someone has run into this with
other Web Apps.
Sent via Deja.com http://www.deja.com/
Before you buy.