Db02 data

[Former Member]

Hi,

When we will chek the table size in db we are getting one sample following output :

Object Type Tablespace KBytes Blocks Extents MaxExtents Next (K)

EKBE TABLE PSAPPCE 0 0 0 1- 0

EKBEH TABLE PSAPPCE 0 0 0 1- 0

EKBE~0 INDEX PSAPPCE 0 0 0 1- 0

But at first screen of db02 we are getting the DB Size and free size.

We have refreshed the database statistics but still it is not showing.

Our system version is SAP R/3 Enterprise.

Db is oracle 9.2.0.8.

Kindly suggest.

Regards,

Rahul.

[Former Member]

Hi Satyabrat,

Job is schduled with 1 hr frequency.

There is noany dump related to this.

We have recently upgarded our oracle 9.2.0.6 to 9.2.0.8.

Kindly suggest.

Regards,

Rahul.

[Former Member]

Hi,

Below is our patch level :

Software Component Release Level

SAP_BASIS 620 0064

SAP_ABA 620 0064

SAP_APPL 470 0022

SAP_HR 470 0045

ABA_PLUS 100 0000

EA-IPPE 200 0015

PI 2004_1_470 0009

PI_BASIS 2004_1_620 0009

ST-PI 2005_1_620 0008

EA-APPL 200 0007

EA-DFPS 200 0000

EA-FINSERV 200 0000

EA-GLTRADE 200 0000

EA-HR 200 0000

EA-PS 200 0008

EA-RETAIL 200 0000

ST-A/PI 01K_R3_470 0000.

Regards,

Rahul.

[Former Member]

Hi Rahul,

Just confirm that job "SAP_COLLECTOR_FOR_PERFMONITOR" is scheduled in your system.

Please let me know Is your system is giving any dump ??

Thanks,

Satyabrat

[Former Member]

Hi All,

Any suggestion.

Regards,

Rahul.

[Former Member]

Hi Rahul

From when you are getting this format ? did you have applied some Basis patches,

Can you let me know, what is your Basis release and patch level ?

Thanks & Regards,

Satyabrat

[Former Member]

Hi,

Can you please check Tx-code DB02_old or DB02old (Not sure but definitly one will work) which displays db2 related stuff.

If your have applied latest patches you will encounter these type of issues.

--Kishore