How to see, if a foreign key is enforced? How can I see in IBM DB2, if a foreign key is in enforced Status?
In the systemviews REF_CONSTRAINTS and REFERENTIAL_CONSTRAINTS I see them, but I cannot see, if they are in enforced Status. Is there another System view, where I can see that?
Not sure what version of db2 you are using, but if it's LUW you can use SYSCAT.TABCONST (see column ENFORCED):

select enforced 
from syscat.tabconst 
where tabschema = ?
  and tabname = ?
  and constname = ?


FWIW, it is better to use the syscat views (vs sysibm), since they are more stable between versions.