Clean and Drop Scripts

Clean scripts and drop scripts are used during an upgrade to clear the database from obsolete objects.

Clean Scripts

Clean scripts remove objects that have become invalid in an active component. They must be manually executed at the end of an upgrade.

Drop Scripts

Drop scripts remove all the database objects for a component that have become obsolete. A drop script maybe executed in different stages/times based on one of the following scenarios:

• A component is obsolete in the new track
  • In this case the drop script of the obsolete component (that is stored in the PRODIFSApplications component of the new track) has to be executed as a 'post' step after the database upgrade is complete.
• The customer wants to remove a component that they do not need anymore
  • If the component should be removed during an upgrade the drop script of the relevant component to be removed has to be executed as a 'pre' step before the database upgrade takes place
  • During all other times the drop script can be executed as required.
    

Note: Since both scripts drop obsolete tables, it is recommended to verify the scripts to avoid unwanted loss of data that the customer wants to keep even though the tables are not used inside IFS Applications anymore. Furthermore all the background jobs need to be stopped before executing these scripts.