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]>