This action (addPartitions) adds the required number of partitions in the following tables according to the partition configuration settings:
Oracle:
EVENTS
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
SQL Server
EVENTS
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 will be added for all the summary tables if you select any one of them.
If you are configured to have 10 days worth of partitions, every time you run addPartitions it checks to see if you have 10 days of partitions ahead. If you have enough partitions for next 10 days it will not do anything. If not, it will add the required number of partitions for 10 days.
This action uses the following 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>
Oracle Example:
./sdm -action addPartitions -connectFile sdm.connect -tableName EVENTS -keepDays 10
SQL Server Example:
sdm -action addPartitions -connectFile sdm.connect -tableName EVENTS -keepDays 10