TABLE UNWANTED FRAGMENTATION
Posted in 1999
I did an oncheck -pe and I get the following on the temporary db space. Is
this normal. Why is the temporary db space fragmented if there are no
tables in it? Is this affecting performance?
Chunk: 12 /informix/symlinks/tempdbs1 Size Used
Free
500000 4803 495197
Disk usage for Chunk 12 Start Length
------------------------------------------- --------- ---------
OTHER RESERVED Pages 0 2
CHUNK FREE LIST PAGE 2 1
TBLSPACE TBLSPACE 3 50
FREE 53 992
TBLSPACE TBLSPACE 1045 50
FREE 1095 2144
TBLSPACE TBLSPACE 3239 50
FREE 3289 1600
TBLSPACE TBLSPACE 4889 50
FREE 4939 1600
TBLSPACE TBLSPACE 6539 50
FREE 6589 1600
TBLSPACE TBLSPACE 8189 50
FREE 8239 1600
TBLSPACE TBLSPACE 9839 50
FREE 9889 1600
TBLSPACE TBLSPACE 11489 50
FREE 11539 1600
TBLSPACE TBLSPACE 13139 50
FREE 13189 1600
TBLSPACE TBLSPACE 14789 50
FREE 14839 1600
TBLSPACE TBLSPACE 16439 50
FREE 16489 1600
TBLSPACE TBLSPACE 18089 50
FREE 18139 1600
TBLSPACE TBLSPACE 19739 50
FREE 19789 1600
TBLSPACE TBLSPACE 21389 50
FREE 21439 1600
TBLSPACE TBLSPACE 23039 50
FREE 23089 1600
TBLSPACE TBLSPACE 24689 50
FREE 24739 1600
TBLSPACE TBLSPACE 26339 100
FREE 26439 3200
TBLSPACE TBLSPACE 29639 100
FREE 29739 3200
TBLSPACE TBLSPACE 32939 100
FREE 33039 3200
TBLSPACE TBLSPACE 36239 100
FREE 36339 3200
TBLSPACE TBLSPACE 39539 100
FREE 39639 3200
TBLSPACE TBLSPACE 42839 100
FREE 42939 3200
TBLSPACE TBLSPACE 46139 100
FREE 46239 3200
TBLSPACE TBLSPACE 49439 100
FREE 49539 3200
TBLSPACE TBLSPACE 52739 100
FREE 52839 3200
TBLSPACE TBLSPACE 56039 100
FREE 56139 3200
TBLSPACE TBLSPACE 59339 100
I have one more question. I am re-creating a table so it does not get too
fragmented over time. The only problem that I have is that the informix
tables containing the statistics are in the same dbspace. Should I drop
the sys tables for the statistics, re-create the table and update
statistics again?
(The temp table will not be there in production)
THANKS
DBspace Usage Report: dbspace1 Owner: informix Created:
11/09/98
Chunk: 2 /informix/symlinks/a1_1 Size Used
Free
1000000 655503 344497
Disk usage for Chunk 2 Start Length
------------------------------------------- --------- ---------
OTHER RESERVED Pages 0 2
CHUNK FREE LIST PAGE 2 1
TBLSPACE TBLSPACE 3 50
zg_sales:informix.systables 53 8
zg_sales:informix.syscolumns 61 16
zg_sales:informix.sysindexes 77 8
zg_sales:informix.systabauth 85 8
zg_sales:informix.syscolauth 93 8
zg_sales:informix.sysviews 101 8
zg_sales:informix.sysusers 109 8
zg_sales:informix.sysdepend 117 8
zg_sales:informix.syssynonyms 125 8
zg_sales:informix.syssyntable 133 8
zg_sales:informix.sysconstraints 141 8
zg_sales:informix.sysreferences 149 8
zg_sales:informix.syschecks 157 8
zg_sales:informix.sysdefaults 165 8
zg_sales:informix.syscoldepend 173 8
zg_sales:informix.sysprocedures 181 8
zg_sales:informix.sysprocbody 189 8
zg_sales:informix.sysprocplan 197 8
zg_sales:informix.sysprocauth 205 8
zg_sales:informix.sysblobs 213 8
zg_sales:informix.sysopclstr 221 8
zg_sales:informix.systriggers 229 8
zg_sales:informix.systrigbody 237 8
zg_sales:informix.sysdistrib 245 8
zg_sales:informix.sysfragments 253 8
zg_sales:informix.sysfragauth