Table of Contents

Search

  1. Preface
  2. Introduction
  3. Working with Enterprise Data Manager
  4. Enterprise Data Manager
  5. ILM Repository Constraints
  6. Partition Exchange Purging
  7. APIs
  8. Smart Partitioning
  9. SAP Application Retirement Entities
  10. Import Formats for Constraints
  11. Glossary

Enterprise Data Manager Guide

Enterprise Data Manager Guide

Database Requirements

Database Requirements

Additional staging space in the source staging tablespace is required to create the keep table and to store data in the keep table. The staging space amount depends on the amount of data that is going to be kept in the source table.
When the archive job runs the partition exchange procedure, the procedure only creates one keep table. When the database completes the partition exchange for the source table, the procedure drops the keep table. This process is repeated for every table that is configured for partition exchange. The size of the keep table depends on each source table. Verify that you have enough staging space for the maximum difference between the source and staging tables.
To estimate the amount of required staging space, configure the archive job to pause after the copy to staging step. Review the log to calculate the sizes of the staging tables and the source tables.

0 COMMENTS

We’d like to hear from you!