The addPartitions action adds the required number of partitions in the following tables according to the partition configuration settings:
PostgreSQL:
EVENTS
AUDIT_RECORD
CORRELATED_EVENTS
EVT_DEST_EVT_NAME_SMRY_1
EVT_DEST_SMRY_1
EVT_DEST_TXNMY_SMRY_1
EVT_PORT_SMRY_1
EVT_SEV_SMRY_1
EVT_SRC_SMRY_1
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:
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.