Click here to jump to Nash!Com Solutions Homepage - Click here to request a test version.
Database Fulltext Index
Version: 1.0c
Shortname: nshdbft
Category: Command-Line Tool
Nash!Com Database Fulltext Index is a command-line tool for creating, deleting and updating database fulltext index via command-line.
It helps to display and modify fulltext settings on multiple databases.
This program can be used on clients or servers (server console).
- list all databases with fulltext index
- create fulltext index
- update fulltext index
- delete fulltext index
- update fulltext index
* | NshDbFt 1.0a - Notes/Domino Fulltext Index
|\| (c)1999-2001 NashCom - Daniel Nashed Communication Systems
| * mailto:info@nashcom.de - http://www.nashcom.de
Syntax: nshdbft <database> [action flags] [-f<filename>]
Database Selection Options:
-s<servername> : server name
-r : process directories recursively
Output Options:
-o<outfile> : output file
-m<mailuser> : send report to
Actions:
-l : list databases with fulltext index
-u : update fulltext index
-c : create fulltext index
-d : delete fulltext index
-x : delete & disable fulltext index
Nash!Com Fulltext Index Security helps to list and modify Notes database fulltext index in multiple databases I can also be used to update, create and delete fulltext index. In some cases fulltext index of a large database becomes corrupt and it makes sense to rebuild it from scratch. In other cases you might want to just delete the fulltext without disabling it (e.g. for copying database to another server). You have the option to rebuild the index later if you do not disable it. In addition you can update specify fulltext indexes (e.g. one directory, one database, ...) using the update option.
-- Action to perform --
The following actions are currently supported
( -l ) List databases that have a fulltext index enabled.
lists all selected databases that have the fulltext index option set.
Examples:
nshdbft *.nsf -l1
Lists all databases with fulltext index option enabled.
( -u ) Update fulltext index of selected databases
updates the fulltext index of selected databases that already have the fulltext index option set.
Database without fulltext index option enabled will not be indexed!
Limitation: This option does only work on local databases and should be started from server console if this option is needed.
Examples:
nshdbft *.nsf -r -u
Updates existing fulltext index in all databases.
( -c ) Create fulltext index for selected databases
creates and updates the fulltext index of selected databases that already have the fulltext index option set.
This option use the index options that are in database. If the database has never been indexed, use the default indexing options. Database indexing options include the Stop Word File name, case sensitivity, the PSW option, reindexing, and the stem index.
Examples:
nshdbft *.nsf -r -u
Creates fulltext index in all databases
( -d ) Deletes fulltext index for selected databases
deletes the fulltext index of selected databases. But does NOT disable the fulltext index in the database.
It will be updated by updall automatically. In case you want to delete it and create it from scratch immediately use the ( -u ) option in combination.
Examples:
nshdbft *.nsf -r -d
Deletes the fulltext index in all databases
( -x ) Deletes and disables fulltext index for selected databases
deletes and disables the fulltext index of selected database.
It does not modify the Database indexing options.
If you enable the fulltext index later on the same options are used.
Examples:
nshdbft *.nsf -r -d
Deletes and disables the fulltext index.
What happens if no flags are used?
If you do not use one of the action flags, the databases are only listed.
You could use this feature to check if your selection is OK or to create a file that you can modify and use via -f option
-- Ways to select databases --
1. specify a database name in the command line
2. specify a list of databases listed in a file via option -f
3. use wildcards (* and ?) for specifying databases and templates including subdirectories if using the ( -r ) option
4. specify a remote server name ( -s ) where to search for databases
you can combine any listed ways
Some examples:
1. specify a database name in the command line
Example:
nshdbft mydb.nsf
runs on mydb.nsf
2. specify a list of databases in a file via option -f
Example:
nshdbft mydb.nsf -fdb.txt
runs on mydb.nsf and all databases listed in db.txt
db.txt should contain databases including full path like
names.nsf
mail/jdoe.nsf
info/acme.nsf
3. use wildcards for specifying databases and templates including subdirectories if using the ( -r ) option
Example:
nshdbft mail/*test*.nsf
runs on all databases that meet the selection within the mail subdirectory
e.g. mail/dus-test.nsf but not mail/dus/old/test.nsf
If you want to include subdirectories use the -r switch.
As soon you have multiple wildcards in different directories you need to use the recurse subdirectory switch
Example:
nshdbft mail/test?/*.nsf -r
this does match e.g. mail/test1/jdoe.nsf
but also matches mail/test2/hilden/acme.nsf because this does also match the pattern.
4. specify a remote server name ( -s ) where to search for databases
-s Option defines the server where databases are searched
Example
nshdbft -snotes-acme-01 mail/*.nsf
runs on databases (.nsf files) in directory mail on notes-acme-01
nshdbft mail/test??xxx*.nsf
runs on databases (.nsf files) that match the pattern "/mail/test??xxx*.nsf"
-- Output options --
In case you want to redirect output you have the following options
( -o ) Redirect output to file
Writes output to a the file specified.
Example: nshdbft mydb.nsf -ooutfile.txt
writes output to outfile.txt
Comment: this option might help to create a list of databases that can be modified and uses as input for "-f" option.
( -m ) Send output via mail
Sends output to the specified user.
Example: nshdbft mydb.nsf -m"John Doe"
sends output to John Doe
( -k ) Overwriting Client/Server Settings
Nash!Com Command Line Tools run on Servers or Clients.
However in some cases and environments it can not determine if running on server or as Client program using server environment.
Therefore you can override the default settings using this option.
Server and Client functionality does only differ in the way output is logged.
Installation Instructions
- copy into Notes exe directory
- run from command line or server console
and make sure notes.ini can be found in the directory or is in the path