Data Archiving 

 

To keep the size of a database as small as possible, you can archive application data that is no longer needed online or is only seldom accessed. Archiving objects specify from which tables data records are to be written to archive files, and whether the data records are to be deleted.

Using CCMS you can display the relationships between tables and archiving objects (see Displaying Archiving Objects and Tables) and query information about memory space and memory parameters. This information helps you to recognize the need for data archiving and to find suitable archiving objects for tables.

For more database-specific information, see:

Finding Storage Management Problems (DB2 UDB)

Determining Space Information (Oracle)

Determining Space Information (SAP DB)

Determining Space Information (Informix)

 

Data archiving is part of the alert monitor. You can monitor and analyze the writing of archive files (write job) and the deletion of data from the database (delete jobs) during an archiving session. For more information, see Data Archiving Monitor.

For a detailed description of data archiving in the R/3 System, see:

Archiving and Deleting Application Data