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

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

0
Avatar
Permanently deleted user

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

请先登录再写评论。