DB13: Check DB. Warnings

[Former Member]

I was in two minds about where to post this - apologies if this is the wrong place.

brconnect -u / -c -f check is scheduled to run daily via DB13.

It always ends with 3 warnings.

None of these tables appear to exist.

I've looked into adding an exception into table DBDIFF but this doesn't seem to make any difference.

Log file attached.

Any pointers would be appreciated.

Thanks.

log.txt.zip

[Former Member · Accepted solution]

Hi Paul,

The screen shot shows that the tables does not exist.

Try to know the significance of those tables and drop those indexes safely.

Try running stats after dropping those indexes.

Thanks,
Pavan

[Former Member · Accepted solution]

Thanks for your help.

My lack of experience in this area is showing.

If SE14 states the tables do not exist, how can I drop them from the DB?  Is there a way using brtools perhaps?

[former_member188883 · Accepted solution]

Hi Paul,

From the screen shot It is clear that the Z* tables exist in database but are missing from SAP dictionary.

You can login to database and drop.

SQL> drop table SAPSR3.<Table name>;

Regards,

Deepak Kori

[Reagan · Accepted solution]

Before dropping any table check whether they are needed and whether they contain any data.

As these are Z tables I would check with the application team to confirm.

Regards

RB

[Former Member]

Thanks Pavan, Deepak and Reagan for your replies.

I have checked, I can drop these from the database.

I have done this and I can now run DB Check with no warnings.

Problem solved.  Many thanks.

[former_member188883]

Hi Paul,

Please check in SE14 and Oracle database whether these tables exists.

Probability is that it may exist in dictionary and not in Database or vice-versa.

If these tables are not needed drop from database as well.

Regards,

Deepak Kori

[Former Member]

Hello Paul,

I guess you are running DB statistics from DB13.

The error indicates that there are some missing indexes on you DB.

DB statistics will not be successful if you have those missing indexes.

Now, Check the missing indexes in DB02 or DB02OLD and try to rebuild them.

If they are Z indexes they should be rebuilt in SE14.

Try to execute stats after rebuilding indexes it will work.

Hope this helps.

Thanks,

Pavan

[Former Member]

Initially there were 190 warnings (missing statistics).

I ran brconnect -u / -c -f stats -t missing.

This reduced the warnings to these 3.

DB02 shows indexes are fine.

However:

Tables do not exist according to SE14 as Deepak has suggested.  Can I just drop these? If so, how do I do that?

Thanks.