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.

3
6 comments
Avatar
Permanently deleted user

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

2
Avatar
Permanently deleted user

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
Avatar
Permanently deleted user

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

1

has anyone figured out how to solve this?

0

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

0

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.