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:
  1. Log in to the SAP ASE:

    isql -S<server_name> -U<sa user name> -P<sa password>

  2. Run this command to display the current configuration value:

    sp_configure 'number of open databases'

  3. 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>.

Related tasks
Modifying Server Configuration Parameters