We have a PowerBuilder app PB17 LTR which talks to SAP SQL Anywhere 17.
The app is running on a VM Server running Remote Desktop Services with upwards of 50+ users.
The database is running on a separate VM Server dedicated to the Database
The IT department which manages the operation has reported intermittent cases where users are disconnected mid app with the -308 disconnect error .
With the help of SAP IT they have configured Server and Client Logs.
Searching the logs they found the following
“The number of prefetch rows has been reduced to 5 due to the prefetch buffer limit. Increasing the PrefetchBuffer connection parameter may improve performance.”
Does anyone have experience with dealing with disconnects - and did modifying the prefetch buffer change anything?
Are there any other techniques we can use to eliminate disconnects or trap the disconnect when it occurs?
The code is in my framework but the framework is free & open source under the Apache 2.0 license agreement. You're free to use the framework or extract any code for your framework or your application's use.
The main code is implemented in the SQLCA base ancestor "ns_sqlca_master" located in the std_fc_base.pbl library. Please let me know if you need any help implementing the code in your environment.
Regards ... Chris