Skip to Content
avatar image
Former Member

Update stats for a locked table

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Aug 02, 2017 at 01:03 AM

    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
    Add comment
    10|10000 characters needed characters exceeded