Environment
Novell GroupWise 7.0.1
Microsoft Windows 2003
Microsoft Windows 2003
GRoupWise Mobile Server (GMS)
Situation
Using SQL as the database performance on GMS server is slow to
process updates from the POA.
See a large build up of temp files in the C:/windows/temp directory on the server.
See a large build up of temp files in the C:/windows/temp directory on the server.
Resolution
Please
follow the instructions below to prevent the creation of jtds*.tmp
files. These steps must be carried out for each server in your
cluster if you have an Intellisync Mobile Suite cluster
setup.
First, go to http://localhost/diag/webinfo.asp and find the value for the Connection String. Make a note of this value. It should look similar to, but not exactly like:
jdbc:jtds:sqlserver://LANSQL:1433/Intellisync Mobile Suite
Next, open the registry editor and go to:
[HKEY_LOCAL_MACHINE\SOFTWARE\Synchrologic\Portal\Manager]
For the Manager key, create a new string value named "dsnOverride" with the data set to the following with dblocation replaced by the value for Connection String obtained from the diag pages:
dblocation;lobBuffer=9223372036854775806
As an example, the string should look similar to, but not exactly like:
jdbc:jtds:sqlserver://LANSQL:1433/Intellisync Mobile Suite;lobBuffer=9223372036854775806
After you create this key, stop the Intellisync Mobile Suite service. Then go into your temp directory and delete all jtds files. When the files have been deleted, start the Intellisync Mobile Suite service and you should no longer see any jtds files being created. Remember this procedure needs to be carried out for each machine in your cluster if you have an Intellisync Mobile Suite cluster setup.
First, go to http://localhost/diag/webinfo.asp and find the value for the Connection String. Make a note of this value. It should look similar to, but not exactly like:
jdbc:jtds:sqlserver://LANSQL:1433/Intellisync Mobile Suite
Next, open the registry editor and go to:
[HKEY_LOCAL_MACHINE\SOFTWARE\Synchrologic\Portal\Manager]
For the Manager key, create a new string value named "dsnOverride" with the data set to the following with dblocation replaced by the value for Connection String obtained from the diag pages:
dblocation;lobBuffer=9223372036854775806
As an example, the string should look similar to, but not exactly like:
jdbc:jtds:sqlserver://LANSQL:1433/Intellisync Mobile Suite;lobBuffer=9223372036854775806
After you create this key, stop the Intellisync Mobile Suite service. Then go into your temp directory and delete all jtds files. When the files have been deleted, start the Intellisync Mobile Suite service and you should no longer see any jtds files being created. Remember this procedure needs to be carried out for each machine in your cluster if you have an Intellisync Mobile Suite cluster setup.