Create IQ DB and best practices
hello IQ world!
I will have to work on POC project where SAP IQ 16 is used as main DWH and i would like to get experts overview about the parameters, when we create IQ db from the scratch. There are bunch of parametrs, which makes sense for experts, but if you are not in touch with this 24/7 , then this can turn into a nightmare The size of DB is expected to be around 1.5-2 Tb, no extra wide tables - max 15 columns, biggest fact table expected to be around 700m, max up to 1 billion rows.
According to best practices, i think that Page Size can be 4096 IQ Page Size 131072.
What about IQ Main dbspaze size and Local temporary DB size? Does it makes sense to set these values close to expected max size?