I am using v5.5 and running against DB2 for z/os. When I open a connection and set my default schema/user ID to another ID, how come that does not get used when trying to run an explain plan. I then get access plan tables are incomplete. I have seen many threads on this topic indicating that aliaes are needed for be created. After creating the the aliases, the explain works. Is this truly the only solution For other tools, we just tell people to use a common user ID so we don’t have to potentially create hundreds of aliases. Also, what is the purpose of changing your ID upon connection only to have it not be used?