Maxdb Update Statistic wonu00B4t work

[steven_bier]

Hello,

i couln´t update the Optimizer statistics on a ECC 5.0 with MaxDB 7.5.00.32

In db13 i start

Check optimizer statistics

i get this message by a lot of the entrys -> NOT OK (100%) > set TOBDO

so i refresh

Optimizer/space statistics

but nothing happen by Check optimizer statistics the same Entrys -> NOT OK (100%) > set TOBDO

Thanks.

regards

Steven

[steven_bier]

No this Note doesn´t help.

I check and refresh the optimizer statistic serveral times.

But there is always the same Problem

example:

/SAPDMC/LSCDOCU ( 25, 1) > NOT OK (-96%) > set TOBDO (initial)

/SAPDMC/LSCPROGS ( 40, 1) > NOT OK (-98%) > set TOBDO (initial)

/SAPDMC/LSCRULE ( 15, 1) > NOT OK (-93%) > set TOBDO (initial)

/SAPDMC/LSCSTEPS ( 62, 1) > NOT OK (-98%) > set TOBDO (initial)

/SAPDMC/LSCSTEPT ( 2, 3) > NOT OK (50%) > set TOBDO

/SAPDMC/LSCVERSN ( 20, 1) > NOT OK (-95%) > set TOBDO (initial)

/SAPDMC/LSGBDC ( 1, 2) > NOT OK (100%) > set TOBDO (initial)

/SAPDMC/LSGPRO ( 15, 1) > NOT OK (-93%) > set TOBDO (initial)

/SAPDMC/LSOATT ( 1, 2) > NOT OK (100%) > set TOBDO

regards

steven

[steven_bier]

Hi,

yes it is.

Start Update Statistik (REFRESH_ESTIMATE) : Wed May 11 13:39:12 2011

SAP DB KERNEL VERSION : Kernel 7.5.0 Build 032-123-111-699

trace level = 1

high_calc = +50%, low_calc = -40%

1. a lot of entrys

executed : 3597 tables UPD STAT COLUMN : 0 tables

UPD STAT errors : 0 tables UPD STAT TABLE : 3597 tables

UPD STAT excluded : 0 tables

End Update Statistik (REFRESH_ESTIMATE), rc = 0 : Wed May 11 13:39:59 2011

regards Steven

[janlars_goedtke]

Perhaps note [958182|https://websmp230.sap-ag.de/sap(bD1kZSZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=958182] give some hints?

[janlars_goedtke]

Hi,

is there anything in the DB13 Protocols like

-

---

Start Update Statistik (REFRESH_ESTIMATE) : Wed May 11 14:22:24 2011

-

---

DATABASE : SAPLCP@loelcpci-LCP

MAXDB version : Kernel 7.8.01 Build 019-121-240-514

trace level : 0

-

---

executed : 0 tables | UPD STAT COLUMN : 0 tables

UPD STAT errors : 0 tables | UPD STAT TABLE : 0 tables

UPD STAT excluded : 0 tables |

-

---

End Update Statistik (REFRESH_ESTIMATE), rc = 0 : Wed May 11 14:22:26 2011

-

---

Regards

Jan