Update stats for a locked table

[former_member190251]

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

[JamesZ]

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