indexing

[Bruce Easton]

I don't remember if the clerk version number is
supposed to match the dxmaint version number
for 4.05.08K6, but based on what you wrote below,
I would be suspicious that you might have a
mismatch in runtime programs.  I would look into
any recent handling of those.

Specifically regarding the indexes yielding
different results, and especially in this case
where you are dealing with 8-digit dates, I
would check the environment var PFCMARK to
see if it might be set differently between
different dxmaint users of file such as:

-- you rebuilding an index now on the fly;
verses

-- some program that may be rebuilding
(possibly select) indexes - say in cron
at night for instance; verses

-- someone else rebuilding the index (with the
difference being their profile environment)

Also, I don't think you said if your second
index is built on the same date field or not
(for the date portion).

Also, whenever I run into unexpected indexing
problems, I check the lengths that each
index is built on for each field to make sure
it is as expected.

I also recommend reading on fptech's site
the release notes for 4.05.  If I remember
correctly, there were a number of issues,
plus new/changed controls regarding
indexing that occurred between 4.05 and
4.08.

Bruce


On 11/28/11 8:55 PM, davidrottkamp at echoes.net wrote:
> Do not know why version did not come out on email
> but it is 4.05.08K6D4 dxmaint
> rclerk 04.05.08R4
>
>
>
>
> Thanks,
>
> Dave Rottkamp
>
> Hi
>
> I have an indexing problem
>
>
> Sco unix op system
> dxmaint version
>
> rclerk version
>
> index A on file being built on a field called Date 8,mdy/
> when index is being updated or rebuilt it is missing records
> I have another index C same file built on date and employee number
>
> index C finds all the date records not found in in index A
>
> This has happened within the last few months of a system that has been
> running without this issue for years
>
> Ideas suggestions?
>
> Thanks,
>
> Dave Rottkamp
>
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL:
> http://mailman.celestial.com/pipermail/filepro-list/attachments/20111128/f1a4e7a2/attachment.html
> -------------- next part --------------
> A non-text attachment was scrubbed...
> Name: not available
> Type: image/png
> Size: 3767 bytes
> Desc: not available
> Url :
> http://mailman.celestial.com/pipermail/filepro-list/attachments/20111128/f1a4e7a2/attachment.png
> -------------- next part --------------
> A non-text attachment was scrubbed...
> Name: not available
> Type: image/png
> Size: 2904 bytes
> Desc: not available
> Url :
> http://mailman.celestial.com/pipermail/filepro-list/attachments/20111128/f1a4e7a2/attachment-0001.png
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list
>
>
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list
>
>