The Partition Configuration tab in the SDM allows you to set parameters to auto-archive partitions. It also allows you to auto-add partitions.
To configure auto-archive parameters:
Click the Partition Configuration tab. The Partition Configuration window displays.
Select the table group from the drop-down list.
Enter the following partition configuration information:
Partition Interval: Specify the number of partitions that should be created per day or per hour.
Days Online: Number of days of data to keep online in the database.
Archive destination: Specify the destination to store the automatically archived data and the manually archived data.
Offline operation: Choose archive and/or drop the data.
NOTE: Data that is dropped without archiving cannot be retrieved using SDM. You should almost always choose the archive option.
Specify the Job Schedule parameters:
Check Jobs Enabled checkbox if its not selected. By default the Jobs Enabled checkbox will be checked if you have selected this feature during installation.
Schedule adding partitions and offline operation parameters. Click Save.
Click History to view the Job History.
Enter the Job Properties:
Add Min: Minimum number of days of partitions for future data that should exist in the database at any time
Add Max: Maximum number of days of partitions for future data that should exist in the database at any time
Archive Chunk: Minimum number of days of partitions that would account to total number of days of partitions for Archive.
NOTE: If the fewer than Add Min days partitions exist in the database, partitions are added until there are enough partitions for Add Max days. Archiving also is done in chunks of days so that these database operations are not necessary every day.
Click Save.