Work Process Increase

[Former Member]

Dear All,

I have installed ERP 6.0 EHP6 system Dev and Quality and production (cluster) Environments,after installing in each server default no of work process is in each server are below.

Dialog -9

Enquee-1

Upd-1

UP2-1

Spool-1

Background -3

Now I am planning to increase the update work process and background work process through RZ10 ,because my developers are saying while activating smartfroms system will taking time while activating the smart forms.

Please suggest whats the criteria of increase the work process can i directly increase in RZ 10 and restart the instance .

Please suggest and guide me

Thanks

[hedvig_rohonyi]

Hi,

in most cases the reason for long SmartForms generation is a extremely slow access to the table D010INC.

The problem may be because the database statistics of table D010INC are not up to date.

Please update the statistics of the the table D010INC and then try the action again.  If this not help please attach screenshot from SM50 where we can see the affected table (TRDIR,  WBCROSSGT, ...).

By the way note 1010375 contains some recommandations which can be used to decrease the

activation time.

Best regards,

Hedvig

[Former Member]

Hi Hedvig,

Thanks for the helpful information,I am using sybase database how can we assume database table statistics are not up to date where we can we check .

If i run update stats command while running the system is their any impact in the system.

Please suggest and guide me its very helpful for me

Thanks

[hedvig_rohonyi]

Hi Team,

I am not familiar with SYbase, but as I know  for other case the following steps  help to
improve the performance:

Suggestion should be to run the "update index" command:

login using SAPSR3 by using isql tool -> isql -S<SID> -Usapsr3

in case of e.g. REPOSRC

use <DATABASE>
go
update index statistics REPOSRC
go

Please schedule "update index statistics REPOSRC" on regular bases.

Additionally, please review the recommendations in the pdf attachment of note 1722359. It contains detailed description of the SAP Best Practices for memory and cache configuration.

By my guess this issue needs to be checked by to colleagues from the database SYBASE.

Best regards,

Hedvig