SAP Knowledge Base Article - Preview

3365860 - ASE is terminating this isql process

Symptom

  • The <server>.bak file has the syb_default pool and syb_blocking pool in the following order:

[Thread Pool:syb_default_pool]
        number of threads = 4
        idle timeout = 100

[Thread Pool:syb_blocking_pool]
        number of threads = 4

  • Making a config change in ASE 

sp_configure "number of locks", 5000
go

  • Rebooting ASE after making change,  The syb_blocking_pool and syb_thread_pool changes position

[Thread Pool:syb_blocking_pool]
        number of threads = 4

[Thread Pool:syb_default_pool]
        number of threads = 4
        idle timeout = 100

  • If no configuration change is made and ASE is rebooted.  The pools do not change position


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 16.0

Product

SAP Adaptive Server Enterprise 16.0

Keywords

syb_default_pool, syb_blocking_pool, CR 828294, 828294, CR828294 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Product Enhancement

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.