IBM Books
(C) IBM Corp. 2000

DB2 Net Search Extender Administration and User's Guide


Contents

  • About this book
  • Who should use this book
  • How to use this book
  • How to read the syntax diagrams
  • Related information
  • How to send your comments
  • Contacting IBM
  • Product information
  • Summary of changes

  • 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 ]