IBM Books
(C) IBM Corp. 2000

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

  • Part 1. Users Guide

  • Chapter 1. Overview
  • Features
  • DB2 Net Search Extender in the DB2 client/server environment
  • Chapter 2. Installation
  • System requirements
  • Installation in AIX and Sun-Solaris systems
  • Step 1 for AIX: Install the product components
  • Step 1 for Sun-Solaris: Install the product components
  • Step 2 for AIX and Solaris: Update the DB2 instance
  • Windows installation
  • Installing the DataLink jar file
  • Defaults
  • DB2 Environment variables
  • Default database settings
  • Directory and filenames
  • Starting and stopping DB2 Net Search Extender
  • Migration
  • User roles
  • DB2 Instance owner
  • Database administrators
  • Text table owners
  • Chapter 3. Two simple examples
  • Using the Net Search Extender sample
  • Using the net.data sample
  • Chapter 4. Preparing to search
  • Why text documents need to be indexed
  • Which document formats and code pages are supported
  • Index storage and accessibility
  • Tokenization
  • Words
  • Sentences
  • Paragraphs
  • Chapter 5. Indexing
  • The db2text command
  • Enabling a database
  • Creating a text index
  • Example of creating a text index
  • Creating a text index on a nonsupported data type
  • Creating a text index for a DATALINK data type
  • Performance considerations
  • Result table cache
  • Chapter 6. Searching
  • Searching for text using SQL 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
  • 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 any sequence
  • Searching for terms in the same sentence or paragraph
  • Searching for terms in sections of structured documents
  • Searching with the Boolean operator NOT
  • Fuzzy search
  • Thesaurus search
  • Numeric attribute search
  • Free-text and hybrid search
  • Additional examples of SQL search function syntax
  • Searching for text using a stored procedure
  • Text indexes on views
  • Performance considerations
  • Chapter 7. Maintaining a text index
  • Maintaining text indexes
  • Updating and reorganizing an index
  • Altering an index
  • Deleting index update events
  • Dropping an index
  • Backing up and restoring indexes
  • Reversing the database preparation process
  • Disabling a database
  • Tracing faults
  • Chapter 8. Using DB2 Control Center
  • Instance administration
  • Database administration
  • Text index administration
  • Creating a text index
  • Maintaining a text index
  • Chapter 9. Working with different document formats
  • 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
  • Syntax of the locator element
  • What happens when an XML document is indexed
  • DTD for document models
  • Chapter 10. Additional features and services
  • Locking Services
  • Using the locking services
  • Viewing the lock settings
  • Update services
  • Thesaurus concepts
  • Terms
  • Relationships
  • Creating a thesaurus

  • 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)
  • 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
  • Chapter 14. SQL search functions
  • A summary of the search functions
  • CONTAINS
  • NUMBEROFMATCHES
  • SCORE
  • Using the table valued function
  • Chapter 15. Stored procedure search function
  • Stored procedure
  • Input Parameters
  • Input/Output parameters
  • Output parameters
  • Output Result Set
  • Chapter 16. Syntax of search arguments
  • Search argument
  • Chapter 17. Description of views
  • 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 table view
  • Log table view

  • Part 3. Appendixes

  • Appendix A. CCSIDs
  • SBCS
  • DBCS
  • UNICODE
  • Appendix B. Languages

  • Appendix C. Messages
  • Information and warning messages
  • Error messages
  • Appendix D. Search engine reason codes

  • Notices
  • Trademarks
  • Glossary

  • Index

  • Contacting IBM
  • Product Information

  • [ Top of Page | Previous Page | Next Page | Table of Contents | Index ]