Manuel,
This crontab that hits each datasource every 15 min would also take care of
this hanging problem. If the datasource timeout is set to 30 min, the
datasources will not time out, and you won't have the problem. I did the
opposite thing and increased the datasourcetimeout.
I beleive the crontab being referred to is a tango program that is run every
15 minutes by the tango service, and it goes out to each datasource and
accesse it probably with a simple select. This will keep the data sources
from timing out.
Troy
>===== Original Message From [EMAIL PROTECTED] =====
>Hi Bent,
>I feel so bad that I cannot contribute to this thread. What do you mean by
>"touches each datasource"?
>TIA,
>Manuel
>
>Brent Skean wrote:
>
>> Troy,
>>
>> Dale Thomas recently had a suggestion about this issue...
>>
>> He uses crontab to activate a taf that touches each datasource every x
>> number of minutes.
>>
>> We use crontab to have our server send @serverstatus data in an email every
>> 15 minutes. We have now added the touching of the datasources.
>>
>> Brent
>>
>> -----Original Message-----
>> From: Troy Sosamon <[EMAIL PROTECTED]>
>> To: Rbase List <[EMAIL PROTECTED]>
>> Date: Friday, June 29, 2001 1:41 PM
>> Subject: Tango Service Hanging
>>
>> >I thought I would post back to the list in the event anyone else has this
>> >problem.
>> >I am running Tango 2000, Win 2000, IIS 5, Oterro 2000rt03.
>> >I have found the source of my problem with the Tango server hanging for a
>> >few minutes on regular cycles. For some reason when the datasourcelife
>> >expires on my Oterro data sources and Tango drops the connection, it
causes
>> >the Tango service to hang between 3 and 8 minutes. Everything works fine,
>> >users are not dropped, just all Tango services stop for that time period,
>> >and the Tango users get very annoyed. All other services on the server
run
>> >fine during this time.
>> >
>> >I have found a workaround for the problem by changing my datasourcelife to
>> >1440 minutes, and I am going to stop and restart the tango service every
>> >night.
>> >
>> >Tech Support at RBTI beleives that it is a setting or several on my
system,
>> >and that this is not a common problem.
>> >
>> >Thanks everyone for your input,
>> >
>> >Troy Sosamon
>> >Denver, Co.
>> >
