DB13 DBCHECK ended with warning -pls help

[Former Member]

Hi All,

From last few days in DB13 dbcheck is showing the following warning regarding tablespace full, aur tablespaces have already been set as "AUTOEXTEND". We have few options to overcome this problem.

1) Increase the maxsize of autoextend

2) Adding a datafile to the particular TS.

Pls suggest

pls find the details of dbcheck log-:

BR0981W Not enough disk space for the total maximum size 50000.000 MB of 5 files of tablespace PSAPXXX640 on disk device 1077149698, missing

at least 21135.719 MB

BR0981W Not enough disk space for the total maximum size 50000.000 MB of 5 files of tablespace PSAPXXX640 on disk device 1077149697, missing

at least 21135.719 MB

BR0970W Database administration alert - level: WARNING, type: FILE_SYSTEM_FULL, object: /oracle/XXX/sapdata3, value: 99.94% (> 99%)

BR0970W Database administration alert - level: WARNING, type: FILE_SYSTEM_FULL, object: /oracle/XXX/sapdata4, value: 99.98% (> 99%)

BR0970W Database administration alert - level: WARNING, type: FILE_SYSTEM_FULL, object: /oracle/XXX/sapdata2, value: 99.98% (> 99%)

BR0970W Database administration alert - level: WARNING, type: FILE_SYSTEM_FULL, object: /oracle/XXX/sapdata1, value: 99.99% (> 99%)

BR0970W Database administration alert - level: WARNING, type: FILE_SYSTEM_FULL, object: /oracle/XXX/sapdata5, value: 99.87% (> 99%)

BR0970W Database administration alert - level: WARNING, type: FILE_SYSTEM_FULL, object: /oracle/XXX/sapdata6, value: 99.17% (> 99%)

BR0970W Database administration alert - level: WARNING, type: CRITICAL_FILE, object: /oracle/XXX/sapdata1/XXX640_1/ecp640.data1, value: (incr

BR0970W Database administration alert - level: WARNING, type: CRITICAL_FILE, object: /oracle/ECP/sapdata1/xxx640_2/xxx640.data2, value: (incr

BR0970W Database administration alert - level: WARNING, type: CRITICAL_FILE, object: /oracle/ECP/sapdata1/xxx640_3/xxx640.data3, value: (incr

BR0970W Database administration alert - level: WARNING, type: CRITICAL_FILE, object: /oracle/XXX/sapdata1/system_1/system.data1, value: (incr

BR0970W Database administration alert - level: WARNING, type: TABLESPACE_FULL, object: PSAPECP, value: 98.23% (> 95%)

Waiting for your quick responses

Regards,

Prashant

[Former Member]

Hi All,

To add one more thing currently all the datafiles in for PSXXX tablespace are in AUTOEXTEND MODE and parameter "INCREMENT_BY" has been defined as "2560".

Do we need to increase this value or we can directly go for adding a new datafile to this TS.There is enough disk space available in the disk approx 45.52 GB is free.

Regards,

Prashant.

[Former Member]

Hi Prashant,

First check for disk space,i think there is sortage of disk space.

Regards

Ashok

[Former Member]

Thanks Ashok,

Yes you are right disk space is also one issue ....currently we have 45.52 GB of free space do we need to go for disk space increment.

Do u think these warnings may affect/or affecting the system performance?

Regards,

Prashant

[Former Member]

Hi Prashant,

This is critical i think you should add disk space.

Regards

Ashok

[Former Member]

Thanks for ur quick reply, You mean to say We need to increase the filesystem at OS level (we are using UNIX) .Do we need to restart the SAP Server after the addition of hardware?

Regards,

Prashant

[Former Member]

Hi Prashant,

No need for that.o/s will take care of that.

Regards

Ashok

[Former Member]

Hi Ashok,

Thanks one more thing currently one of our app server is showing high dialog response time of around 12456 but CPU % Idle is showing 97% and system is very slow.

What could be the reason behind this?

I have already checked the network rate its fine plus no of users logined are also very less and there is no ZREPORT running in background...but in SM50 many work processes are showing 5-6 errors with red mark......pls suggest

Regards,

Prashant

[Former Member]

Hi Prashant,

Please check the buffer status in that application server (st02) and check if dumps are generated.

Check for database buffering in t-code st04 in your database server.

5-6 errors with red mark is showing because that may times the dialog sessaion terminated because of error.

Regards

Ashok

[Former Member]

Hi Ashok,

In ST02 for many parameters like Program buffer , CUA and export/import buffer swaps values are coming on RED mark......any comments on that? Pls suggest.

Can it affect the system performance?

Regards,

Prashant

[Former Member]

Thanks for ur suggestions

Regards

Prashant