I’m using Toad for DB2 z/OS 5.3. I’m a total noob to the DB2 & mainframe world but have background in Oracle, Access, etc.
Problem: When I try to use Explain Plan, I get the dialog “The Access Plan tables need to be installed …”
Background: The access plan tables exist but it appears Toad is using my authid as the owner when in fact I am not the owner. This thread (http://www.toadworld.com/products/toad-for-ibm-db2/f/18/t/7670.aspx) suggests that an alias be created for this situation, but that seems like a hammer on a thumbtack. I think something is wrong in my Toad setup, but for the life if me I can’t find out what it is. Have tried online help, Toad World, the web, and good old-fashioned hacking.
Any assistance would be most appreciated.