Tcode DB02 all the values showing zero (0)

[Former Member]

Hi Oracle-experts!

I have recently executed the upgrade from 4.6C to ECC 6.0.

I have the following errors after that:

<b>Tcode DB02: by entering the Tcode all the values are showing the zero (0).</b>If I try to refresh the values the background job "space statistic:Default" is starting and canceling after while with "SAPOSCOL short dump" (compute bcd overflow).

<b>Also I have a lot of red messages in TCode dbacockpit.

How can I fix them? </b>

Thank you very much

regards

Axel

[Former Member]

Hi Axel,

If you get short dump when refresh the data in DB02, than you need to delete the historical data base on notes:

997535 DB02 problem with history data

This solve my problem when last time I do upgrade to ECC6.

Hope this help.

Regards,

Fendi Suyanto

[Former Member]

Hello Alex,

you have to apply also the following note:

Note 1080761 - Changes to some fields of structure db02n_data

Best regards

K.Baran

[Former Member]

This SAP note is also important:

1002840 - No data or obsolete data in DB Space Statistic monitor

K.Baran

[Former Member]

Die Table ORA_MON_DBCON should contain at least the local database.

e.g.

CON NAME DEFAULT

STATUS A

MAX RUNTIME 1.800

MAX UPLOAD 1.000.000

LOG LIFE 100

DESCRIPTION Local Oracle database

Check all points in the SAP Note 1002840 - No data or obsolete data in DB Space Statistic monitor. This note is very important for this problem.

Best regards

K.Baran

[Former Member]

Hello Axel,

did you implement following notes?

1042725

1046668

1052909

706927

Best regards

K.Baran

[markus_doehr2]

Hi Axel,

Check the following notes:

Note 1019567 - Corrections for new operating system monitor

Note 1066044 - COMPUTE_BCD_OVERFLOW during DB02N refresh

Also check if you're using the latest (and greatest) SAPOSCOL for your platform.

--

Markus