DB2 NET SEARCH / 5765F3800 / 950 - DB2

Here is the corrected recreate 
 
DB2 "CREATE TABLE DOCVIEWR ( DOCKEY VARCHAR(200) FOR BIT DATA 
NOT NULL , DOCTEXT CLOB(51200) LOGGED NOT COMPACT ) DISTRIBUTE 
BY HASH(DOCKEY) IN DOCVIEWR_TS" 
 
DB2 "ALTER TABLE DOCVIEWR ADD CONSTRAINT PK PRIMARY KEY 
(DOCKEY)" 
 
 
db2text "create index TEXT02R.CNINX_DOCVIEWER_DOC for text on 
docviewr (doctext) format TEXT connect to sample" 
 
 
db2 "Insert Into DocViewr Values('DocData_data://Clinical 
Notes/Clinical Note+3656405:264907976:4', 'This is a sentence 
mentioning both Remicade and never.')" 
 
db2text Update Index Text02R.CNInx_DocViewer_Doc For Text 
connect to sample 
 
/* This won't match on the document inserted above. */ 
db2 "SELECT * FROM DOCVIEWR TEXTTABLE where CONTAINS(DOCTEXT, 
'((\"never\" IN SAME SENTENCE AS \"Remicade\" ) | 
((\"infliximab\", \"Remicade\") IN SAME SENTENCE AS \"decision\" 
))') = 1" 
 
/* But just swapping the order of the arguments to the ?|? 
operator in the search argument it will then match on that 
document. */ 
db2 "SELECT * FROM DOCVIEWR TEXTTABLE where CONTAINS(DOCTEXT, 
'(((\"infliximab\", \"Remicade\") IN SAME SENTENCE AS 
\"decision\" ) | (\"never\" IN SAME SENTENCE AS \"Remicade\" 
))') = 1"

The problem has fixed and will be available in next 
fixpack

DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
 DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
 DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows
 

The problem is fixed and will be available in the 
next fixpack

not known / see Local fix

forerunner  : APAR is sysrouted TO one or more of the following: IC70559 IC70564 IC70974 IC71017 IC71109 IC71128 
follow-up : 

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

02.06.2010
19.01.2011
19.01.2011