Reorganizations

Purpose

Reorganization of resource consumption data

Menu

Administration ⇒ Scheduling

Tasks for an initial basic setup

Optional - but recommended

Having too much informations in the N1 AA Analyzer cube (historical resource consumption data) slows down response times. Therefore, old data can be moved to an archive table contained in the N1 AA database, see Maintenance. It is your choice if this should be done periodically without user interaction. All you have to do is create an N1 AA scheduling job using the following properties:

• Name = ArchiveUnarchiveJob

• Class = com.sun.web.admin.n1aa.analyzer.ArchiveUnarchiveJob

• Parameter = a "timestamp '-infinity'" "timestamp without time zone 'now' - interval '12 month'"

  ---

  Note –

  Use this exact string beginning with the character a. This means, that all data that is older than 12 months is archived. You may change the period of 12 months to a shorter value, for example 6 months, if your data growth is very high.

  ---

• Persistence = Persistent

• Start = Enter the date and time this job is to be first executed

• Interval = Recommend 86400 (daily reorganization)