pIcheck - tool for checking/reapair picoIsam files


Corso Italia, 178 - 56125 Pisa
Telefono/fax 050 46380
e-mail picosoft@picosoft.it

pIcheck allows you to check the integrity of the picoIsam indexed files, used by picoSQL, and to rebuild them in case of corruption. pIcheck is a command line program and its synopsis is the following:

pIcheck [-icfr] picoIsam-file

Options have the following meaning:

-i
shows only relevant information about the file, namely:
  • number of key (nkey)
  • record size (recsize)
  • index node size (idxsize)
  • number of records, including the deleted ones (nrecords)
  • version number (version)
  • for each key:
    • key number (key)
    • flag of duplicate key (ISDUPS) or unique key (ISNODUPS)
    • number of parts of the key
    • for each part:
      • part number (part)
      • start offset of the key (start)
      • part length (leng)
      • part type (char,int,long,float,double)
Executing the program without options corresponds to execute it with this option.
-f
Check the file in fast mode.
-c
Check the file in slow mode. In some cases this check can be very long.
-r
Rebuild the index on the data file base.
-a
Rebuild the index and the data file expunging all deleted records.