Skip to Content
1
Former Member
Sep 24, 2014 at 08:58 AM

DB2 tablespace 97 % full but auto extended is still not working

199 Views

Hi Professionals,

In our quality system all table-space are In almost full. Its showing 97% ...

But still auto extended is not working. Can any one explain me that,how to check that all.I am attaching one excel file of all table space from DBACOCKPIT ,Please find it.

And what is pending free pages column. what meaning of this.

TABLE SPACE Tablespace Name TS Type KB Total Percent Used KB Free Page Size (KB) High-Water Mark (KB) No. Containers Contents TS State AUTORESIZE Pending Free Pages PSAPTEMP16 SMS 64 100 0 16 0 4 Temporary objects Normal NO 0 SAPEVENTMON DMS 56,320 98.52 832 16 55,360 4 Large objects Normal YES 0 SAPTOOLS DMS 22,593,408 74.79 1,893,760 16 21,531,232 4 Large objects Normal YES 237,574 SD1#BTABD DMS 2,064,384 99.16 17,440 16 2,046,816 4 Large objects Normal YES 0 SD1#BTABI DMS 688,128 98.64 9,376 16 682,304 4 Large objects Normal YES 0 SD1#CLUD DMS 32,768 80.69 6,304 16 26,336 4 Large objects Normal YES 0 SD1#CLUI DMS 32,768 30.78 22,592 16 10,464 4 Large objects Normal YES 0 SD1#DDICD DMS 3,833,856 99.77 8,736 16 3,824,992 4 Large objects Normal YES 0 SD1#DDICI DMS 950,272 97.32 25,504 16 926,784 4 Large objects Normal YES 0 SD1#DIMD DMS 32,768 25.29 24,384 16 8,256 4 Large objects Normal YES 0 SD1#DIMI DMS 32,768 25.29 24,384 16 8,256 4 Large objects Normal YES 0 SD1#DOCUD DMS 32,768 79.31 6,752 16 25,888 4 Large objects Normal YES 0 SD1#DOCUI DMS 32,768 72.25 9,056 16 24,000 4 Large objects Normal YES 0 SD1#EL731D DMS 18,644,992 99.84 29,184 16 18,615,680 4 Large objects Normal YES 0 SD1#EL731I DMS 98,304 94.07 5,824 16 92,352 4 Large objects Normal YES 0 SD1#ES731D DMS 19,897,472 99.93 13,984 16 19,883,360 4 Large objects Normal YES 0 SD1#ES731I DMS 14,942,208 84.28 1,042,784 16 14,910,016 4 Large objects Normal YES 81,616 SD1#FACTD DMS 32,768 25.29 24,384 16 8,256 4 Large objects Normal YES 0 SD1#FACTI DMS 32,768 25.29 24,384 16 8,256 4 Large objects Normal YES 0 SD1#LOADD DMS 32,768 35.1 21,184 16 11,456 4 Large objects Normal YES 0 SD1#LOADI DMS 32,768 30.39 22,720 16 9,920 4 Large objects Normal YES 0 SD1#ODSD DMS 32,768 25.29 24,384 16 8,256 4 Large objects Normal YES 0 SD1#ODSI DMS 32,768 25.29 24,384 16 8,256 4 Large objects Normal YES 0 SD1#POOLD DMS 6,684,672 99.62 25,152 16 6,659,392 4 Large objects Normal YES 0 SD1#POOLI DMS 4,325,376 96.27 142,112 16 4,276,448 4 Large objects Normal YES 1,190 SD1#PROTD DMS 655,360 97.29 17,728 16 637,504 4 Large objects Normal YES 0 SD1#PROTI DMS 98,304 81.26 18,400 16 87,072 4 Large objects Normal YES 0 SD1#SOURCED DMS 229,376 95.13 11,168 16 218,080 4 Large objects Normal YES 0 SD1#SOURCEI DMS 294,912 96.23 11,104 16 283,680 4 Large objects Normal YES 0 SD1#STABD DMS 5,013,504 99.95 2,464 16 5,010,912 4 Large objects Normal YES 0 SD1#STABI DMS 2,686,976 97.56 27,232 16 2,661,280 4 Large objects Normal YES 2,392 SD1#USER1D DMS 32,768 25.88 24,192 16 8,448 4 Large objects Normal YES 0 SD1#USER1I DMS 32,768 26.18 24,096 16 8,544 4 Large objects Normal YES 0 SQ1#BTABD DMS 2,064,384 98.83 24,096 16 2,040,160 4 Large objects Normal YES 0 SQ1#BTABI DMS 851,968 98.44 13,248 16 847,424 4 Large objects Normal YES 0 SQ1#CLUD DMS 32,768 69.22 10,048 16 22,592 4 Large objects Normal YES 0 SQ1#CLUI DMS 32,768 30.39 22,720 16 9,920 4 Large objects Normal YES 0 SQ1#DDICD DMS 3,801,088 99.83 6,304 16 3,794,656 4 Large objects Normal YES 0 SQ1#DDICI DMS 1,048,576 94.99 52,480 16 1,047,072 4 Large objects Normal YES 0 SQ1#DIMD DMS 32,768 25.29 24,384 16 8,256 4 Large objects Normal YES 0 SQ1#DIMI DMS 32,768 25.29 24,384 16 8,256 4 Large objects Normal YES 0 SQ1#DOCUD DMS 32,768 78.53 7,008 16 25,632 4 Large objects Normal YES 0 SQ1#DOCUI DMS 32,768 73.04 8,800 16 23,840 4 Large objects Normal YES 0 SQ1#EL731D DMS 18,284,544 99.96 7,264 16 18,277,152 4 Large objects Normal YES 0 SQ1#EL731I DMS 65,536 60.81 25,632 16 49,152 4 Large objects Normal YES 0 SQ1#ES731D DMS 20,021,248 99.9 20,896 16 20,000,224 4 Large objects Normal YES 0 SQ1#ES731I DMS 17,760,256 66.37 5,972,000 16 17,739,808 4 Large objects Normal YES 94 SQ1#FACTD DMS 32,768 25.29 24,384 16 8,256 4 Large objects Normal YES 0 SQ1#FACTI DMS 32,768 25.29 24,384 16 8,256 4 Large objects Normal YES 0 SQ1#LOADD DMS 32,768 33.92 21,568 16 11,072 4 Large objects Normal YES 0 SQ1#LOADI DMS 32,768 29.61 22,720 16 9,920 4 Large objects Normal YES 16 SQ1#ODSD DMS 32,768 25.49 24,320 16 8,320 4 Large objects Normal YES 0 SQ1#ODSI DMS 32,768 25.59 24,288 16 8,352 4 Large objects Normal YES 0 SQ1#POOLD DMS 5,767,168 99.62 21,824 16 5,745,216 4 Large objects Normal YES 0 SQ1#POOLI DMS 3,833,856 98.23 66,912 16 3,803,680 4 Large objects Normal YES 58 SQ1#PROTD DMS 688,128 99.46 3,712 16 684,288 4 Large objects Normal YES 0 SQ1#PROTI DMS 196,608 34.51 126,752 16 127,936 4 Large objects Normal YES 120 SQ1#SOURCED DMS 229,376 92.48 17,248 16 212,000 4 Large objects Normal YES 0 SQ1#SOURCEI DMS 294,912 90.46 28,128 16 267,232 4 Large objects Normal YES 0 SQ1#STABD DMS 4,325,376 99.94 2,624 16 4,322,624 4 Large objects Normal YES 0 SQ1#STABI DMS 2,850,816 96.63 93,152 16 2,834,848 4 Large objects Normal YES 190 SQ1#USER1D DMS 32,768 25.69 24,256 16 8,384 4 Large objects Normal YES 0 SQ1#USER1I DMS 32,768 25.88 24,192 16 8,448 4 Large objects Normal YES 0 SYSCATSPACE DMS 4,620,288 99.77 10,496 16 4,609,664 4 Regular data Normal YES 0 SYSTOOLSPACE DMS 98,304 66.82 32,576 16 65,600 4 Large objects Normal YES 0 SYSTOOLSTMPSPACE SMS 64 100 0 16 0 4 Temporary objects Normal NO 0

Thanks & Regards,

Bhipra Sakti