IBM Support

IJ16170: DB2 TEXT SEARCH SPECIAL CHARACTER SEARCHES ARE NOT WORKING AS EXPECTED BASED ON THE BELOW DOCUMENTATION.

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error description

  • PROBLEM:
    Special character searches and operator searches are not
    working as expected based on the below documentation.
    i) & operator not working as expected.
    Searching for filter & oil creates a where clause of: (status
    != 'OBSOLETE' and contains(description, 'filter && & && oil') =
    1 and itemsetid = 'ITEMSET')
    Searching for filter oil creates a where clause of: (status !=
    'OBSOLETE' and contains(description, 'filter && oil') = 1 and
    itemsetid = 'ITEMSET')
    ii) ~ operator not working at all
    Searching for filter ~air throws the below error within Maximo.
    BMXAA6713E - The MBO fetch operation failed in the mboset with
    the SQL error code -171. The record could not be retrieved from
    the database. See the log file for more details about the
    error.
    Document the client is referencing -
    https://www.ibm.com/support/knowledgecenter/SSLKT6_7.6.1/com.ibm
    .mbs.doc/gp_ui/r_wildcard_operator_search.html
    PERFORMANCE ISSUE:
    N
    STEPS TO REPRODUCE:
    Steps to Reproduce:
    Login to Maximo
    Go to Inventory / Item Master
    in the description field search for pipe & male
    Hit enter. No results
    Now go do the same in a Oracle database the search will return
    results.
    If you look at the query for the DB2 test the query doesn't
    look right compared to the Oracle database.
    CURRENT ERRONEOUS RESULT:
    EXPECTED RESULT:
    Filter the same way Orcale does.
    ADDITIONAL INFO:
    ENVIRONMENT (SYSTEM INFO):
    App ServerIBM WebSphere Application Server 8.5.5.5VersionIBM
    Maximo Transportation 7.6.2.4 Build 20170221-0604 DB Build
    V7624-02IBM Maximo for Oil And Gas 7.6.1.0 Build 20161020-0803
    DB Build V7610-139Tivoli's process automation engine
    7.6.0.9-IFIX20180420-1312 Build 20171127-0100 DB Build V7609-45
    HFDB Build HF7609-04IBM Maximo Calibration 7.6.0.0 Build
    20171127-0100 DB Build V7600-06IBM TPAE Integration Framework
    7.6.0.9 Build 20171126-2330 DB Build V7609-32IBM Maximo Linear
    Management 7.6.0.2 Build 20171127-0100 DB Build V7602-03IBM
    Maximo Asset Management Scheduler 7.6.7.0 Build 20171127-0100
    DB Build V7670-56 HFDB Build HF7670-17IBM Maximo Spatial Asset
    Management 7.6.0.2 Build 20170518-1103 DB Build V7602-23IBM
    Maximo for Utilities 7.6.0.2 Build 20171128-1353 DB Build
    V7602-68IBM Maximo Asset Management Work Centers 7.6.0.3 Build
    20171121-0723 DB Build V7603-175IBM Maximo Asset Management
    7.6.0.9 Build 20171127-0100 DB Build V7604-01Server OSLinux
    2.6.32-754.el6.x86_64Server DBDB2/LINUXX8664 10.5 (SQL1005A)
    LOCAL FIX: N/A
    SECURITY IMPACT (Y/N): N
    

Local fix

  • N/A
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * MAXIMO                                                       *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * DB2 TEXT SEARCH SPECIAL CHARACTER SEARCHES ARE NOT WORKING   *
    * AS EXPECTED BASED ON THE BELOW DOCUMENTATION.                *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    

Problem conclusion

  • The fix for this APAR is contained in the following maintenance
    package:
    	 | release\fix pack | Interim Fix for Release 7.6.1.2 Product
    

Temporary fix

Comments

APAR Information

  • APAR number

    IJ16170

  • Reported component name

    SYSTEM CONFIG

  • Reported component ID

    5724R46S1

  • Reported release

    760

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2019-05-15

  • Closed date

    2019-08-06

  • Last modified date

    2019-08-06

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    SYSTEM CONFIG

  • Fixed component ID

    5724R46S1

Applicable component levels

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSLKT6","label":"IBM Maximo Asset Management"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"760","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Document Information

Modified date:
06 August 2019