If you want to check if a relational connection is still used in any session instance you can use the following query on the repository: SELECT M.MAPPING_NAME ,SI.INSTANCE_NAME INSTANCE_NAME ,SA.ATTR_VALUE TABLE_OWNER ,MSE.OBJECT_NAME READER_WRITER_TYPE ,C.OBJECT_NAME CONNECTION_NAME ,C.USER_NAME ,WA.ATTR_VALUE SQL_OVERRIDE FROM DWHREP.OPB_SWIDGET_INST SI ,DWHREP.OPB_SWIDGET_ATTR SA ,DWHREP.OPB_MAPPING M ,DWHREP.OPB_WIDGET_INST WI ,DWHREP.OPB_WIDGET_ATTR WA ,DWHREP.OPB_SESS_EXTNS SE ,DWHREP.OPB_MMD_SESS_EXTNS MSE ,DWHREP.OPB_SESS_CNX_REFS SCR …
