PDA

View Full Version : can i check if reindex required



Micha
4-Feb-2005, 08:00 AM
Hy to all,

some time a go there was an info as how to check
if a reindex (vdfsot) is nessasary.
But I cant´find it, does any one know how i can check
it per apllication .

Thank´s for any help

regards
Micha

David Martinko
4-Feb-2005, 08:19 AM
Micha,

There is a contribution on the vdf-guidance website that checks for bad
indexes.

It is slower than running a reindex, however it can be useful.
1) You will _know_ there was a bad index, so if it happens often you can
track it down.
2) If your system is used 24 hours a day and can't stop to reindex, this
utility will let you know you _have_ to reindex.

It reads each record by recnum and attempts to find that record in each
index file... one record at a time.

--
David Martinko
Redeemed Software
248-535-7495
RedeemedSoftware(SHIFT+2)Hotmail(PERIOD)com

"Micha" <micha.kleinbeck@psf-technik.de> wrote in message
news:4APVOmrCFHA.4924@dacmail.dataaccess.com...
> Hy to all,
>
> some time a go there was an info as how to check
> if a reindex (vdfsot) is nessasary.
> But I cant´find it, does any one know how i can check
> it per apllication .
>
> Thank´s for any help
>
> regards
> Micha
>

Bob Cergol
4-Feb-2005, 09:42 AM
Warning: Of course this approach won't tell you if there are records that
are missing in the .DAT file that exist in one or more of the index files,
that might result in a duplicate record error when trying to add a new
record. I've run into other .dat file corruption over the years that a
reindex repairs or at least detects, that looping through the file with Find
GT by Recnum would not detect. So, the useful, it is not an absolute
guarantee that the file is not in need of maintenance.

Bob


"David Martinko" <RedeemedSoftware@Hotmail.com> wrote in message
news:ZYQuxwrCFHA.4924@dacmail.dataaccess.com...
> Micha,
>
> There is a contribution on the vdf-guidance website that checks for
bad
> indexes.
>
> It is slower than running a reindex, however it can be useful.
> 1) You will _know_ there was a bad index, so if it happens often you can
> track it down.
> 2) If your system is used 24 hours a day and can't stop to reindex, this
> utility will let you know you _have_ to reindex.
>
> It reads each record by recnum and attempts to find that record in each
> index file... one record at a time.
>
> --
> David Martinko
> Redeemed Software
> 248-535-7495
> RedeemedSoftware(SHIFT+2)Hotmail(PERIOD)com
>
> "Micha" <micha.kleinbeck@psf-technik.de> wrote in message
> news:4APVOmrCFHA.4924@dacmail.dataaccess.com...
> > Hy to all,
> >
> > some time a go there was an info as how to check
> > if a reindex (vdfsot) is nessasary.
> > But I cant´find it, does any one know how i can check
> > it per apllication .
> >
> > Thank´s for any help
> >
> > regards
> > Micha
> >
>
>

David Martinko
4-Feb-2005, 09:45 AM
Bob,

The utility can actually be changed to improve it, I suppose. After a
find eq, there can be a find gt and that should alert to any problems. (I
presume that may work).

--
David Martinko
Redeemed Software
248-535-7495
RedeemedSoftware(SHIFT+2)Hotmail(PERIOD)com

"Bob Cergol" <rcergol@compuserve.com> wrote in message
news:6YCPTcsCFHA.4924@dacmail.dataaccess.com...
> Warning: Of course this approach won't tell you if there are records that
> are missing in the .DAT file that exist in one or more of the index files,
> that might result in a duplicate record error when trying to add a new
> record. I've run into other .dat file corruption over the years that a
> reindex repairs or at least detects, that looping through the file with
> Find
> GT by Recnum would not detect. So, the useful, it is not an absolute
> guarantee that the file is not in need of maintenance.
>
> Bob
>
>
> "David Martinko" <RedeemedSoftware@Hotmail.com> wrote in message
> news:ZYQuxwrCFHA.4924@dacmail.dataaccess.com...
>> Micha,
>>
>> There is a contribution on the vdf-guidance website that checks for
> bad
>> indexes.
>>
>> It is slower than running a reindex, however it can be useful.
>> 1) You will _know_ there was a bad index, so if it happens often you can
>> track it down.
>> 2) If your system is used 24 hours a day and can't stop to reindex, this
>> utility will let you know you _have_ to reindex.
>>
>> It reads each record by recnum and attempts to find that record in each
>> index file... one record at a time.
>>
>> --
>> David Martinko
>> Redeemed Software
>> 248-535-7495
>> RedeemedSoftware(SHIFT+2)Hotmail(PERIOD)com
>>
>> "Micha" <micha.kleinbeck@psf-technik.de> wrote in message
>> news:4APVOmrCFHA.4924@dacmail.dataaccess.com...
>> > Hy to all,
>> >
>> > some time a go there was an info as how to check
>> > if a reindex (vdfsot) is nessasary.
>> > But I cant´find it, does any one know how i can check
>> > it per apllication .
>> >
>> > Thank´s for any help
>> >
>> > regards
>> > Micha
>> >
>>
>>
>
>

Micha
4-Feb-2005, 10:30 AM
Thank´s David
I´ll take a look on vdf-guidance
Regards
Micha


"David Martinko" <RedeemedSoftware@Hotmail.com> schrieb im Newsbeitrag
news:ZYQuxwrCFHA.4924@dacmail.dataaccess.com...
> Micha,
>
> There is a contribution on the vdf-guidance website that checks for bad
> indexes.
>
> It is slower than running a reindex, however it can be useful.
> 1) You will _know_ there was a bad index, so if it happens often you can
> track it down.
> 2) If your system is used 24 hours a day and can't stop to reindex, this
> utility will let you know you _have_ to reindex.
>
> It reads each record by recnum and attempts to find that record in each
> index file... one record at a time.
>
> --
> David Martinko
> Redeemed Software
> 248-535-7495
> RedeemedSoftware(SHIFT+2)Hotmail(PERIOD)com
>
> "Micha" <micha.kleinbeck@psf-technik.de> wrote in message
> news:4APVOmrCFHA.4924@dacmail.dataaccess.com...
>> Hy to all,
>>
>> some time a go there was an info as how to check
>> if a reindex (vdfsot) is nessasary.
>> But I cant´find it, does any one know how i can check
>> it per apllication .
>>
>> Thank´s for any help
>>
>> regards
>> Micha
>>
>
>