The mpi_syskey table is used to define system-level configuration. This table is no longer used and has been replaced by mpi_sysprop and mpi_appprop.
- Expanded name
- System Registry
- Table category
- Base configuration
- Contains system-level configuration settings.
- Where noted, some configuration values refer to defined segments and other database entities.
|caudrecno||Creation of this particular record, from mpi_audhead|
|maudrecno||Last time the record value was modified, from mpi_audhead|
|recstat||Record status; A(ctive) or I(nactive)|
|keyname||Configuration identifier. Special values:
MPI_DEFAULT_SEARCHMAXROW - During a Search() interaction, this is the limiting number of rows to be returned. Since rows are in descending comparison score order, the top matches can be limited by the client program. There is no operational server-related retrieval affect; it is the responsibility of client programs to obtain this configuration value and submit it to the interaction.
MPI_DEFAULT_SEARCHTHRESH - During a Search() interaction, members with comparison scores below this threshold are not returned. Values from 0 – 100 are permitted; zero returns all records meeting the bucketing strategy, providing no filtering. There is no operational server-related retrieval affect; it is the responsibility of client programs to obtain this configuration value and submit it to the interaction.
CREATE TABLE mpi_syskey ( caudrecno bigint NOT NULL, maudrecno bigint NOT NULL, recstat nchar(1) NOT NULL, keyname nvarchar(40) NOT NULL, keyval nvarchar(255) NULL ) CREATE UNIQUE INDEX mpi_syskey1 ON mpi_syskey (keyname)