RC 100 Update all optimizer stats

[Former Member]

Hello All and Natalia,

I got the answer from Natalia for rc 100 error in update stat.

https://forums.sdn.sap.com/thread.jspathreadID=447045&messageID=3622442#3622442

But it will be great if there is way to solve it without patching.

Can somebody let me know if it is possible to solve without patching.

Thanks in advance.

Regards,

Tushar

[Former Member · Accepted solution]

Hello All / Natalia,

I have already raised OSS message 597530.

I am informing this to avoid confusion Thanks

Regards,

Tushar

[former_member229109 · Accepted solution]

Hello Tushar,

-> You reported the problem at

"Update statistic failed for livecache.Can some body help to find out the cause.

-

---

Start Update Statistik (CREATE_ESTIMATE) : Sun Jun 17 02:00:19 2007

-

---

DATABASE : SAPOGD@mou094-OGD

MAXDB version : Kernel 7.6.01 Build 009-123-141-487

trace level : 0

UPDATE STAT "SAPOGD"."/SAPAPO/OM_LCPROFDATA" ESTIMATE , rc = 0

UPDATE STAT "SAPOGD"."/SAPAPO/OM_UPL" ESTIMATE , rc = 0

UPDATE STAT "SAPOGD"."/SAPAPO/ORDKEY" ESTIMATE , rc = 0

UPDATE STAT "SAPOGD"."/SAPAPO/ORDMAP" ESTIMATE , rc = 0

UPDATE STAT "SAPOGD"."/SAPAPO/STOCKANC" ESTIMATE , rc = 0

UPDATE STAT "SAPOGD"."/SAPAPO/UPGR_LC_ANCH" ESTIMATE , rc = 0

UPDATE STAT "SAPOGD"."LCAALERTS" ESTIMATE , rc = 0

UPDATE STAT "SAPOGD"."MATRIXINDEXTAB" ESTIMATE , rc = 0

UPDATE STAT "SAPOGD"."MMRP_DATEVECS" ESTIMATE , rc = 0

UPDATE STAT "SAPOGD"."RPM_PERF_DATA" ESTIMATE , rc = 0

UPDATE STAT "SAPOGD"."RPM_PLAN_FILE" ESTIMATE , rc = 0

-

---

executed : 11 tables | UPD STAT COLUMN : 0 tables

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

UPD STAT excluded : 0 tables |

-

---

End Update Statistik (CREATE_ESTIMATE), rc = 100 : Sun Jun 17 02:00:22 2007 "

I checked with you that you have on your system

'DBSDBSLIB : version 700.08, patch 0.095 (Make PL 0.95)'.

=> The update statistics was finished without errors: "UPD STAT errors : 0 tables".

And I wrote you at that thread:

"in liveCache, the user SAPOGD has more as one schema: SAPOGD, ....

The schema SAPOGD contains 11 tables while the others are empty.

The rc=100, which means 'Row not found', comes from the select statement for the another schemas which does not contain a table. This is a problem in the dbsl code and needs to be repaired. The error will be corrected in a future patch.

In the meantime, please ignore the rc=100 error. This problem is only a 'display' problem. The update statistics in liveCache is done correctly."

&&

I recommended you to apply the SP note 1041547, where the "Symptom" & "Reason and Prerequisites" are described and Solution is provided.

-> Please follow up with SAP OSS message 597530/2007 if you have further questions to be discussed.

Thank you and best regards, Natalia Khlopina

[Former Member]

Hello Natalia,

Thanks a lot.

Your reply is always informative

Regards,

Tushar