cancel
Showing results for 
Search instead for 
Did you mean: 

I need to change the number of parallel threads of brconnect on the fly

symon_braunbaer
Participant
0 Kudos

Dear Experts,

today (Friday) in the afternoon, I have to start the export of an SAP system with SWPM.

Yesterday (Thursday) in the afternoon, I have started full calculation of statistics,

which has to be done before the export. I decided to use 5 parallel threads, in order

to not pose a high load on the system and disturb the business operations.

I have checked now, and the estimated end time of the calculation is around Saturday

noon !!!!!!!!!!!!

Please kindly advise if I can change the number of parallel threads to 32 on the fly,

because if I abort it and launch it again, I suppose that it will start calculating

from the beginning and I will lose 18 hours of calculations already done...

Many thanks in advance!

Accepted Solutions (1)

Accepted Solutions (1)

stefan_koehler
Active Contributor
0 Kudos

Hi Symon,

> Please kindly advise if I can change the number of parallel threads to 32 on the fly, because if I abort it and launch it again, I suppose that it will start calculating from the beginning and I will lose 18 hours of calculations already done.

No you can not, but you can abort it and temporarily replace brconnect with a shell script that returns a return code 0. "Full statistic collection" is usually not needed in case of export, if you have constantly collected statistics before and have not done any huge archive (delete) runs since the last stat run. It is just a "safety net" by SAP.

Regards

Stefan

symon_braunbaer
Participant
0 Kudos

Thank you, Stefan, your answers are always helpful and qualified.

Fortunately, statistics are collected each day via a DB13 job.

I was afraid, that it's not possible to change the number of threads,

though I decided to try to ask, as unfortunately I can't know everything.

Though I would appreciate the "safety net", as this DB is quite big.

Btw. I didn't get your idea about replacing brconnect with a shell script.

Though I don't think that this would be helpful to my request.


Many thanks, once again!

stefan_koehler
Active Contributor
0 Kudos

Hi Symon,

> Btw. I didn't get your idea about replacing brconnect with a shell script. Though I don't think that this would be helpful to my request.


The brconnect run is executed to have the statistics for space calculation when running the import phase. There is no need to run a full statistics refresh, if your statistics are already up-to-date. AFAIK brconnect run is triggered by SWPM and so you skip this "unnecessary" phase successfully, if you replace brconnect with a shell script with return code 0. This is the idea behind it. By the way i also have done it several times and it worked out well every time

Regards

Stefan

Answers (1)

Answers (1)

Former Member
0 Kudos
symon_braunbaer
Participant
0 Kudos

Many thanks, all this is correct, but unfortunately it's irrelevant to my question...