Database Guide › Database Storage and Partitioning

Database Storage and Partitioning

This chapter describes how to implement a custom database storage and (for Oracle only) partitioning and purging scheme based on template SQL scripts. For Oracle databases, these scripts can also be customized to separate the 'primary user' and 'schema owner' database accounts.

Note: At the time of writing, partitioning support is not available for SQL Server.

Note: Scheduled event purges driven by the CA DLP infrastructure are described in the previous chapter.

This section contains the following topics:

Overview

Obtain the Native DDL Scripts

Customize the DDL Scripts

Prepare the Database

Run the DDL Scripts

Install the CMS

Set Up Partitions and Purging

Enable Multiple Concurrent Block Connections