HP3000-L Archives

February 1999, Week 1

HP3000-L@RAVEN.UTC.EDU
Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
Re: Tallying DBOPENs
From:
[log in to unmask]
Reply To:
[log in to unmask]
Date:
Tue, 2 Feb 1999 11:23:55 -0500
Content-Type:
text/plain
Parts/Attachments:
text/plain (25 lines) 
Leonard Berkowitz <[log in to unmask]> on 2/2/99 asks:

>  Is there anyway of keeping track of the number of DBOPENs for a given
>  data base (other than logging file closes)?

   <snip>

Leonard,

I believe that you can get an instantaneous count of users on any given database
using the new LISTFILE command with the ",8" option against the database's
"global block" file.  See example below:

LISTFILE /ACCOUNT/DATA/FMMF2GB,8
 ********************
 FILE: /ACCOUNT/DATA/FMMF2GB
218 Accessors(O:218,P:218,L:0,W:218,R:218),Share

Hope this helps,

John Hornberger
Sr. Systems Programmer
General Signal Services (Subsidiary of SPX Corp.)
[log in to unmask]

ATOM RSS1 RSS2