PI17265: ENHANCE THE PERFORMANCE OF THE SYSTS_UPDATE STORED PROCEDURE

Obtain the fix for this APAR.

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 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.