Example: Finding Duplicate Keys in a Database File

Command

dbfinddupkeys dbtest80 dbtest1

Results

The utility finds multiple duplicate keys in the index Set2:

File: Dbtest1
  Scanning index Set1...
  Scanning index Set2...  duplicate index key found
    Key fields: Mc2
Mc1  Mc2      Mc3      Mc4      Mc5      Mc6    Mc7        Mc8s.Mc8[1] Mc8s.Mc8[2] Mc8s.Mc8[3]
   1 A        A        a        19950701 120001 6124828411        0.10        0.20        0.30
 210 A        CA       aa       19990701 000312 123              12.00       12.00       12.00
 211 A        CB       ab       19900701 000313 124              13.00       13.00       13.00
Number of duplicates: 3

Another duplicate index key found
  22 V        V        v        19950703 120014 6124828432        7.05        7.15        7.25
 212 V        VV       vv       19900703 000413 224             213.00       23.00       23.00
Number of duplicates: 2

  Scanning index Set3...
  Scanning index Set4...
  Scanning index Set5...