I wasn't refering to "SHOWBASE".  If a user has "SM" caps they can run dbutil and
do a show on any db on their system and see what they need.  I have a script that
prompts me for an account, and then checks the db's in that account that are
locked, using DBUTIL.

Jeff Kell wrote:

> Larry Barnes wrote:
> >
> > If you're logged on with "SM" caps you can see any db.
> >
> > Keven Miller wrote:
> >
> > > I have a utillity called showbase that I thought came from CSL.
> > > But at this moment, my CSL searching fails with server not available, try
> > > again.
> > >
> > > It does basically the same as DBUTIL, but you can look at any database on
> > > your system
> > > (not limited to the account).
>
> SHOWBASE is mine, or at least a contribution of the same name.  It
> does essentially the same as a DBUTIL 'show users' followed by a 'show
> locks' and then prompts you to optionally do a ':tell' to a session
> number with the intent that you notify the holder of a lock to get
> their tail in gear or abort the transaction in progress :-)  We ran
> into this occasional problem after converting our in-house programs to
> use item level locks for update, but they are held during user input
> (I know, I know, don't crucify me for the strategy, but it seemed to
> be appropriate at the time).
>
> Depending on when you got your SHOWBASE and what OS you are on, yes,
> it may require SM (or AM) to display the results.  The older classic
> version would let anybody show database users/locks, but the newer one
> doesn't.  The program does have priv mode to call FOPEN of the root
> file, and subsequently pass the file descriptor to some undocumented
> IMAGE intrinsics that DBUTIL calls to process those commands.  The old
> version did an old classic MPE "FOPEN dammit!" (my terminology) that
> you could use in priv mode, as I recall without cranking up a VPN
> connection to work, it was AOPTIONS(13:3)=%7.  Somewhere down the road
> this stopped working (the FOPEN failed) and I had to change the parms
> but it no longer bypassed AM/SM security, probably because IMAGE now
> opens the file mapped.  It could probably be fixed but it was rather
> low on my priority list :-)
>
> I never contributed the source code because it used some of our
> internal SL/XL routines for terminal I/O; the version in the CSL had
> that code compiled into it.  But if anyone has suggestions to make it
> work like it used to I'd be more than happy to resubmit it with the
> fixed or magical FOPEN working for anyone.
>
> Jeff Kell <[log in to unmask]>

--
Larry Barnes
Director of I.T.
Mitek Corp.
602-438-4545 x1366
Phoenix, AZ 85040

Check Us Out !
http://www.mitekcorp.com