Skip to Content
0

Update stats for a locked table

Aug 01, 2017 at 03:05 PM

44

avatar image
Former Member

Hello All,

Customer requested us to run the update stats for ARFCSSTATE table.

We could see statistics are locked in DB20 ,

also we could not able run at os level. we executed the below command

brconnect -c -u / -f stats -t SAPSR3.ARFCSSTATE -f collect -p 4

Could you please let us know how to run the stats for this table and give the correct command to run..

Regards

S.subramani

4izea.png (2.6 kB)
quf4u.png (110.0 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

James Zhang
Aug 02, 2017 at 01:03 AM
0

Hi,

I believe the table statistics was locked on purpose, see SAP note 1020260.
SAP note 1020260 is very famous for performance tuning, so please not to voliate the note without strong reason.


However if you really want to update the locked table, please try:

  • brconnect -u / -c -f stats -t <table> -f collect,allsel,keep,locked

    Best regards,
    James
Share
10 |10000 characters needed characters left characters exceeded