How to end the long running process

[Former Member]

Dear All,

In Db13 the UpdateStats is showing running code 9999

in sm37 it is showing active.

sm50 and sm66 it is running

There are no lock entrys and update under by there job.

Please suggest how to end the process.

1 SM50 or in sm37

Regards,

Kumar

[shabeer · Accepted solution]

Since when it is running..?

[Former Member · Accepted solution]

Hi,

It is running time.

BGD 4824 hold RFC Yes 31332

 Appx 9 hr SAPLSXPT

600 BASIS

Regards,

Kumar

[shabeer · Accepted solution]

Can you check the CPU utilization.. also check SM58 any entries are there??

[Former Member · Accepted solution]

Hi,

CPU utilization 30 % and SM58 there is no entries

Regards,

Kumar

[Former Member · Accepted solution]

Hi Kumar,

If you want to kill the process then you can use one of these SM50 or sm37.

Some times sm37 it will not work then kill in sm50.

SM37->Select the job->stop active job

sm50-> select the process then from menu process->cancel without core.

Regards

Ashok

[fidel_vales · Accepted solution]

Hi,

you have started the statistics calculation with BRCONNECT (DB13)

Then you can use also BRCONNECT to stop it.

As usual, in the documentation we can find information:

BRCONNECT -f stats

There you can find all the options for the -f stats function.

You are interested in the "-u" option:

 
-u|-run: lets you stop or suspend  the current run of update statistics or validation of table or index structures.

Input syntax: -u|-run stop|suspend|resume

Default:

¡        stop: Cleanly stops processing. The table or index currently being processed is completed but no further tables or indexes are processed. It might take some time to finish processing the current table or index if it is large.

¡        suspend: Suspends processing. It might take some time to finish processing the current table or index if it is large.

¡        resume: Resumes processing that has been suspended.

You normally perform these actions in parallel in a separate command window from the current run of update statistics or validation of table or index structures.