How To
Summary
Use the steps below to enable DB2 Text Search on a loaded Maximo Manage database when your DB2 server is running outside of the OPC cluster on Linux or Windows.
NOTE: Containerized DB2 deployment does not support Text Search at this time.
Objective
Maximo versions 7.5 and 7.6 of TPAE can be configured to use DB2 Text Search option at the installation time.
Enabling Text Search lets Maximo use a search type "TEXT" for Long_Description, Description and ALN attributes.
As a result DB2 uses a CONTAINS statement, which is built into the database engine, to search text search indexes that are based on the search arguments that you specify in Maximo.
Maximo Application Suite current versions require taking a few additional steps to enable it.
Environment
Existing Maximo Manage DB2 database running on Windows or Linux with existing Text Search Server Installed.
Text Search Server is an optionally installable component whose installation and configuration is fully integrated with the installation of all DB2 database server products. It can be downloaded from Db2 Text Search server download and installed if missing.
To verify Text Search Server installation check for db2ts folder:
In Linux /home/db2inst1/sqllib/db2ts
In Windows C:\Program Files\IBM\SQLLIB\db2ts
Steps
Maximo Application Suite
DB2 on Linux
Login as an instance owner and execute in sequence:
db2start
db2 force application all
db2ts start for text
db2ts enable database for text connect to <dbname> user <username> using <password>
db2start
db2 force application all
db2ts start for text
db2ts enable database for text connect to <dbname> user <username> using <password>
Upon successful execution of the statements run the following select:
select serverport,serverauthtoken from sysibmts.systsservers
Confirm that there are values returned (sysibmts.systsservers catalog stores the text search properties) and then run:
db2stop
db2start
db2stop
db2start
In the OPC Cluster Console navigate to the manage project and select the manage-maxinst pod, open the terminal and navigate to:
/opt/IBM/SMP/maximo/tools/maximo/internal
Next, run:
ToggleDB2TextSearch.sh -q
Observe the creation of the Text Search Indexes and when completed, start Manage Pods.
Login to Manage, navigate to the Database Configuration Application and select for example, the Asset object.
Check if Text Search is enabled on the object: Navigate to the attributes tab and select the DESCRIPTION attribute. Observe that the Search Type “TEXT” can be selected.
DB2 on Windows
Navigate to Administrative Tools > Services and make sure that Windows Service DB2TS-DB2COPY1-DB2-0 is present on the list (Note that the format is DB2TS-<DB2 Copy Name>-<Instance Name>-<Node Number> and values could be different in the installation depending on which copy and instance are in use)
If the Windows Service is not there, execute in sequence:
Login as the instance owner and run:
db2stop
db2iupdt DB2 -u <instanceowner>,<password> -j TEXT_SEARCH
Login as the instance owner and run:
db2stop
db2iupdt DB2 -u <instanceowner>,<password> -j TEXT_SEARCH
When executed successfully, verify that Windows Server DB2TS-DB2COPY1-DB2-0 has been created, then run:
db2start
db2 force application all
db2ts start for text
db2start
db2 force application all
db2ts start for text
Observe that service DB2TS-DB2COPY1-DB2-0 has been started
Next, run:
db2ts enable database for text connect to <dbname> user <username> using <password>
db2ts enable database for text connect to <dbname> user <username> using <password>
Upon successful execution of the statement run the following select:
select serverport,serverauthtoken from sysibmts.systsservers
Confirm that there are values returned (sysibmts.systsservers catalog stores the text search properties) and then run:
db2stop
db2start
db2stop
db2start
In the OPC Cluster Console navigate to the manage project and select the manage-maxinst pod, open the terminal and navigate to:
/opt/IBM/SMP/maximo/tools/maximo/internal
Run the command:
ToggleDB2TextSearch.bat -q
ToggleDB2TextSearch.bat -q
Observe the creation of the Text Search Indexes when completed, start Manage Pods.
Login to Manage, navigate to the Database Configuration Application and select for example, the Asset object.
Check if Text Search is enabled on the object: Navigate to the attributes tab and select the DESCRIPTION attribute. Observe that the Search Type “TEXT” can be selected.
Login to Manage, navigate to the Database Configuration Application and select for example, the Asset object.
Check if Text Search is enabled on the object: Navigate to the attributes tab and select the DESCRIPTION attribute. Observe that the Search Type “TEXT” can be selected.
Additional Information
n/s
Related Information
Document Location
Worldwide
[{"Type":"MASTER","Line of Business":{"code":"LOB59","label":"Sustainability Software"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSRHPA","label":"IBM Maximo Application Suite"},"ARM Category":[{"code":"a8m3p000000hAeaAAE","label":"Maximo Application Suite-\u003EMAS Applications-\u003EManage"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.11.0"}]
Product Synonym
MAS8.11,MANAGE
Was this topic helpful?
Document Information
Modified date:
27 February 2024
UID
ibm17123741