Skip to Content
0
Former Member
Dec 02, 2009 at 01:40 PM

critical segment notification

119 Views

Hello,

Is there a way to receive on email or even better to write log to text file on hard disk - when SAP system founds space-critical objects - that can be seen in transaction DB02OLD.

Maybe some sql script whitch can I run to check for space-critical objects??

I'm asking this because until 20 months ago I had in brconnect logfile of this command "brconnect -u / -c -f check" (Check DB in DB13) sometimes lines liek this:

BR0970W Database administration alert - level: WARNING, type: CRITICAL_SEGMENT, object: (table) SAPR3./DSD/ME_DDR_BAK, value: 163840 KB * 1 / PSAPBTABD (> 163832/133120/132480/120320/106504+ KB)

BR0970W Database administration alert - level: WARNING, type: CRITICAL_SEGMENT, object: (table) SAPR3./LIME/NLOG_QUAN, value: 163840 KB * 1 / PSAPBTABD (> 163832/133120/132480/120320/106504+ KB

This was very very helpfull to be proactive and to change next extent size to lower value or to extend tablespace - and to prevent "unable to extend table/index". But, now for some reason system does not act proactive and brconnect does not "see" critical tables/indexes and that next extent will have no more space to allocate - although in DB17 critical_segment is activated

thank you,

best regards,

Igor