GFE after REMAKETABLE (AREV Specific)
At 28 JUL 2004 03:54:19AM Brian Parker wrote:
GFE after REMAKETABLE
I am trying some experiments on a test system to improve access to our AREV 3.12 hashed files. The test file in question first has VERIFYLH (F) run, which checks out ok and recommends a framesize of 2048. The file statistics are as follows:-
Size .LK=96,631 Kb
Size .OV=338,957 Kb
Frame=1024
Modulo=96,631
Av rows per group=3.08
Av row length=1272.17
Total rows=297,706
Dict rows (from LIST_DICT)=7
I then rebuilt the table as follows:-
REMAKETABLE DATA 297706 1273 7 2048 50
Resetting the threshold and the framesize however the file then has a GFE in the first group. Am I doing something wrong here?
Many Thanks for any help.
Brian
At 28 JUL 2004 05:03AM [email protected] wrote:
How big are the resulting LK and OV files?
The Sprezzatura Group Web Site
World Leaders in all things RevSoft
At 28 JUL 2004 05:54AM Brian Parker wrote:
.LK=467,788 .OV=257,792
Looking at the file with dumplh gives the following message:-
Header for group 1 has been corrupted. No framesize or modulo can be read. It then offers to fix it, which I haven't yet tried.
At 28 JUL 2004 07:08AM [email protected] wrote:
Can you repeat the remakefile LOCALLY using no network driver?
The Sprezzatura Group Web Site
World Leaders in all things RevSoft
At 28 JUL 2004 09:50AM Brian Parker wrote:
And that works fine. (Run from a local C: drive without LHsrvc).
At 28 JUL 2004 10:05AM [email protected] wrote:
OK will ensure the PTB are notified.
The Sprezzatura Group Web Site
World Leaders in all things RevSoft
At 28 JUL 2004 10:35AM Brian Parker wrote:
OK - Thanks for helping
At 28 JUL 2004 11:59AM Mike Ruane wrote:
Brian-
What network product are you using, and what version?
Thanks-
Mike Ruane
Revelation Software
At 28 JUL 2004 12:05PM Brian Parker wrote:
It's the Universal driver 3.0.0.2 on Win2K server.