Collection Job for SAP ASE Fails

Problem: A collection job for SAP ASE may fail when the number of open databases is too low.

Solution: Modify the value of number of open databases by using either the Server Configuration screen of the SAP Adaptive Server Enterprise monitor, or these steps:

Log in to the SAP ASE:
isql -S<server_name> -U<sa user name> -P<sa password>
Run this command to display the current configuration value:
sp_configure 'number of open databases'
Run this command to change the current configuration value:
sp_configure 'number of open databases', <number>

Add 10 to the current configuration value and substitute this number for <number>.