Run from the Operations Module

To run the utility from the Operations module (ICC):

  1. Navigate to the Operations module and define a batch
  2. Add a task by selecting the component as RUN EXECUTABLE
  3. Under the Dynamic Parameter List panel, enter the following in the Executable field:
    ./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)"