<snip>
Is there anyway of keeping track of the number of DBOPENs for a given data
base
(other than logging file closes)?
We are trying to find out whether we are approaching the maximum number of
DBOPENs
per data base.
<end snip>

It sounds like you are looking for simultaneous opens not total opens for a
given time period. Then again I am sure you know that you can do a listf ,3
and find the number of simultaneous opens.

If you are using Netbase I believe you can use the statistics module to
gather the data you are looking for if you want data over a time period.

If you are looking for simultaneous opens then maybe I can help. I just did
a test to see how many opens the OS would handle before it ran out of
resources. Check out these statistics:

I had almost 3,000 jobs logged on.
Each job opened 5 databases anywhere from 2 to 10 times. I kicked the jobs
off in batches of a few hundred and passed a parameter using STREAMX telling
the job how many times to open each database.
I each database was opened a total of 6,461 times (listf ,3). So 5 databases
time 6,461 opens per database is 32,305 opens. Then I ran out of DST table
entries (I was running TBLMON and GLANCE).

The program that opened the databases was a simple Cobol program that opened
the databases then paused in a loop looking for a file OPENSTOP as a trigger
to close the databases. As soon as I built that file the jobs fell out of
the loop and logged off. This was not the best way to kick that many jobs
off it took 6 hours just for the jobs to log off.

The system used for this test was a 995/400 with 2GB of memory and 6 2GB FW
drives on my system volume set. I also had the databases spread across three
private volumes that were very large. The system has a total of about 230GB
usable (it is mirrored).

Sincerely,
Joshua Johnson
HP3000 System Manager
MicroWarehouse, Inc.