FP_NBIT_IQ15_COMPATIBILITY Option
Provides support for tokenized FP indexes similar to that available in SAP IQ 15.
ON, OFF
FP_NBIT_IQ15_COMPATIBILITY='OFF' in all new 16.0 databases. FP_NBIT_IQ15_COMPATIBILITY='ON' in upgraded SAP IQ 15 databases.
Option can be set at the database (PUBLIC) or user level. At the database level, the value becomes the default for any new user, but has no impact on existing users. At the user level, overrides the PUBLIC value for that user only. No system privilege is required to set option for self. System privilege is required to set at database level or at user level for any user other than self.
Requires the SET ANY PUBLIC OPTION system privilege to set this option. Can be set temporary for an individual connection or for the PUBLIC role. Takes effect immediately.
The FP_NBIT_IQ15_COMPATIBILITY option provides tokenized FP support similar to that available in SAP IQ 15. All newly created and modified tokenized FP indexes in 16.0 will be NBit. The only 15 style FP(1),FP(2), and FP(3) byte FP indexes available in 16.0 are those from an upgraded database that have had only Read-Only activity.
The FP_NBIT_IQ15_COMPATIBILITY ON/OFF setting only pertains to tokenized FP creation and cut-off behavior:
- Enables the MINIMIZE_STORAGE, FP_LOOKUP_SIZE, FP_LOOKUP_SIZE_PPM options
- Creates DATE datatypes as NBit FP, even if IQ UNIQUE(0) is specified
- Rolls over to Flat FP at the 3 byte FP cutoff (16,777,216 distinct)
- Can tokenize data widths <= 255
- MINIMIZE_STORAGE, FP_LOOKUP_SIZE, FP_LOOKUP_SIZE_PPM options are ignored.
- DATE datatypes are not automatically NBit
- Data widths <=32767 may be tokenized
- NBit FP (tokenized) upper bound limit is NBit 31 (2,147,483,648 distinct values)
- NBit sizing options
determine rollover behavior:
- IQ UNIQUE(0) loads a column as Flat FP
- Columns without IQ UNIQUE load as NBit up to the auto-size limits
- Columns where IQ UNIQUE(<n>) is less than the auto-size limit load as NBit
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'.