making CHGOBJOWN faster

pts.
Tags:
AS/400
DB2 Universal Database
Is there a way to make a command like CHGOBJOWN run faster. Rather than waiting to get an exclusive lock on the object I would rather see the command try once and move on. I still need to capture the fact that the change failed, I just want it to fail quicker if it is going to fail.

Answer Wiki

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

add an ALCOBJ before your CHGOBJOWN, this will trap the object lock immediatly.

Discuss This Question: 2  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
  • TheQuigs
    You could also try using a CHGJOB DFTWAIT(1) command. I believe this should change the default wait time to acquire a lock to 1 second. I believe the default is 30 seconds, but this can be altered depending on how your system is set up.
    0 pointsBadges:
    report
  • Brami06
    about a half hour after I posted the question, I figured it out. I went with the change job option. Thanks for your responses. This site is a great tool when you are stuck. Just about everything that can be done on 400 has been done by someone, somewhere at sometime.
    0 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