Skip to Content
avatar image
Former Member

DB16 is giving Error Messages for a ztables

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Jul 28, 2010 at 04:44 AM

    Hi Eric ,

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

    Ram.

    Add comment
    10|10000 characters needed characters exceeded

    • 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.

  • Jul 27, 2010 at 12:25 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded