The ftsdump utility may be used to obtain FTS details. It is mostly intended
for diagnostic use.
ftsdump [options] cmd database [set[.fld]|refid ...]
options:
-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
commands:
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
|