contact contact

ftsdump utility

  The ftsdump utility may be used to obtain FTS details. It is mostly intended for diagnostic use.
ftsdump [options] cmd database [set[.fld]|refid ...]

 -help   - show usage (this list)
 -u user - set user name
 -p pswd - set password
 -c cfg  - server configuration file
 -l lim  - list keywords with at least lim references
 -k      - refid argument list (rather than set list)
 -t type - 1=string, 2=numeric (default both)
 -M      - use master key

 list   - list keywords and number of references
 detail - detailed list of keywords and references
 stat   - internal fts statistics

A list of fts indexes may be specfied as argument: A set name 
or number reads fts indexes for a set. A set and field name 
specifies a fts field. If the -k option is used the fts refid 
may be specified.
ftsdump is a stand alone utility which directly accesses the volume files. Consequently, the database server may not be running or must be in on-line backup mode.

The -c option is used to specify the eloqdb.cfg file for the server instance. It defaults to the file eloqdb.cfg in the Eloquence config directory.

The list command lists the keywords and their total number of occurrences. The detail command lists the keywords along with reference details. The stat command obtains statistics on the FTS indexes and disk space consumption.

The database argument specifies the database name. A data set or set.field name may be specified to filter output for a specific set or an FTS field. A refid argument may be used to filter the output for a specific FTS field (listed in the prdbutil -l fts output). The -l option may be used to specify a minimum number of references a keyword must have to be listed.

The example below shows how to use ftsdump to list all keywords having more than 10000 references (which would be good candidates for an exclusion list).

ftsdump -l 10000 list database
ftsdump -l 10000 detail database

  Privacy | Webmaster | Terms of use | Impressum Revision:  2012-11-07  
  Copyright © 2012 Marxmeier Software AG