This is a question about Connections/Relationships and Occurrences that will or won’t be Deleted by a DB Reorganization. I want to understand the differences between those Connections CREATED on a Model or on a Matrix as they seem to be treated differently by the Reorg. Also, I would like to find out how I can find this type of situation using a report/script.
Here is what I have observed. (screen shots attached)
I create a Model (Application Communication in this case) and place 2 different Application System Type Objects on the Model and save the model. Currently if I look at the Properties/Relationships on the Objects there are none. Now I create a Connection (transmits data to) from 1 Object to the other and save the model. Now if I look at the Properties/Relationships on the Objects I see the Relationship (connection) that I just created. If I right click on the Relationship and go to Properties/Occurrences I am shown the name of the model I am working on.
If I now Delete the visual line (connection) between the 2 Objects and save the model, when I look at the Properties/Relationships on either Object I still see the relationship between the 2 Objects. However, if I then right click on the Relationship and go to Properties/Occurrences there are NONE. This NO OCCURRENCE Connection/Relationship is/would be DELETED by a DB Reorganization.
Then I create a Matrix Model and place the same 2 Application System Type Objects on opposite Axes of the Matrix. I click “Cancel” when the “Define Visibility of Connections” dialogue opens.
I then click on “Display” for the “transmits data to” connection between 2 application system type objects and the check appears at the intersection of the objects in the Matrix. I save the Matrix.
Now when I look at Properties/Occurrences of the Connection/Relationship in either the Model or the Matrix there are NO OCCURRENCES. However, this NO OCCURRENCE Connection/Relationship will not/would not be DELETED by a DB Reorganization.
This can be confusing for Modelers working on models with objects (not a matrix) when they see multiple possible Relationships/Connections between Objects and yet the DB Reorganization will NOT clean these up and they are very difficult and time consuming to track down and clean up manually. So, any explanation and details that you can provide would be greatly appreciated.