We maintain two databases that have the same data. (Well, more or less. It is US patent data and should be the through 2006 at least.) A query that I run on server "A" returns 4 rows. When I run the same query on server "B" I get zero rows.
Here is the query:
SELECT PATN_WKU
FROM PATN
WHERE PATN_TTL\ABST_PAx\CLMS_PAx
LIKE '+plurality +apparatus @0 segment w/4'
AND PATN_ISD > '20060801'
AND PATN_ISD < '20060831';
All of the data returned by the query from the PATN table on server A are also in the PATN table on server B. My best guess is that there is something wrong with the index. Here are the commands used to create the index on both servers:
DROP INDEX PATN_ABST_CLMS_MI;
set delexp=0;
set addexp='\alnum{1,99}';
set keepnoise=1;
set indexmeter=1;
create METAMORPH INVERTED index PATN_ABST_CLMS_MI on PATN(PATN_TTL\ABST_PAx\CLMS_PAx,PATN_ISD);
Of significance, I suspect, is that several errors (about ten, actually) were returned when the index on server B was building. They were all returned at the end of the process, and they all looked like the following:
100 Error in data, file /data3/texisdb/camp/PATN.tbl, offset 0x1C9E27B28A
005 Bad size 0 for column DETD_PAx at offset 0xD10 in recid 0x1D439D4CA8 of /data3/texisdb/camp/PATN.tbl in the function fbuftofld
Anyway, not sure how to go about troubleshooting this issue. Thanks again for the help.
Here is the query:
SELECT PATN_WKU
FROM PATN
WHERE PATN_TTL\ABST_PAx\CLMS_PAx
LIKE '+plurality +apparatus @0 segment w/4'
AND PATN_ISD > '20060801'
AND PATN_ISD < '20060831';
All of the data returned by the query from the PATN table on server A are also in the PATN table on server B. My best guess is that there is something wrong with the index. Here are the commands used to create the index on both servers:
DROP INDEX PATN_ABST_CLMS_MI;
set delexp=0;
set addexp='\alnum{1,99}';
set keepnoise=1;
set indexmeter=1;
create METAMORPH INVERTED index PATN_ABST_CLMS_MI on PATN(PATN_TTL\ABST_PAx\CLMS_PAx,PATN_ISD);
Of significance, I suspect, is that several errors (about ten, actually) were returned when the index on server B was building. They were all returned at the end of the process, and they all looked like the following:
100 Error in data, file /data3/texisdb/camp/PATN.tbl, offset 0x1C9E27B28A
005 Bad size 0 for column DETD_PAx at offset 0xD10 in recid 0x1D439D4CA8 of /data3/texisdb/camp/PATN.tbl in the function fbuftofld
Anyway, not sure how to go about troubleshooting this issue. Thanks again for the help.