IDS 12.10.FC14
Solaris 10 1/13
It is only in the last few months that I have had to pay much attention to smart blobs. I admit that makes me an antedeluvian troglodyte.
Below is part of the output of 'oncheck -pe' for a particular sbspace in one of our systems:
Are all those hdr entries just left over from sblobs that once actually occupied space in this sbspace?
IOW, do I conclude that all these chunks (4, 5, 6, 7, 11, 12) are now completely empty of LOs, and I can those chunks?
Thank you.
DG
Output from oncheck -pe:...Chunk Pathname Pagesize(k) Size(p) Used(p) Free(p)
4 /opt/informix/rdsk/z_sbs1_chunk 2 5242880 see below see below
Description Offset(p) Size(p)
------------------------------------------------------------- -------- --------
RESERVED PAGES 0 2
CHUNK FREELIST PAGE 2 1
SBLOBSpace FREE USER DATA (AREA 1) 3 2444992
SBLOBSpace FREE META DATA 2444995 352892
SBLOBSpace RESERVED USER DATA (AREA 2) 2797887 524286
SBLOBSpace FREE USER DATA (AREA 2) 3322173 1920707
Total Used: 3
Total SBLOBSpace FREE META DATA: 352892
Total SBLOBSpace FREE USER DATA: 4889985
Chunk Pathname Pagesize(k) Size(p) Used(p) Free(p)
5 /opt/informix/rdsk/photo_sbs1-test 2 2098176 see below see below
Description Offset(p) Size(p)
------------------------------------------------------------- -------- --------
RESERVED PAGES 0 2
CHUNK FREELIST PAGE 2 1
SBLOBSpace FREE USER DATA (AREA 1) 3 978466
blob_sbs:'informix'.LO_hdr_partn 978469 61364
blob_sbs:'informix'.LO_ud_free 1039833 32600
blob_sbs:'informix'.LO_hdr_partn 1072433 28778
blob_sbs:'informix'.LO_ud_free 1101211 9068
blob_sbs:'informix'.LO_ud_free 1110279 2591
SBLOBSpace FREE META DATA 1112870 6840
SBLOBSpace FREE USER DATA (AREA 2) 1119710 978466
Total Used: 134404
Total SBLOBSpace FREE META DATA: 6840
Total SBLOBSpace FREE USER DATA: 1956932
Chunk Pathname Pagesize(k) Size(p) Used(p) Free(p)
6 /opt/informix/rdsk/photo_sbs1-test 2 4194304 see below see below
Description Offset(p) Size(p)
------------------------------------------------------------- -------- --------
RESERVED PAGES 0 2
CHUNK FREELIST PAGE 2 1
SBLOBSpace FREE USER DATA (AREA 1) 3 1955991
blob_sbs:'informix'.LO_hdr_partn 1955994 184094
blob_sbs:'informix'.LO_hdr_partn 2140088 28779
blob_sbs:'informix'.LO_hdr_partn 2168867 69446
SBLOBSpace FREE USER DATA (AREA 2) 2238313 1955991
Total Used: 282322
Total SBLOBSpace FREE META DATA: 0
Total SBLOBSpace FREE USER DATA: 3911982
Chunk Pathname Pagesize(k) Size(p) Used(p) Free(p)
7 /opt/informix/rdsk/photo_sbs1-test 2 12582912 see below see below
Description Offset(p) Size(p)
------------------------------------------------------------- -------- --------
RESERVED PAGES 0 2
CHUNK FREELIST PAGE 2 1
SBLOBSpace FREE USER DATA (AREA 1) 3 5868001
blob_sbs:'informix'.LO_hdr_partn 5868004 51206
blob_sbs:'informix'.LO_hdr_partn 5919210 42062
blob_sbs:'informix'.LO_ud_free 5961272 13583
blob_sbs:'informix'.LO_hdr_partn 5974855 76705
blob_sbs:'informix'.LO_hdr_partn 6051560 13716
blob_sbs:'informix'.LO_hdr_partn 6065276 48006
blob_sbs:'informix'.LO_hdr_partn 6113282 27432
blob_sbs:'informix'.LO_hdr_partn 6140714 71912
blob_sbs:'informix'.LO_hdr_partn 6212626 13716
blob_sbs:'informix'.LO_hdr_partn 6226342 28779
blob_sbs:'informix'.LO_hdr_partn 6255121 28778
blob_sbs:'informix'.LO_hdr_partn 6283899 48006
blob_sbs:'informix'.LO_hdr_partn 6331905 27432
blob_sbs:'informix'.LO_hdr_partn 6359337 28779
blob_sbs:'informix'.LO_hdr_partn 6388116 28778
blob_sbs:'informix'.LO_hdr_partn 6416894 13716
blob_sbs:'informix'.LO_hdr_partn 6430610 57530
blob_sbs:'informix'.LO_hdr_partn 6488140 13716
blob_sbs:'informix'.LO_hdr_partn 6501856 48006
blob_sbs:'informix'.LO_hdr_partn 6549862 28779
blob_sbs:'informix'.LO_hdr_partn 6578641 28778
blob_sbs:'informix'.LO_hdr_partn 6607419 71912
SBLOBSpace FREE META DATA 6679331 35579
SBLOBSpace FREE USER DATA (AREA 2) 6714910 5868002
Total Used: 811330
Total SBLOBSpace FREE META DATA: 35579
Total SBLOBSpace FREE USER DATA: 11736003
Chunk Pathname Pagesize(k) Size(p) Used(p) Free(p)
11 /opt/informix/rdsk/photo_sbs1_newchunk-test 2 3500000 see below see below
Description Offset(p) Size(p)
------------------------------------------------------------- -------- --------
RESERVED PAGES 0 2
CHUNK FREELIST PAGE 2 1
SBLOBSpace FREE USER DATA (AREA 1) 3 1632203
blob_sbs:'informix'.LO_hdr_partn 1632206 172589
SBLOBSpace FREE META DATA 1804795 63002
SBLOBSpace FREE USER DATA (AREA 2) 1867797 1632203
Total Used: 172592
Total SBLOBSpace FREE META DATA: 63002
Total SBLOBSpace FREE USER DATA: 3264406
Chunk Pathname Pagesize(k) Size(p) Used(p) Free(p)
12 /opt/informix/rdsk/photo_sbs1_newnewchunk-test 2 1000000 see below see below
Description Offset(p) Size(p)
------------------------------------------------------------- -------- --------
RESERVED PAGES 0 2
CHUNK FREELIST PAGE 2 1
SBLOBSpace FREE USER DATA (AREA 1) 3 466333
SBLOBSpace FREE META DATA 466336 67330
SBLOBSpace FREE USER DATA (AREA 2) 533666 466334
Total Used: 3
Total SBLOBSpace FREE META DATA: 67330
Total SBLOBSpace FREE USER DATA: 932667
------------------------------
David Grove
------------------------------
#Informix