Eliminating unused object type relationships

Applies to: On premises

If the business only requires a subset of the available enabled relationships, those unneeded relationships should be disabled.

About this task

When you install the IBM OpenPages® solutions, it loads dozens of object types and hundreds of parent-child relationships. Depending on your business needs, your business object model may only use a small subset of the object types and a subset of the parent-child relationships.

Disabling unused object types will prevent any accidental creations of those relationships.

With Oracle databases, one method of analyzing if there are any unused and enabled relationships is to run an SQL script. From the installation media, there are folders that contain SQL scripts. One of the SQL scripts within the folder is: Analyze-Object-Type-Relations.sql.

For IBM® Db2® information, see the IBM Db2 documentation.

Procedure

  1. Log on to SQL*Plus as the OPENPAGES oracle id.
  2. Type the following command to allow the output to occur: SET SERVEROUTPUT ON;.
  3. Type the following to spool the contents to a log: SPOOL AnalyzeRelationships.txt;.
  4. Run the script by typing @Analyze-Object-Type-Relations.sql.
  5. Run the following to stop the spooling of the log: SPOOL OFF; .
    The log file will identify any relationships that are enabled in the system but there are no instances of data utilizing those relationships.