utility to validate the integrity for all identity tables and identity indexes and to identify any issues. The
checkiirtable
utility checks the identity indexes with the identity tables to find any orphaned identity index entries.
checkiirtable -r<Name of the Rulebase> -h<Host name:Port> -p<System name> -i[Identity table name[,Identity index name]]
where:
-r<RulebaseName>
Required. Name of the Rulebase.
-h<Host name:Port>
Required. Host name of the Rulebase server and port number on which the Rulebase server listens.
-p<System name>
Required. Name of the system that you want the utility to use.
-i[Identity table name[,Identity index name]]
Checks the integrity of all identity tables and identity indexes in this system, or a particular identity table and identity index. For more information about checking integrity, see
Integrity Checking.
By default, the utility checks the integrity of all identity tables and identity indexes when the identity table and identity index names are not specified.
-k
Optional. Displays erronous records with additional details.
and provides erroneous records with additional information. Used in conjunction with
-i
.
-b
Optional. Deletes the bad or orphan identity index entries. Used in conjunction with
-i
.
-j
Optional. Provides a detailed log information of the utility.
-vpsui
Optional. Enables verbose information, where
p
indicates progress,
s
indicates statistics,
u
indicates usage, and
i
indicates information.
-c
Optional. Disables the comparison of the User Source Tables (UST) content with the Identity Table (IDT). The UST comparison is enabled by default and used in conjunction with
-i
. For more information about the UST comparison, see
Integrity Checking.
-l
Optional. Prints a summary of the Identity Table (IDT) format. Used in conjunction with
-H<Host name:Port>
,
-SSearchName
, and
-i
.
-H<Host name:Port>
Optional. Specifies the host name and port number of the server.
-SSearchName
Optional. Nominates the search definition to use.
--recid_pool_size
Optional. Specifies the number of unused record IDs that you want to store and use.
Storing an excessive number of record IDs might consume significant memory because the file that contains unused record IDs is loaded into memory when the synchronization server starts up. Default is 1000.
--e
Required. Specifies the name of the identity table from which you want to reuse record IDs.
--getRecidFrmDB
Required. Enables writing unused record IDs to the file specified in the
enable_unused_recid_file
setting.
When you include this parameter in the checkiirtable utility command, unused record IDs are written to the file that is specified in the
-f
parameter. By default, it is disabled.
-d
Required. Specifies the name of the database that contains the identity table from which you want to use unused record IDs.
If you specify the
--getRecidFrmDB
parameter, you need to specify this parameter.
-f
Required. Specifies the path and name of the file in which you want to store unused record IDs.
If you specify the
--getRecidFrmDB
parameter, you need to specify this parameter. When you run the checkiirtable utility, specify the same value that you specify in the real-time web service settings file.