Change schema for explain_plan tables - DB2

Hi,

I am wondering if is possible to change the default systools schema to a different one?

Thank you.

6 comments
Comment actions Permalink

Is there any other way around how to list explain plans?

2
Comment actions Permalink

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.

2
Comment actions Permalink

I have the same problem. Is there a solution yet as this exists since years?

1
Comment actions Permalink

has anyone figured out how to solve this?

0
Comment actions Permalink

I am having a similar experience and have therefore logged this issue: https://youtrack.jetbrains.com/issue/DBE-7982

0
Comment actions Permalink

With the help of the DBA we have found a work around for the issue regarding the SYSTOOLS schema as explained in this ticket:

https://youtrack.jetbrains.com/issue/DBE-7982

0

Please sign in to leave a comment.