Explain Plan - Create Explain Tables

Toad for IBM DB2
1

Hi,
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.

Praveen.

2

Hi Praveen,

You can use plan tables that are not the same schema as your authid by creating aliases for the plan tables you want to use.

Regards,
Adam

3

Thanks for the response.
I have one more question though. I do not have an schema with the same name as my userid.
Like if my id is praveen, the default schema is not praveen, all developers use a shared schema, like, shareddev.
Toad looks for a plan table in my schema.

Thanks again.

4

You’ll need to have somenoe with the required authority create the aliases.

Adam