IBM Data Management Community Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems. Join / Log in
Another item you may want to check: is your linked server configured with "Enable Promotion of Distributed Transaction" = true? This can cause locks to be held on the remote server when you're only reading it. You may want to try turning it off and see if that helps.
i am now using IBM data studio for query execution plan/query tuning , if you have used it for query execution plan you can guide me i was getting some errors if you can help.