Entering content frame

Background documentation Archive Locate the document in its SAP Library structure

Database systems must be archived at regular intervals. Data from completed periods is extracted from the production system to prevent the level of performance dropping due to the volume of data.

The database instance type Archive enables you to retain this data alongside the production system in a second system, from which you can access the data directly. However, the data in the second system can be stored more cheaply on mass storage media.

To do this, you define special archive volumes that are linked to a storage management system with tape or CD robots. The SQL tables saved to this volumes must be assigned a specific attribute when they are created.

A group of DML commands is used to access the data. You can also create secondary keys, however, you enter these in the standard volumes of the database instance and not in the archive volumes.

The Archive instance type is particularly useful for Business Warehouse databases where very large amounts of data are stored.

 

Leaving content frame