Hi you can use the ariel_offline_indexer.sh on your box, you can see the details on this technote https://www.ibm.com/support/pages/qradar-how-use-arielofflineindexersh.
I would like to suggest a couple of things:
- Storing indexes for 6 months will take a LOT of disk space on your EPs/FPs/Console, so I would recommend make it incremental
- Generating those indexes will consume a LOT of CPU and IO, so your box should have available resources to run the command, or you should use it during low usage times.
- Executing a query to search though 6 month, if there is a lot of data, will take a lot of time, even if that data it's indexed. So figure it out if you really need that.
- Searching the data 6 month back, without indexes will still find what you're looking for, so it's not mandatory to have indexes to find the data.
- Tune your index attributes an queries, if you create a search in the wrong way, even if the data it's indexed then the query will have to review all the data.
Regards