Table of Contents

Search

  1. Preface
  2. Installation Overview
  3. Before You Install
  4. Data Archive Installation
  5. Data Vault Installation
  6. Application Accelerator Installation
  7. Application Retirement for Healthcare Accelerator Installation
  8. MongoDB Accelerator Installation
  9. Salesforce Accelerator Installation
  10. After You Install
  11. Data Archive Upgrade
  12. Data Vault Upgrade
  13. ILM Data Validation Option Setup
  14. Data Archive Source and Target Database Requirements
  15. Data Archive Connectivity
  16. Data Archive Uninstallation
  17. SAP Application Retirement
  18. Appendix A: Database Users and Privileges
  19. Appendix B: Data Visualization Designer Installation
  20. Appendix C: Data Archive Installation Requirements Checklist and Architecture Options

Installation and Upgrade Guide

Installation and Upgrade Guide

Live Archiving

Live Archiving

Create a data staging tablespace in the source database for all live archive jobs. For example, AM_STAGING_D.
All live archive jobs require staging space. The archive job uses the staging space to store the following tables:
Interim tables
The archive job creates interim tables for business rule validation and candidate generation during the archive process.
The staging space requirements depend on the size of the interim tables. Configure the tablespace size to the number of archived rows from the largest table in a single archive job multiplied by the average row size. A general guideline is to use 1K for the average row size.
Staging tables
If you enable staging for the archive source connection, the archive job creates staging tables. The staging tables temporarily store a copy of the archived data before the archive job moves the data to the archive or history database.
The staging space requirements depend on the size of the data in the archive job. Configure the tablespace size to the largest amount of archived data in a single archive job.
Staging space is not required for retirement jobs. Retirement jobs do not validate business rules, generate candidates, or create staging tables because the jobs archive all source data.

0 COMMENTS

We’d like to hear from you!