I'm getting some inconsistencies in reported statistics from NLM_STATS and would like to know if I'm using the utility properly. What I would like to know is how many records have been written to a particular file since installation of the NLM. I don't care if they are new records or existing records. I just want a count of writes. The file in question (on an HR-1 system) is the EMP file, which is the main file. We process about 150 new hires a week in addition to thousands of changes to existing employees. I want to count each of these as a "hit". When I use NLM_STATS to query the statistics, however, I wind up with the following:

Read records: 157184

Write records: 283

This is in response to Linear Hash –] EMP –] Total

This is an absurdly small number. In addition, if I go to

Communications –] Server –] Total

I get 1,827,223,823 for requests received.

Is this latter number for all users and the first one only for me? How can I get the true number for all writes to EMP? My thinking is that it should be somewhere on the order of millions.

I'm getting some inconsistencies in reported statistics from NLM_STATS and would like to know if I'm using the utility properly. What I would like to know is how many records have been written to a particular file since installation of the NLM.

I'm not aware that 'since installation' is possible - the NLM resets any time the server is restarted. Could that explain the your low numbers?

But the point is not all the numbers are low. We have had nearly 2 billion requests, according to the same statistics that say only a couple hundred writes. Are there some statistics that don't get reset while others do upon a server boot? Incidentally, I'm unaware of a recent boot of that server. It is not supposed to be rebooted unless we have down time, which we haven't.

What impact to MFS's have on these statistics? The reason I ask is that I just noticed that while the write count to the data file is now 321, the write count to the associated index file is over 100,000. This also seems to be inconsistent.

Victor,

I just took a look at a couple of our files and I find similar results. The number of reads/writes on any specific file seem very low (I see 84 writes for one of the heaviest hit files) - I checked the server and it has been up for 59+ days. The total number of 'requests' is up there. If I look at read/writes under LH/Totals, the numbers are very high??? Someone more knowledgeable about the NLM will have to explain that . . .

But offhand, I think I would try to come up with a more reliable method of counting read/writes to a particular file - if that's what you really need. Maybe routines on the post-save of the related windows, or an MFS on the files.

I don't want to further burden the system. Also, adding those hooks will not produce historical results, which is what I'm looking for.

View this thread on the forum...