Change schema for explain_plan tables - DB2 关注 Matej Ugrin 创建于 2016年07月20日 08:30 Hi, I am wondering if is possible to change the default systools schema to a different one? Thank you.
Is there any other way around how to list explain plans?
I'm running into the same thing. My organization puts the explain plans under a user-specific schema (i.e. if my user ID is johndoe, then there will be a schema named johndoe having EXPLAIN_OBJECT, EXPLAIN_OPERATOR, etc. underneath) so the SYSTOOLS namespace generates an error.
I have the same problem. Is there a solution yet as this exists since years?
has anyone figured out how to solve this?
I am having a similar experience and have therefore logged this issue: https://youtrack.jetbrains.com/issue/DBE-7982
With the help of the DBA we have found a work around for the issue regarding the SYSTOOLS schema as explained in this ticket: