ASA SQL User's Guide
Accessing Remote Data
Troubleshooting remote data access
If you access multiple databases on a single Adaptive Server Anywhere server, you may need to increase the number of threads used by the database server on Windows using the -gx command-line switch.
You must have enough threads available to support the individual tasks that are being run by a query. Failure to provide the number of required tasks can lead to a query becoming blocked on itself.