Re: Chunk really full??? Puzzling . . .
Space is allocated to tables in extents. An extent almost always
can contain many rows of a table. When Online needs space for
a table it will look in all chunks in the tables dbspace for the
space.
You're not giving copletre info from onstat -d or the create table
statement so I don't know your table's extent size or if there are
more chunks for the dbspaces involved.
I guess the key point here is that space is not allocated before each
row insert. It is done more more infrequently than that. If it were me
I'd find out the if there were any more chunks in this dbspace. If not
I'd add some space pronto!
Bill
}
} The following is the output of an `onstat -d` for a particular chunk -
} calldata_dbs_4_cnd_1.
}
} de04c18 13 13 0 400000 0 PO- /chunks/calldata_dbs_4_cnk_1
} ^
} zero free space
}
} Notice that the amount of free space is 0. I have a table defined which
} fragments inserts for the month of August to this chunk:
}
} fragment by expression
} (MONTH (calldate ) IN (1 ,5 ,9 )) in calldata_dbs_1 ,
} (MONTH (calldate ) IN (2 ,6 ,10 )) in calldata_dbs_2 ,
} (MONTH (calldate ) IN (3 ,7 ,11 )) in calldata_dbs_3 ,
} (MONTH (calldate ) IN (4 ,8 ,12 )) in calldata_dbs_4
}
} Dbspace "calldata_dbs_4" and chunk "calldata_dbs_4_cnk_1" are
} equivalent, and there are no other chunks allocated to dbspace
} "calldata_dbs_4".
}
} Although the current status of the calldata_dbs_4_cnk_1, as reported by
} `onstat -d` is that it has no free space, we are still able to insert
} rows into the table for the month of August.
}
} How is this possble?
}
} The only thing that I can think of is that at some point all of the
} chunk was allocated, then some rows were deleted. But the extents are
} still allocated for the table and not shown as being free even though
} rows have been deleted from the table. If this is the case, how does
} one find out the "real" free space in a chunk?
}
} Thanks for any clarification on this.
} --
} * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
} ADDRESS ALTERED TO FOIL SPAMMERS: Remove "*NO-SPAM*" to reply.
}
} Cosmo Lee Multi-User Computer Systems Brooklyn, NY
}
} "JUST SAY 'NO' TO SPAM"
} * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
}
}
}
--
Bill Ennis Voice: 312-474-7516
SSA Fax: 312-474-7460
500 W. Madison email: ennis@ssax.com ennis@accesschicago.net