cancel
Showing results for 
Search instead for 
Did you mean: 

Tables not getting updatd after running full stats

Former Member
0 Kudos

HI Folks,


Could anyone please suggest  how to proceed  further if the full stats command brconnect -c -u / -f stats -t all –f collect -p 4 has not updated the tables in ECC system.


Regards,

Sharma TVK

Accepted Solutions (0)

Answers (3)

Answers (3)

Reagan
Advisor
Advisor
0 Kudos

What is the point in suggesting another set of commands if the one he used is not doing anything?

Are you using the latest version of the BR*Tools? If not then first update the tools. You may also look from the OS and DB level and identify whether the process is doing something.

Brindavan_M
Contributor
0 Kudos

Hello ,

may be if you give any error then it will help us to check the issue as Field vales.  mean while try the below option.

brconnect -u / -c -f stats -t all

Update statistics only for tables and indexes with missing statistics

brconnect -u / -c -f stats -t missing

Check and update statistics for all tables defined in the DBSTATC table

brconnect -u / -c -f stats -t dbstatc_tab

Thanks,

Brindavan

0 Kudos

hi,

it might be that the tables do not need to be updated.

Would you mind to share

1) the log file of the mentioned command

2) what tables you think should have been updated-

BTW, that commnad should not be use "frequently", only after upgrades (meaining change of the major version)

Former Member
Former Member
0 Kudos

also check below sapnote 1842251 - Missing or incorrect database statistic for a SAP table

Regards,

Prithviraj.