Generally, we recommend backing up your data on a daily basis. To back up all Jedox databases, you must save all folders of the directory
<install_path>\olap\data. To do this in Jedox Web, right-click on the database in Modeler and select Download database… For details on download options, see Downloading a Database.
To back up the Jedox In-Memory DB manually on your local machine:
Backing Up Data on Linux Systems
With appropriate path and service adjustments, the more detailed descriptions outlined in Backing Up all Jedox Data with Batch Files are also true for backups on Linux systems.
We also recommend that you perform a daily autosave of the Jedox data so that the difference between the data in your Memory/RAM and that on the hard disk will be minimized. For example, you can obtain a daily automatic data storage at 2:00 am with the following entry in the palo.ini:
autosave T 02:00
Automatic Asynchronous Autosave
Jedox 2019.2 automatically saves databases in intervals controlled by the server itself. Automatic asynchronous autosave does not back up your data; rather it saves a “snapshot” of the database until the next autosave replaces that snapshot.
A few highlights of the autosave functionality:
- Autosave is nonblocking, i.e., users can read and write to the server while save is running.
- It is fully controlled by the server to prevent big journals from being created to enable fast server restart and minimize problems during journal processing.
Note: the previous autosave function, set in palo.ini, is obsolete in 2019.2.
The default autosave interval is 5 minutes after the last completed autosave. These intervals can be changed in the configuration file palo.ini with the parameter
autosave-interval x, where
x is the interval (in minutes) in which automatic asynchronous autosave runs.
Autosave for Legacy Versions
For users still running older versions of Jedox (2019.1 and earlier), autosave can be configured with the autosave parameter in palo.ini. For example, you can obtain a daily automatic data storage at 2:00 am with the following entry in the palo.ini:
autosave T 02:00
autosave parameter is obsolete in the current version of Jedox (2019.2).