Command Line Utility for Resave, Refresh and Delete Partitions

A command line utility called RefreshByPartition.sh is available to resave, refresh and delete partitions.

To run the utility directly from the console:

1. Navigate to $FIC_DB_HOME/bin of OFSAAI FIC DB tier.
2. Execute RefreshByPartition.sh with proper parameters:

   ./RefreshByPartition.sh <DSNNAME> <USERNAME> <METADATA SERVICE TYPE> [<METADATACODE>] <ADD_or_REFRESH_PARTITIONS(SEPARATED BY "^")> <DELETE_PARTITION(SEPARATED BY "^")>

   • <DSNNAME> - Information Domain name
   • <USERNAME> - User Name of the logged in user
   • <METADATA SERVICE TYPE> - 856 for Derived Entity
   • [<METADATACODE>]- Derived Entity Code for which you want to refresh, add or delete partitions
   • <ADD_or_REFRESH_PARTITIONS> - Specify the Partitions which needs to be added or refreshed, separated by ^
   • <DELETE_PARTITION> - Specify the Partitions which needs to be deleted, separated by ^

   For example:

   ./RefreshByPartition.sh TESTCHEF TESTUSER 856 DE003 1^2^3^4^5^6 2^4

   Consider 1, 2, 3, 4 are already existing. Then in this case, 1 and 3 will be refreshed, 5 and 6 will be added and 2 and 4 will be deleted.

   Note:

   • Deleting partitions happens before adding partitions.
   • Existing partitions will continue to exist if they are not mentioned in the parameter list.