SI57588 - OSP-DB-OmniFind-Avoid warning/error message occurring over a

TYPE PROGRAM  REL  NUMBER   MIN/MAX  OPTION
---- -------- ---  -------  -------  ------
PRE  5733OMF  120  SI56783   NONE     0000
PRE  5733OMF  120  SI56784   NONE     0000
PRE  5733OMF  120  SI56786   NONE     0000
PRE  5733OMF  120  SI47005   NONE     0000
CO   5733OMF  120  SI49855   NONE     0000



NOTICE:
-------
Application of this PTF may disable or render ineffective programs that
use system memory addresses not generated by the IBM translator,
including programs that circumvent control technology designed to limit
interactive capacity to purchased levels.  This PTF may be a prerequisite
for future PTFs.  By applying this PTF you authorize and agree to the
foregoing.

This PTF is subject to the terms of the license agreement which
accompanied, or was contained in, the Program for which you are obtaining
the PTF.  You are not authorized to install or use the PTF except as part
of a Program for which you have a valid Proof of Entitlement.

SUBJECT TO ANY WARRANTIES WHICH CAN NOT BE EXCLUDED OR EXCEPT AS EXPLICITLY
AGREED TO IN THE APPLICABLE LICENSE AGREEMENT OR AN APPLICABLE SUPPORT
AGREEMENT, IBM MAKES NO WARRANTIES OR CONDITIONS EITHER EXPRESS OR IMPLIED,
INCLUDING BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OR CONDITIONS OF
MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, AND NON INFRINGEMENT,
REGARDING THE PTF.

The applicable license agreement may have been provided to you in printed
form and/or may be viewed using the Work with Software Agreements (WRKSFWAGR)
CL command.





APAR Error Description / Circumvention

-----------------------------------------------
OmniFind server would issue warning/error message for record
that have been processed already again on each SYSTS_UPDATE,
which would finally fills the joblog.

CORRECTION FOR APAR SE62547 :
-----------------------------
OmniFind server would not re-process warning/error record on
each SYSTS_UPDATE, so that warning/error message would not occur
over and over again.

CIRCUMVENTION FOR APAR SE62547 :
--------------------------------
None.


Activation Instructions


None.




Special Instructions


It will only take effect after shut down all the servers with
/QOpenSys/QIBM/ProdData/TextSearch/server<servernumber>/bin/shutdown.sh
shell script, apply this PTF, and then start up server with SYSTS_START
stored procedure.

********************************************************************
THE FOLLOWING ARE SUPERSEDED SPECIAL INSTRUCTIONS. IF THE SUPERSEDED
PTF HAS ALREADY BEEN APPLIED AND ITS SPECIAL INSTRUCTION FOLLOWED,
IT IS NOT NECESSARY TO FOLLOW THAT SPECIAL INSTRUCTION AGAIN.
********************************************************************

SPECIAL INSTRUCTIONS FOR SUPERSEDED PTF SI56068 :
=================================================

It will only take effect after shutdown all the servers with
/QOpenSys/QIBM/ProdData/TextSearch/server<servernumber>/bin/shutdown.sh
shell script, apply this PTF, and startup server with SYSTS_START
stored procedure.

SPECIAL INSTRUCTIONS FOR SUPERSEDED PTF SI51517 :
=================================================

Users have to recreate the index which has such issue. If the index was
created before applying this PTF and users hit the issue SQL0404, this
index should be dropped and recreated to make it take effect.


Default Instructions

THIS PTF CAN BE APPLIED IMMEDIATE OR DELAYED.



Supersedes

PTF/FIX NO(S).  APAR TITLE LINE
--------------  ------------------------------------------------------------
   SI56787      OSP-DB-OmniFind-qdbtssp.srvpgm-Update namespace from es to e
   SI56068      OSP-DB-OmniFind-Signal TIMEOUT message when hanging in index
   SI55541      OSP-DB-OmniFind-Do not throw warning message as it confuses
   SI54117      OSP-DB-OmniFind-QDBTSSP.SRVPGM-Re-process warning/error reco
   SI53431      OSP-DB-OTHER-F/AUEXCPT-T/QDBCRTFI-MSGMCH1001 MSGMCH1001 F/AU
   SI52842      OSP-DB-OmniFind-QDBTSSP.SRVPGM-Unexpected parse result from
   SI51517      OSP-F/QSQRUN3-T/QSQRUN3-MSGSQL0404 OMNIFIND WITH DBCS FIELDS
   SI51019      OSP-DB-Omni-MCH3601-QDBTSSP.SRVPGM-Error while varying on IA
   SI50245      OSP-F/QSQRUN4-T/QSQRUN4-RC702-MSGSQ20427 CALL SYSPROC.SYSTS_
   SI49673      OSP-DB-Omni-QDBTSSP.SRVPGM-UDF name can not be longer than 1
   SI47107      OSP-DB-Omni-QDBTSSP-Create index failed for staging table ca
   SI46996      OSP INCORRECT RESULT AFTER OMNIFIND UPDATE FUNCTION.
   SI45929      OSP-DB-Omni-qdbtssp.srvpgm-Changes with new Cascade code dro
   SI44349      OSP-DB2-Omni-Omnifind Health checker phase 2-QDBTSSP SRVPGM-
   SI43909      OSP-DB-Omni-QDBTSSP.SRVPGM-track update status better
   SI43686      OSP-DB-Omnifind-PERFM-SYSTS_UPDATE take too much time when t
   SI41739      OSP-DB2-Omni-QDBTSSP.SRVPGM-LASTUPDATESTATUS should be set t
   SI40298      OSP-DB-Omni-QDBTSSP.SRVPM-Index Schema name with '\' could n
   SI40121      OSP-DB2-Omni-Header file-Incremental update should not proce
   SI40074      OSP-DB2-Omni-QDBTSSP.SRVPGM-OmniFind index over a LCP file c
   SI40009      OSP-DB2-Omni-QDBTSSP.SRVPM-Incremental update should not pro
   SI38961      Omnifind internal maintenance
   SI38961      QDBTS INTERNAL MAINTENANCE
   SI38961      MISSING VIEW DATA AFTER MOVE/RENAME OF A TEXT SEARCH INDEX
   SI38961      OMF - Incremental enhancements to SYSTS_UPDATE
   SI38329      Common Ownership of objects Associated with a text search in
   SI38329      SQ20141 OCCURS DURING UPDATE OF TEXT SEARCH INDEX
   SI37344      OMF SQL KEYCOLUMN NAME NOT HANDLED CORRECTLY
   SI37129      Start server fail for shell script does not run
   SI37036      OSP-DB-Omni-QDBTSSP.SRVPGM-Creating index failed if base tab
   SI36937      OSP-OMF Support Text Search Indexes for QSQGNDDL and CPYLIB
   SI36717      OSP-DB-Omni-QDBTSSP.SRVPGM-SYSTS_UPDATE hang at autocommit p
   SI36632      OSP-DB-Omni-QDBTSSP.SRVPGM-Error message DSX_TABLE_IN_USE wi
   SI36327      OSP-DB-Omni-QDBTSSP.SRVPGM-Use index id as parameter of UPDA
   SI36181      CPF1002 Cannot allocate object QSYS2/SYSTXTINDX
   SI36160      OSP-DB-Omni-QDBTSSP.SRVPGM-use OBJECT_STATISTICS instead of
   SI36151      OSP-DB-Omni-QDBTSSP.SRVPGM-server timeouts do not cause erro
   SI36030      OSP-DB-Omni-QDBTSSP.SRVPGM-Can recognize parentheses as part
   SI35990      OSP-DB2-Omnifind-qdbtssp.srvpgm-Server id and collection nam

Summary Information

System i Support