AS400 record lock

5 pts.
Tags:
AS/400
AS/400 errors
AS/400 Records
AS400 RPGLE
I have a issue with a record lock. One of the user has locked and updated the record. He has signed off from the system. I want to update the same record but an error message is displayed saying the record is still locked. Kindly help.

Answer Wiki

Thanks. We'll let you know when a new response is added.

If the user has signed off, he cannot still have a lock on the record as all locks are released when a job ends.
DO a WRKOBJLCK to determine which job is locking the record.
Then you can determine where the real lock is.
If a user has just timed out and not signed off, he can still hold the lock.
You would need him to sign back on and then do a SIGNOFF.
If that is not possible, you cna do ENDJOB *IMMED for the job that has the record lock.

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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • philpl1jb
    Are you still getting the error message??? Please tell use the message.
    49,970 pointsBadges:
    report
  • ToddN2000
    If you cannot end the job normaly you may to to do an ENDJOBABN. We sometimes have a "phantom" job that just wont end or free up the resources. But see if that is the actual user who has the like with th WRKOBJLCK as mentioned above and let us know.
    11,295 pointsBadges:
    report
  • Yorkshireman
    You need a design level standard Don't lock the record. Don't ever write anything that locks a record - ever. Except just before you update it. read and display read and display decide an update is needed read the record for update (lock) check it hasn't changed since you displayed it ( tell the user if so) update it release the lock read and display read and display blahblah
    5,580 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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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

Following