housekeeping not worked at IBM DB2 database

XMLWordPrintable

      hello
      we have some problem in housekeeping process in my zabbix server .
      my zabbix server version is 3.0.7 and worked with IBM_DB2 database.
      my zabbix server housekeeping configuration is :

      ### Option: HousekeepingFrequency
      #       How often Zabbix will perform housekeeping procedure (in hours).
      #       Housekeeping is removing outdated information from the database.
      #       To prevent Housekeeper from being overloaded, no more than 4 times HousekeepingFrequency
      #       hours of outdated information are deleted in one housekeeping cycle, for each item.
      #       To lower load on server startup housekeeping is postponed for 30 minutes after server start.
      #       With HousekeepingFrequency=0 the housekeeper can be only executed using the runtime control option.
      #       In this case the period of outdated information deleted in one housekeeping cycle is 4 times the
      #       period since the last housekeeping cycle, but not less than 4 hours and not greater than 4 days.
      #
      # Mandatory: no
      # Range: 0-24
      # Default:
      HousekeepingFrequency=3
      
      ### Option: MaxHousekeeperDelete
      #       The table "housekeeper" contains "tasks" for housekeeping procedure in the format:
      #       [housekeeperid], [tablename], [field], [value].
      #       No more than 'MaxHousekeeperDelete' rows (corresponding to [tablename], [field], [value])
      #       will be deleted per one task in one housekeeping cycle.
      #       SQLite3 does not use this parameter, deletes all corresponding rows without a limit.
      #       If set to 0 then no limit is used at all. In this case you must know what you are doing!
      #
      # Mandatory: no
      # Range: 0-1000000
      # Default:
      MaxHousekeeperDelete=5000
      

      in bellow you can see housekeeping log at debug level 2

      1177650:20180228:123520.427 executing housekeeper
      1177650:20180228:123520.633 housekeeper [deleted 0 hist/trends, 0 items, 0 events, 0 sessions, 0 alarms, 0 audit items in 0.192291 sec, idle for 3 hour(s)]
      

        1. output
          992 kB
        2. housekeeping.JPG
          housekeeping.JPG
          48 kB

            Assignee:
            Unassigned
            Reporter:
            Mohammad Reza Abadi
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: