DBcheck failed

[Former Member]

Hello,

We are getting below warning

BR0970W Database administration alert - level: ERROR, type: MISSING_STATISTICS, object: (table) SAPR3E.SYS_JOURNAL_5950

BR0970W Database administration alert - level: ERROR, type: MISSING_STATISTICS, object: (index) SAPR3E.SYS_IOT_TOP_239448

when rerun Dbcheck it went smoothly.What are these tables .

Regards,

Raghu.

[Former Member · Accepted solution]

when I checked these table in the DB and ABAP not available.

[former_member185954 · Accepted solution]

Hello,

Check the following note:

DB02: Unknown SYS_JOURNAL* objects in the ABAP/4-Dictionary

SAP Note Number: 615413

Regards,

Siddhesh

[former_member185954 · Accepted solution]

To understand more about SYS_JOURNAL , check this note:

FAQ: Oracle Index Organized Tables (IOTs)

SAP Note Number: 641435

Regards,

Siddhesh

[Former Member]

very good answer.Solved the problem.

[former_member185954]

Glad i could help

[former_member185954]

Hello,

The note 435290 has a description of this warning condition:

21. MISSING_STATISTICS (formerly NO_OPT_STATS)

Regards,

Siddhesh