Re: Chunk really full??? Puzzling . . .
Rick Bernstein wrote:
>
> The "onstat -d" reports free pages which are not assigned to an
> extent.
> Your display shows that no space exists for additional extents.
> It does NOT mean that all extents in this dbspace are full.
> Use the "oncheck -pt <database>:<table-name>" command or query the
> corresponding SMI tables to determine how full your fragments are.
And also oncheck -pe for a full extent mapping for that dbspace.
Cheers,
--
Mark.
+----------------------------------------------------------+-----------+
|Mark D. Stock - Informix SA http://www.informix.com |//////// /|
|mailto:mdstock@informix.com FAQ http://www.iiug.org |///// / //|
| +-----------------------------------+//// / ///|
| Tel: +27 11 807 0313 |If it's slow, the users complain. |/// / ////|
| Fax: +27 11 807 2594 |If it's fast, the users keep quiet.|// / /////|
|Cell: +27 83 250 2325 |Therefore, "No news: travels fast"!|/ ////////|
+----------------------+-----------------------------------+-----------+