DBLibWaitTime vs DBEventReconnect

Document ID : KB000106080
Last Modified Date : 11/07/2018
Show Technical Document Details
Question:
Can changing the value for the DBLibWaitTime vs DBEventReconnect parameter in the config file accomplish the same thing?
Answer:
DBEventReconnect controls how many attempts must fail before AutoSys does a rollover. AutoSys waits a hardcoded minute between each attempt. DBLibWaitTime controls how long to wait before AutoSys considers a query execution failure. The longer the DBLibWaitTime, the longer it will be before AutoSys invokes the database monitoring system. Once invoked, the database monitoring system uses DBEventReconnect to delay rollover as long as each attempt fails until it exhausts the number of connects. Even though either value would affect the time for a rollover to occur, it is recommended to increase the DBEventReconnect value. AutoSys will delay the rollover one minute per reconnect attempt.