Adding Partitions

The addPartitions action adds the required number of partitions in the following tables according to the partition configuration settings:

NOTE:Partitions are added in database both for events and correlated events if you select any one of these two. Partitions are added for all the summary tables if you select any one of them.

If you have configured the database to have 10 days worth of partitions, every time you run addPartitions it checks to see if you have 10 days of partitions available. If you have enough partitions for the next 10 days it does nothing. If not, it adds the required number of partitions.

This action uses the following flags:

Table 3 Adding Partition Flags

Command

Command FLags

-action

addPartitions

-connectFile

<filePath>

-tableName

<table name>

-keepDays

<days to add>

To run addPartitions:

  1. Execute this command as follows:

    -action addPartitions -connectFile <filePath> -tableName <table name> -keepDays <days to add>
    
    • PostgreSQL Example:

      ./sdm -action addPartitions -connectFile sdm.connect -tableName EVENTS -keepDays 10 
      

For trademark and copyright information, see Legal Notices.