Debug inconsistent run times for SQL requests from FileMaker clients

Hello,

I hope someone can point me in the right direction to help us debug some SQL run-time inconsistencies.

We have some SQL queries, that access the IBM i DB2 database, that have wildly different run-times depending on the client.  We can run the queries from the Surveyor product and it runs consistently time-wise each time.  This is true if we run the queries in the IBM ACS SQL client.  If we run that same query from within a product called FileMaker the run-times will be wildly inconsistent and usually much much much longer.  Although, there are times when it matches the Surveyor run-times.

The FileMaker product is connecting to the IBM i via the ODBC driver from IBM ACS.

We have just started developing these queries so it isn't a case of "it was working fine and now it isn't".

Where should I start looking to figure this out? What are the most likely culprits?

Any help will be appreciated.

Thanks and regards,
Bobby