in my work we have a software system based on sybase adaptive server any where version 6 installed on a windows server 2008. the system work fine but after a period of time from system start problems starts [this period of time is variable may be hour may be day ... the maximum stability period was one week] the problem is:
the logged in users to system stay connected but newly opened PCs the system can't login and the odbc data sources window appears and a message can't find the server. this problem tell now and as i know has only one solution is to reboot the sql engine or reboot the windows server 2008 system, this is so terrible because all connected PCs will stop the system and this may be in the middle of payment operations and so on...
we called the technical support of the system they can do nothing except clearing the log as it reached 21 MB and they sayed that is very large amount of data in log when he cleared the log system stayed one week stable but now it started stopping again.
also they mentioned that it might be because of cash memory in parameter -c150MB they tried 300 instead of 150 and 120 but noway, i tried to add the parameter -ti1400 to stop automatic disconnecting after period of idle time i expanded it to about 24 hours!!
what shall i do to solve this??