on 03-16-2016 8:08 AM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Please check the below link
https://help.sap.com/saphelp_nwpi711/helpdata/en/45/d59f51b3735594e10000000a1553f7/content.htm
Reagrds,
Prithviraj.
also check below sapnote 1842251 - Missing or incorrect database statistic for a SAP table
Regards,
Prithviraj.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.