FP_LOOKUP_SIZE_PPM Option

Controls the amount of main cache allocated to FP indexes in SAP Sybase IQ 15. databases.

Allowed Values

1 to 1000000

Default

2500

Scope

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.

Dependencies

FP_LOOKUP_SIZE_PPM applies to databases running where FP_NBIT_IQ15_COMPATIBILITY='ON'. If FP_NBIT_IQ15_COMPATIBILITY='OFF', SAP Sybase IQ ignores this option.

Description

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.

Important: The FP_NBIT_IQ15_COMPATIBILITY option provides tokenized FP support similar to that available in SAP Sybase IQ 15, not complete database compatibility. All SAP Sybase IQ 15 runtime behavior is available using the 16.0 interface. Avoid running a 16.0 database with FP_NBIT_IQ15_COMPATIBILITY='ON'.