QUERYREWRITERULES 
The system table <DATABASE_SYSTEM_ADMINISTRATOR>.QUERYREWRITERULES contains the description about possible and activated rules for the query rewrite.
Structure
RULENAME |
CHAR(32) |
Name of the rule |
ACTIVE |
CHAR(3) |
Rule can be applied (YES | NO) |
CONNECT |
CLOB |
Comment on the rule |