SAVACTWAIT time on SAVLIB, etc.

5 pts.
Tags:
Application security
AS/400
Backup & recovery
Data analysis
Database
DataCenter
DB2
DB2 Universal Database
Encryption
Instant Messaging
Microsoft Exchange
Oracle
Secure Coding
Security
Hi, Has anyone experimented with the SAVACTWAIT time on the SAVLIB command. The default on 120 second seems rather long. What I am looking for is a realistic value based on fact such as that if an object does not become available after 5 second the change that it will become available after 120 seconds is virtually 0%. My thinking says that this possibility of the object becomming available for save diminishes exponentially over time: Seconds to wait Possibility % -------------------------------------- 1 90 2 40 3 10 4 5 5 2 etc., etc., etc. I had a look at the Knowledge Base and Info Center but could not find anything. Any help will be appreciated.
ASKED: May 29, 2006  8:19 AM
UPDATED: November 30, 2010  2:49 PM

Answer Wiki

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

I use this for 99.9% of my saves with a SAVACTWAIT of 05. We will see occasional locking but not normally.

Discuss This Question: 5  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
  • TomLiotta
    Is there a problem somewhere in this question? If you want to use 5 seconds, then use 5 seconds. Tom
    125,585 pointsBadges:
    report
  • ITAddict
    Availibility to wait time will depend entirely on your environment. If you have interactive users that are accessing data while you are saving, 120 seconds is a reasonable amount of time assuming they are getting their work done and getting out. If you have batch jobs running against data, 5 seconds would be plenty of time.
    875 pointsBadges:
    report
  • TomLiotta
    If you have batch jobs running against data, 5 seconds would be plenty of time. Although that's probably true for many sites, it shouldn't be. Interactive users should be the ones holding extremely short locks while batch locks may be expected to hold locks for the length of the job and they might run a long time. Tom
    125,585 pointsBadges:
    report
  • Boykie
    We have been running for years with 5 seconds as we anticipate some objects being locked - and have been happy with the results. We only have about 6 or 8 objects locked, so waiting 40 seconds is not horrendous. Like a previous responder said, "if you want to use 5 seconds, use 5 seconds". Am I missing something ?
    65 pointsBadges:
    report
  • OldSysAdmin
    I think the person is looking for other persons experience so that he doesn't just go make a change and cause problems unnecessarily. Sure, he can make it whatever he wants. He wants to make an intelligent and informed (as much as possible) change. You know. like us old timers used to do, fully understand as much as possible. As opposed to the young kids today, don't read the documentation or anaylze it, just try a million different things and eventually one of them will work.
    945 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