Friday, 10 January 2020

issue : ASE user connection

issue:
ASE user connection
Use cases:

 1. If it is ASE installation  2. If App+DB are on same host or it is a Business Suite Installation. how to verify:
"1. Switch to syb<SID> and check the log in the file below: /sybase/<SID>/ASE16-0/install/<SID>.log 2. Error will be in below format: Number of connections exceeded" Solution:
"1. Switch to syb<SID> 2. login to isql: isql -Usapsa -S<SID> -X go 2. Change user connections: sp_configure ""number of user connections"",375 go "

No comments:

Post a Comment