DB2 Version 8 on Solaris.
Is there any way of importing an access plan from one system to another and forcing a query to use it ? I have continual problems of queries running well on one system but taking ages on another. When I explain the query, it is totally different between the systems (even though I've done runstats on both and the amounts of data between the systems are similar).
I'd like to find the best access plan and force all systems to use that plan.
Is there any way of importing an access plan from one system to another and forcing a query to use it ? I have continual problems of queries running well on one system but taking ages on another. When I explain the query, it is totally different between the systems (even though I've done runstats on both and the amounts of data between the systems are similar).
I'd like to find the best access plan and force all systems to use that plan.