Highlighted
Absent Member.
Absent Member.
4396 views

[archive] Finding which user has a record locked

[Migrated content. Thread originally posted on 20 October 2004]

We have been running on a Windows 2000 server with the thin client and using Vision files for several months. One problem I am having is trying to determine which user has a record locked.

All users are mapped to a single account on the server.

Short of recoding all of my applications, does anyone know how I can find the user or at least the PID of the task that has a record locked in a Vision file.

Thanks, Duane
0 Likes
13 Replies
Highlighted
Absent Member.
Absent Member.

RE: [archive] Finding which user has a record locked

In HPUX I have used the function:

CALL "C$LOCKPID" GIVING WS-PROCESS-ID


It is the DECLARATIVES section for each file that we access.
0 Likes
Highlighted
Absent Member.
Absent Member.

RE: [archive] Finding which user has a record locked

Unfortunately the c$lockpid routine does not work with windows.
0 Likes
Highlighted
Absent Member.
Absent Member.

RE: [archive] Finding which user has a record locked

See my post elsewhere in this forum.
0 Likes
Highlighted
Absent Member.
Absent Member.

RE: [archive] Finding which user has a record locked

If you are referring to the netenumfiles program, I have tried that but have not had any luck. It only seems to show files that are opened over the network.

If I use alfred to open a Vision file accoss the network, it shows up in the netenumfiles program. All of the other Vision files that are open do not show up, I assume because they are opened locally on the server by thin client users.
0 Likes
Highlighted
Absent Member.
Absent Member.

RE: [archive] Finding which user has a record locked

Correct, local opens are not listed by that API. Naturally, that would have been thousands of files related to the OS as well.

Have you considered using AcuServer?
0 Likes
Highlighted
Absent Member.
Absent Member.

RE: [archive] Finding which user has a record locked

It is not enough of a problem to justify buying another product. Thanks for your input.
0 Likes
Highlighted
Absent Member.
Absent Member.

RE: [archive] Finding which user has a record locked

hi,

If you run a windows 2000 or XP system (server or workstation)
you could use the managment console "mmc.exe".

If you choose the "shared folder" snap-in and connect to your
file-server. You can find under the "open files" all the files who are in use, by who and a lock indication.


Greets,

Ronald
0 Likes
Highlighted
Absent Member.
Absent Member.

RE: [archive] Finding which user has a record locked

Hi Ronald,

The "Shared Folders" in the MMC gives me the same info as the netenum program mentioned earlier in this post. When using the AcuConnect thin client, the Vision files are opened locally on the server and do not show up in this list.

Thanks for the suggestion,

Duane
0 Likes
Highlighted
Absent Member.
Absent Member.

RE: [archive] Finding which user has a record locked

I do not know what kind of performance hit it will cause, but with Windows NT/2000/XP/2003, you can map a drive to a local share and then files opened on it should show up in MMC/netenumfiles.

For example, share the folder c:\mydata as "mydata".

net use m: \\mysystem\mydata

Set FILE-PREFIX to M:\

Now any files opened should show up in MMC/netenumfiles. (I have not tried it myself specifically with Vision files, but I know it does work generally.)

This may cause issues with the thin client server however - you would need to play around with that - I don't recall whether or not the runtime spawned by the service runs as SYSTEM or not. SYSTEM generally cannot access network drives (unless you set it up to allow null session shares). The latest thin client server apparently does now allow you to run the service in an account other than the SYSTEM account.
0 Likes
Highlighted
Absent Member.
Absent Member.

RE: [archive] Finding which user has a record locked

JoeD,

I was not able to get your suggestion working using mapping drive letters, but it does seem to work using by assigning the file name directly using the share (\\servername\filename). It does show up in the netenumfiles program.

As you mentioned, I am sure there is a performance hit to doing this way and I do not think I want to risk that.

Thanks, Duane
0 Likes
Highlighted
Absent Member.
Absent Member.

RE: [archive] Finding which user has a record locked

Hi

I have the same requirement and use Acuserve. Still I can't find out how to get the username.

Can anyone help?

Thanks, Christian
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.