DB16 is giving Error Messages for a ztables

[former_member440650]

Hello,

I created many ztable and transported to Quality,Production respectively.But for some table's i am getting following error

Missing_statistics Table: SAPRQS.ZMES_PQTC_CODE # Table or index has no optimizer statistics.

Now my questions are

1) For the above table there is no error in Development but exists in Quality and for another table there is error in Development

but not in Quality/production.

2)Why only for some tables(not all) this error is coming.

3) Is this issue related to Abap or administrator.This will cause any inconsitensies in production ?

4) Solution for the above problem.

I am a ABAP developer,d'nt have knowledge of basis adminstrator.

Ram.

[former_member440650 · Accepted solution]

Hi Eric ,

Thanks for ur reply , i want to know why this error comes....any prerequisites to be taken to avoid this message.

Ram.

[former_member204746 · Accepted solution]

statistics were not calculated on that table when DB13-checkDB ran.

to fix this annoying warning, always run a DB13-UpdateStats job just before running DB13-CheckDB.

Good luck.

[former_member204746]

at Os level, as user ora[sid]for Unix... or [sid]adm on Windows:

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

This should fix your issue.