Use the

checkiirtable

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.

For example, the

checkiirtable -rodb:0:ssa/ssa@orcl -h%SSA_RBHOST% -pbenchmark -k -iBench1,BusName

command checks the identity table

Bench1

and the identity index

BusName

and provides erroneous records with additional information.

-b

Optional. Deletes the bad or orphan identity index entries.

-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.