This is an archive of the Maximo Yahoo Community. The content of this pages may be a sometimes obsolete so please check post dates.
Thanks to the community owner Christopher Wanko for providing the content.
We recently found out that our DB2 database (9.7) was not text search enabled. We have since enabled the DB to full text search but I am unable to see the "TEXT" search option under "Search Type" for an attribute.
From a DB2 command line I get the following:
db2ts "START FOR TEXT"
CIE00204 Instance services already started
db2ts "ENABLE DATABASE FOR TEXT"
SQL20427N An error occurred during a text search administration procedure or command. The error message is "CIE00322 Specified or default database already enabled for text. ". SQLSTATE=38H14
I have specified a language table (EN_LR_LESSONLRND) for my object LR_LESSONLRND and have also defined a language column (LANGUAGE).
If someone could help point me in the right direction for next steps I sure would appreciate it. I would like to set several OOB description attributes to a search type of text VS. wildcard but do not see the TEXT search option available.
Many thanks,
Mike
I thought I would follow up with a solution to my own question. After much reading I finally found teh answer in the 7.5.0.7 release notes under enhancements for 7.5.0.1
Running the ToggleDB2TextSearch.bat was the missing link
Enabling full text search for DB2
---------------------------------------------------------------------------------
Full text search is a search option that lets you search for words and phrases,
as well as perform more complex searches using wildcards and logical operators.
Previous versions of Maximo Asset Management supported full text search
for Oracle and SQL Server databases. For Maximo Asset Management
7.5.0.1, full text searching is now supported for DB2. Complete the following
steps to enable full text search for DB2:
1. Ensure DB2 9.7.5 or later is installed.
2. From the DB2 server, enable full text search. Refer to
http://www-01.ibm.com/support/knowledgecenter/SSEQTP_8.0.0/com.ibm.websphere.base.doc/info/aes/ae/welc6topmigrating.html
for more information.
3. On the administrative workstation, open a command window and change directory
to product_install_directory/maximo/tools/internal/.
4. Run the ToggleDB2TextSearch.bat file. The file turns on text search for
Longdescription.LDText columns that are provided by default. The file does not
change the search type for any column to TEXT. You must individually enable
additional attributes for text search using the Database Configuration application.