SAP ASE change CPU number after install ?

[Former Member]

Hello I've install my SAP ERP Sandbox with only 1 CPU, but after install I've added a new one, with parameter must be set to SAP ASE (sybase) to be configured with 2 CPU instead 1 ?

Thanks for your feedback

Eric

[Former Member]

Hi Eric,

In a threaded kernel to increase number of CPU's/engines, check the default thread pool configuration in your .cfg file  (located at the bottom of the file) will look like:

[Thread Pool:syb_default_pool]
        number of threads = 1

You can change it to using any editor or from isql you can increase number of threads to 2 as follows and restart ASE:

alter thread pool syb_default_pool with thread count = 2
go

http://help.sap.com/saphelp_ase1601/helpdata/en/a8/699a30bc2b1014b566e2f47b7df9c8/frameset.htm

Thanks,
Manhar

[former_member187136]

Eric,

Good day..!!!

Are you referring to the below isql command?

1> sp_engine "online", 2

2>go

Regards

Kiran K Adharapuram