PI17265: ENHANCE THE PERFORMANCE OF THE SYSTS_UPDATE STORED PROCEDURE

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • Enhance the performance of the SYSTS_UPDATE stored procedure.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All DB2 9, 10, and 11 for z/OS users of      *
    *                 the IBM Text Search for DB2 z/OS (Omnifind). *
    ****************************************************************
    * PROBLEM DESCRIPTION: This apar will improve query wildcard   *
    *                      search functionality for the text       *
    *                      search server and enhance the           *
    *                      SYSTS_UPDATE stored procedure to        *
    *                      significantly improve the performance   *
    *                      for updating a small number of rows.    *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    This apar will deliver the following two improvements.
    
    (1) Improve wildcard searching functionality for the text search
        server.
    
    Some wildcard searching will return the expected results while
    others may not.
    
    For example, given the appropriate data, if a wildcard search is
    performed to search for 'disapprove*', rows will be returned
    that contain 'disapproving'.  This result is incorrect.  If
    however we search for 'disapprov*', we will get 'disapproving'.
    This is correct.
    
    
    (2) Enhance the SYSTS_UPDATE stored procedure to enhance
        performance for updating a small number of rows.
    
    The user will need to download and install the most current
    version of the IBMTS server from this link.
    
      http://www.ibm.com/software/data/db2/zos/downloads/oftss.html
    

Problem conclusion

  • Along with the application of this apar, the included ++HOLD
    information and instructions should be referenced for improved
    wildcard searching using the IBM Text Search and for the
    performance improvements offered for the SYSTS_UPDATE stored
    procedure.
    
    Additional Keywords: SQLOMNIFIND OMNIFIND TEXTSEARCH INCORROUT
                         SQLINCORROUT SQLINCORR DB2INCORR/K
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI17265

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2014-05-02

  • Closed date

    2014-07-10

  • Last modified date

    2014-08-04

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

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

    UI19519 UI19520 UI19521

Modules/Macros

  •    DSN@O001 DSN@O002 DSN@O004 DSN@O005 DSN@O007
    DSN@O008 DSN@O009 DSN@O011 DSN@O012 DSN@O013 DSN@O014 DSN@O015
    DSN@O016 DSN@O017 DSN@O019 DSN@O021 DSN5OCA3 DSN5OCA6 DSN5OCO3
    DSN5OCO6 DSN5OCU3 DSN5OCU6 DSN5OPAL DSN5OPCR DSN5OPDR DSN5OPMS
    DSN5OPRE DSN5OPSD DSN5OPSP DSN5OPST DSN5OPTO DSN5OPUP DSN5OTMS
    DSN5OTS
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RA10 PSY UI19519

       UP14/07/26 P F407

  • RB10 PSY UI19520

       UP14/07/26 P F407

  • R910 PSY UI19521

       UP14/07/26 P F407

Fix is available

  • Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

DB2 for z/OS

Software version:

910

Reference #:

PI17265

Modified date:

2014-08-04

Translate my page

Machine Translation

Content navigation