Siebel User Keys

User keys are the set of columns in a table which can uniquely identify a record.

User Keys are nothing but Unique Indexes on the table will be individually verified. For Example S_PERIOD has 3 Unique Indexes . First U1 gets verified and then U2 verified and at the last U3 will be verified.

Its not that all the Usery keys will be applied in combination but one at a time.

DB2 query to find Indexes for any table

select substr(INDNAME,1,30),substr(tabname,1,10),COLNAMES, UNIQUERULE, UNIQUE_COLCOUNT from syscat.indexes where tabname='S_PERIOD'

Additional systems table for DB2

syscat.references (fkeys)
syscat.tables (table names)
syscat.columns (column names)
syscat.procedures (stored procs, triggers?)