(C) IBM Corp. 2000
DB2 Net Search Extender Administration and User's Guide
Part 1. User's Guide
Chapter 1. Overview and concepts
Key concepts
Using an SQL scalar search function
Using a stored procedure search
Using an SQL table-valued function for searching
Additional concepts
Column transformation function
Instance services
Externally stored data
Administration views
Partitioned database support
Indexes on nicknames in a federated database
Key features
DB2 Net Search Extender in the DB2 client/server environment
Chapter 2. Installation
System requirements
Installation overview for a partitioned DB2 server (UNIX)
Installation on UNIX
Step 1 for UNIX: Install the product components
Step 2 for UNIX: Update the DB2 instance
Windows installation
Directory names and file names
Installing the Outside-In libraries
Installation verification
Installation verification on Windows
Installation verification on UNIX
Chapter 3. User scenarios
Simple example with the SQL scalar search function
Simple example with cache usage and stored procedure search
Simple example with the SQL table-valued function
Chapter 4. Planning
Directory locations and index storage
Document formats and supported code pages
Outside-In filtering software
User roles
Using the command line or the DB2 Control Center interface for indexing
Chapter 5. Net Search Extender instance services
Starting and stopping DB2 Net Search Extender
Locking services
Using the locking services
Viewing a lock snapshot
Update services
Chapter 6. Creating and maintaining a text index
Introducing the db2text commands
Enabling a database
Disabling a database
Creating a text index
Creating a text index on binary data types
Creating a text index on a nonsupported data type
Creating a text index for DATALINK data types
Installing the Data Links jar file
Creating a text index on a nickname with incremental index update using DB2 Replication
Creating a text index which the stored procedure search can use
Text indexes on views
Performance considerations
Maintaining text indexes
Updating and reorganizing a text index
Altering a text index
Clearing index events
Dropping a text index
Viewing text index status
Backing up and restoring indexes
Chapter 7. Using DB2 Control Center
Starting and stopping DB2 Net Search Extender Instance Services
Enabling a database
Text index administration
Creating a text index
Maintaining a text index
Chapter 8. Searching
Searching for text using SQL scalar search functions
Making a query
Searching and returning the number of matches found
Searching and returning the score of a found text document
Specifying SQL search arguments
Searching for terms in any sequence
Searching with the Boolean operators AND and OR
Fuzzy search
Searching for parts of a term (character masking)
Searching for terms that already contain a masking character
Searching for terms in a fixed sequence
Searching for terms in the same sentence or paragraph
Searching for terms in sections of structured documents
Searching with the Boolean operator NOT
Thesaurus search
Numeric attribute search
Free-text search
Additional search syntax examples
Searching for text using a stored procedure search
Searching for text using an SQL Table-Valued Function
Using the highlight function
Searching on more then one column
Performance considerations
Chapter 9. Working with structured documents
Chapter 10. Using a thesaurus to expand search terms
The structure of a thesaurus
Predefined thesaurus relations
Defining your own relations
Creating and compiling a thesaurus
Creating a thesaurus definition file
Compiling a definition file into a thesaurus dictionary
Part 2. Reference
Chapter 11. Administration commands for the instance owner
CONTROL
START
STOP
Chapter 12. Administration commands for the database administrator
ENABLE DATABASE
DISABLE DATABASE
DB2EXTDL (utility)
DB2EXTHL (utility)
Chapter 13. Administration commands for the text table owner
ACTIVATE CACHE
ALTER INDEX
CLEAR EVENTS
CREATE INDEX
DEACTIVATE CACHE
DROP INDEX
DB2EXTTH (Utility)
UPDATE INDEX
HELP
COPYRIGHT
Chapter 14. Syntax of search arguments
Search argument
Chapter 15. SQL scalar search function and the SQL table-valued function
A summary of the search functions
CONTAINS
NUMBEROFMATCHES
SCORE
DB2EXT.TEXTSEARCH
DB2EXT.HIGHLIGHT
Chapter 16. Stored procedure search function
DB2EXT.TEXTSEARCH (for stored procedure search)
Stored procedure with SQL query
Input parameters
Input/Output parameters
Output parameters
Output Result Set
Chapter 17. Structured document support
Document models
Default document models
Defining a document model for structured plain-text documents
Element parameters
What happens when a GPP document is indexed
Defining a document model for HTML documents
Element parameters
Defining a document model for XML documents
Element parameters
What happens when an XML document is indexed
Defining a document model for Outside-In filtered documents
Element parameters
What happens when an Outside-In document is indexed
Chapter 18. Thesaurus support
Part 3. Appendixes
Appendix A. Migration
Moving from Net Search Extender Version 8.1 to Net Search Extender Version 8.1.x
Moving from Net Search Extender Version 7.2 to Net Search Extender Version 8.1.x
Moving from Text Information Extender Version 7.2 to Net Search Extender Version 8.1.x
Appendix B. Using large amounts of memory
AIX (32-bit and 64-bit)
Windows (32-bit)
The Solaris Operating Environment (32-bit and 64-bit)
Linux (32-bit)
HP-UX (32-bit and 64-bit)
Appendix C. Net Search Extender information catalogs
Views for database-level information
db2ext.proxyinformation table
Views for index-level information
db2ext.textindexes view
db2ext.indexconfiguration view
db2ext.textindexformats view
Table views for a text index
Event view
Log tables, views, and nicknames
Appendix D. Supported CCSIDs
CCSIDs
Appendix E. Supported languages
Appendix F. Net Search Extender messages
Information and warning messages
Error messages
Appendix G. Document model reference
DTD for document models
The semantics of locator (XPath) expressions
Limitations for text fields and document attributes
Outside-In tag attribute values
Appendix H. Text Search Engine
Tokenization
Words
Sentences
Paragraphs
Stopwords
Languages supporting stopwords
Appendix I. Text Search Engine reason codes
Appendix J. Troubleshooting
Tracing faults
Appendix K. Data Link messages
Appendix L. Thesaurus supported CCSIDs
CCSIDs
Appendix M. Messages returned by the thesaurus tools
Appendix N. Windows system errors
System errors
Appendix O. Notices
Trademarks
Glossary
Index
[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]