Run Directly from the Console

To run the utility directly from the console:

1. Navigate to the $FIC_DB_HOME/bin directory of the OFSAAI FIC DB tier.
2. Execute RefreshPartitions.sh with the required parameters:

   ./RefreshPartitions.sh dsn=<INFODOM> usr=<USERNAME>

   code=<DERIVED_ENTITY_CODE> addp=<PARTITIONS_TO_ADD/REFRESH>

   delp=<PARTITIONS_TO_DELETE> filter=<RUN FILTER>

   • dsn - Information Domain name
   • usr - User Name of the logged in user
   • code - Derived Entity Code for which you want to refresh, add or delete partitions
   • addp - Specify the Partitions which needs to be added or refreshed, separated by ^
   • delp - Specify the Partitions which needs to be deleted, separated by ^

   For example:

   ./RefreshPartitions.sh dsn=OFSAAAIINFO usr=AAAIUSER code=DE0001 addp=3^4 delp=1^2 filter="DIM_STANDARD_ACCT_HEAD.V_STID IN ('CAP622','CAP628)"