2 Replies Latest reply on Dec 21, 2018 7:51 AM by Meyyappan Lakshmanan

    How to change the default value for local monitoring

    Meyyappan Lakshmanan
      Share:|

      Whenever a new ETL Engine component is installed, it gets discovered, and generates alert for file system utilization percentage. We would like to change that value from 80 to 85 at global level, so that we don't need to do that for each of the ETL Server (we have total 80 servers)

       

      ETL_servers.JPG

      configuration_change.JPG

        • 1. Re: How to change the default value for local monitoring
          Marco Colombo

          Hi, it is possible with a query. All local monitoring tasks are sharing the same type (tasktypeid=34).

          So, a way to bulk configure all of them is:

           

          insert into task_pset_props

          select taskpsetid, 'fs.alert.threashold', '85' from task_pset where taskid in (select taskid from task where tasktypeid=34)

          and taskpsetid not in (select taskpsetid from task_pset_props where name = 'fs.alert.threashold')

           

          this query is adding the correct property to configure alert at 85%.

           

          After that, tasks have to be notified about the change. This can be done with following query:

           

          insert into task_exec_req (taskexecreqid, taskid, ts, reqtype, status)

          select sqn_nextval('task_exec_req'), taskid, get_sysdate(), 'SENDCONF', 'TODO' from task where tasktypeid=34

           

          this query is requesting to scheduler supervisor to update configuration for such tasks.

          • 2. Re: How to change the default value for local monitoring
            Meyyappan Lakshmanan

            Thanks Marco. This worked as expected, after changing the value and the second query made it to enable it for the tasks.

             

            For other users, just small tips for the same query:

             

            Do commit; after each query, And in the second query which enables the settings for the tasks, this is the correct one:

            insert into task_exec_req (taskexecreqid, taskid, ts, reqtype, status, exects, taskpsetid)

            select TASK_EXEC_REQ_SQN.NEXTVAL, taskid, get_sysdate(), 'SENDCONF', 'TODO', get_sysdate(), taskpsetid from task_pset where taskid in (select taskid from task where tasktypeid = 34); commit;