AS/400: Finding a list of objects which are locked by users.

1480 pts.
Tags:
AS/400
CL Program
iSeries
MIMIX
We have Visions Mimix global software replicating data from Source to 3 target servers. There are few users running sql queries etc on the target servers causing objects to go into lock and this results in objects going into replication error. Is it possible to get a list of objects which are locked by users other than the mimix user MIMIXOWN. Is there any such command which can give such a list of objects (Preferably object lying in selected production libraries) locked by users other than MIMIXOWN. This would help us inform users to release the lock before MIMIX goes into error.
0

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • TheRealRaven
    Since locks can come and go in fractions of a second (potentially hundreds or thousands of them), it usually makes no useful sense to get a list of all locked objects. By the time the list was finished being built, some locks at the beginning of the list would already be released and new locks on other objects would be established. The list would be inaccurate before it would be finished being built.

    So there is no system-level function to do it because it can't practically be done.

    The problem isn't clear. Are you using MIMIX to do a batch replication at some fixed time-of-day somehow? Or is it simply that a changed object happens at the same time a user is using it on a target system?
    35,190 pointsBadges:
    report
  • JohnsonMumbai
    You are right, a changed object happens at the same time a user is using it on target system. Typically the user locks the object on target and leaves his desk for some other activity and forgets about the lock that is id had left on the system.  Typically if an object is found locked for more than say couple of minutes to 5 minutes we would like the system to send an alert to the user and the admin.
    1,480 pointsBadges:
    report
  • pdraebel
    We had similar issues on allowing users Query on the target side. The problem MIMIX had with locks was related with the way trigger handling in MIMIX was set. If it is set in a certain way MIMIX will try to disable or remove the trigger temporarily while replaying a change on a target file. In order to do that an EXCLUSIVE lock needs to be obtained on the Object being updated. I know this can be solved inside MIMIX setup, so I would suggest asking your MIMIX guys for a proper solution on this.
    7,545 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: