I am using Toad for DB2 to connect to UDB DB2 9.1 running on an AIX server. When I try to run explain plan, it is throwing an error saying, “The Access Path Tables needs to be installed”. The tables exists but they are in a schema not attached to me.
Is there a way i can configure toad to use the existing explain plan tables.
Thank you for your suggestions.