Controls the amount of main buffer cache allocated to FP indexes in SAP IQ 15 databases.
1 to 1000000
2500
Option can be set at the database (PUBLIC) level only.
Requires the SET ANY SYSTEM OPTION system privilege to set this option. Takes effect immediately.
FP_LOOKUP_SIZE_PPM applies to databases running where FP_NBIT_IQ15_COMPATIBILITY='ON'. If FP_NBIT_IQ15_COMPATIBILITY='OFF', SAP IQ ignores this option.
If FP_NBIT_IQ15_COMPATIBILITY='ON', FP_LOOKUP_SIZE_PPM controls the maximum number of lookup pages and restricts this number to a parts-per-million value of main memory, that is, the value of FP_LOOKUP_SIZE_PPM * size of main memory / 1,000,000, where the size of main memory is specified by the -iqmc server startup parameter.
The FP_NBIT_IQ15_COMPATIBILITY option provides tokenized FP support similar to that available in SAP IQ 15, not complete database compatibility. All SAP IQ 15 runtime behavior is available using the 16.0 interface. Avoid running a 16.0 database with FP_NBIT_IQ15_COMPATIBILITY='ON'.