The index should never be out of date unless you did something wired to the
file, or the file is corrupt, or the index is corrupt. Did you use kill -9 on
your system, or have a machine crash or something?
You should probably use DELETE-INDEX to remove all indexes on the file, then
re-create the indexes using the script you wrote to create them originally.
JIm
From: [email protected] [mailto:[email protected]] On Behalf Of [Xze]
Sent: Monday, January 25, 2010 2:10 AM
To: [email protected]
Subject: Inaccurate SELECT results on INDEX fields
Dear all,
We are facing the issue described below:
When performing SELECT on INDEX fields the results are inaccurate
~ -->LIST-INDEX FBNK.LD.LOANS.AND.DEPOSITS
INDEX definitions for file FBNK.LD.LOANS.AND.DEPOSITS at 11:01:20 25 JAN 2010
PAGE 1
INDEX NAME LOCALE NAME SORT KEYS. LOOKUP.... INDEX
DEFINITION...................
CATEGORY en_US AR BY-AR 11
CUSTOMER.I en_US AR BY-AR 1
D
2 Records Listed
===============
~ -->SELECT FBNK.LD.LOANS.AND.DEPOSITS WITH CUSTOMER.ID EQ 369403
1 Records selected
~ -->SELECT FBNK.LD.LOANS.AND.DEPOSITS WITH CUSTOMER.ID EQ 369403 AND
((CATEGORY >= 21050 AND CATEGORY <=210
59) OR CATEGORY EQ 21095 OR CATEGORY EQ 21096) BY CATEGORY
210 Records selected
~ -->SELECT FBNK.LD.LOANS.AND.DEPOSITS WITH CUSTOMER.ID EQ 369403 AND
((CATEGORY >= 21050 AND CATEGORY <=210
59) OR CATEGORY EQ 21095 OR CATEGORY EQ 21096) BY CATEGORY NO.INDEX
1 Records selected
========
File 'FBNK.LD.LOANS.AND.DEPOSITS' is not a distributed file
Rebuilding the INDEX did not fix the issue
========
~ -->jdiag
jdiag - jBASE diagnostic '$Revision: 1.15 $'
System Information
==================
System : AIX jbsec 3.5 00CED1BC4C00
OS Release : 5.3.9.0
UNIX User : cobusr (uid 209, euid 209)
Tty name : /dev/pts/23
Time : Mon Jan 25 11:04:03 2010
Environment
===========
JBCPORTNO : Not Set
JBCRELEASEDIR : '/opt/jbase5'
JBCGLOBALDIR : '/opt/jbase5'
WARNING: JBCDATADIR is not set, Default '/opt/jbase5/jbase_data'
WARNING: JBCDATADIR is subdirectory of JBCGLOBALDIR
HOME : '/cob/cob/bnk.run'
JEDIFILEPATH : '/cob/cob/bnk.run'
JEDIFILENAME_MD : 'VOC'
JEDIFILENAME_SYSTEM : '/opt/jbase5/src/SYSTEM'
SYSTEM File is (DICT) : '/opt/jbase5/src/SYSTEM]D'
RELEASE Information : Major 5.0 , Minor 20 , Patch 0364 (Change 85159)
Spooler dir (JBCSPOOLERDIR) : '/var/spool/jbase'
JBCEMULATE : 'prime'
bnk.run/globuspatchbin', error 2
Object path (JBCOBJECTLIST) :
'/cob/cob/bnk.run/globuspatchlib:/cob/cob/bnk.run/lib:/cob/cob/bnk.run/globuslib:/cob/cob/bnk.run/fixlib'
WARNING: Cannot access Object path '/cob/cob/bnk.run/globuspatchlib', error 2
WARNING: Cannot access Object path '/cob/cob/bnk.run/fixlib', error 2
jBASE Compiler Run-time : '/opt/jbase5/config/system.properties'
Program dir (JBCDEV_BIN) : '/cob/cob/bnk.run/bin'
Subroutine dir (JBCDEV_LIB) : '/cob/cob/bnk.run/lib'
Max open files : 65534
Can anybody explain why is this happening?
Regards,
[ Xze ]
--
Please read the posting guidelines at:
http://groups.google.com/group/jBASE/web/Posting%20Guidelines
IMPORTANT: Type T24: at the start of the subject line for questions specific to
Globus/T24
To post, send email to [email protected]
To unsubscribe, send email to [email protected]
For more options, visit this group at http://groups.google.com/group/jBASE?hl=en
--
Please read the posting guidelines at:
http://groups.google.com/group/jBASE/web/Posting%20Guidelines
IMPORTANT: Type T24: at the start of the subject line for questions specific to
Globus/T24
To post, send email to [email protected]
To unsubscribe, send email to [email protected]
For more options, visit this group at http://groups.google.com/group/jBASE?hl=en
