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