Skip to Content
0
Former Member
Feb 17, 2009 at 05:53 AM

Warnings In Check DB

53 Views

In our test server we are facing a problem in check DB Job ( T-Code - DB13 )

BR0970W Database administration alert - level: WARNING, type: CRITICAL_SEGMENT, object: (table) SAPR3.SOC3, value: 2047960 KB * 2 / PSAPBTABD (> 2047992/2045392/2045392/2045392/2045392 KB)

BR0970W Database administration alert - level: WARNING, type: CRITICAL_SEGMENT, object: (table) SAPR3.TST03, value: 2047960 KB * 2 / PSAPBTABD (> 2047992/2045392/2045392/2045392/2045392 KB)

while investigating we found that tablespace - PSAPBTABD -

Tablespace Size (kb) Free (kb) Used (%)

PSAPBTABD 580.123.272 33.058.624 94

In RZ20

Segments w. too few allocatable extents -

Tablespace Exts.left Owner Segment Segm.type Next (KB)

PSAPBTABD 1 SAPR3 SOC3 TABLE 2047.960

PSAPBTABD 1 SAPR3 TST03 TABLE 2047.960

Fewest allocatable extents for a segment

Tablespace Exts.left Owner Segment Segm.type Next (KB)

PSAPBTABD 1 SAPR3 SOC3 TABLE 2047.960

PSAPBTABD 1 SAPR3 TST03 TABLE 2047.960

Can somebody guide what should I do so that we can rectified this warnings

Thanks & Regards

Shishir