# Explain Plan - Create Explain Tables

**URL:** <https://forums.toadworld.com/t/explain-plan-create-explain-tables/7741>\
**Category:** Toad for IBM DB2\
**Created:** [May 6, 2010, 12:43pm UTC](https://forums.toadworld.com/t/explain-plan-create-explain-tables/7741 "2010-05-06T12:43:05Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![PraveenKumar](https://avatars.discourse-cdn.com/v4/letter/p/ccd318/32.png) [@PraveenKumar](https://forums.toadworld.com/u/PraveenKumar)\
**Post date:** [May 6, 2010, 12:43pm UTC](https://forums.toadworld.com/t/explain-plan-create-explain-tables/7741/1 "2010-05-06T12:43:05Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![adam.ririe\_906](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/adam.ririe_906/32/125_2.png) [@adam.ririe\_906](https://forums.toadworld.com/u/adam.ririe_906)\
**Post date:** [May 7, 2010, 3:01pm UTC](https://forums.toadworld.com/t/explain-plan-create-explain-tables/7741/2 "2010-05-07T15:01:08Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![PraveenKumar](https://avatars.discourse-cdn.com/v4/letter/p/ccd318/32.png) [@PraveenKumar](https://forums.toadworld.com/u/PraveenKumar)\
**Post date:** [May 14, 2010, 11:26pm UTC](https://forums.toadworld.com/t/explain-plan-create-explain-tables/7741/3 "2010-05-14T23:26:01Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![adam.ririe\_906](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/adam.ririe_906/32/125_2.png) [@adam.ririe\_906](https://forums.toadworld.com/u/adam.ririe_906)\
**Post date:** [May 18, 2010, 8:49am UTC](https://forums.toadworld.com/t/explain-plan-create-explain-tables/7741/4 "2010-05-18T08:49:55Z")

</div>

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

Adam