Oninit cdi / Archive
Talk to an expert →

Extents and tables

Posted in 2003

Topics: Storage & Space Management

STEVE RITCHIE — — source: IIUG Forums & Mailing Lists

I know I have done this before but can't for the life of me remember how to now. I have recently added a 2G chunk and it has been used in full within a day, this is not expected. Onece before I had this and what had happened was a table was low on available extents so as soon as I added a chunk, it took it in full. How can I tell what table(s) reside in a particular chunk. Thanks in advance.

↪ replying to STEVE RITCHIE
Martin Fuerderer — — source: IIUG Forums & Mailing Lists

Hi, you may want to run "oncheck -pe" as user "informix". Save the output in a file and then scrutinize it ... Regards, Martin -- Martin Fuerderer IBM Informix Development Munich Data Management Solutions "STEVE RITCHIE" <steven.ritchie@gb.unisys.com> Sent by: forum.subscriber@iiug.org 13.08.2003 12:54 To: ids@iiug.org cc: Subject: Extents and tables [1678] I know I have done this before but can't for the life of me remember how to now. I have recently added a 2G chunk and it has been used in full within a day, this is not expected. Onece before I had this and what had happened was a table was low on available extents so as soon as I added a chunk, it took it in full. How can I tell what table(s) reside in a particular chunk. Thanks in advance.

↪ replying to STEVE RITCHIE
Mark D. Stock — — source: IIUG Forums & Mailing Lists

STEVE RITCHIE wrote: > I know I have done this before but can't for the life of me remember how to now. I have recently added a 2G chunk and it has been used in full within a day, this is not expected. Onece before I had this and what had happened was a table was low on available extents so as soon as I added a chunk, it took it in full. > > How can I tell what table(s) reside in a particular chunk. You can use onstat -pe to print the entire extent map. You could also look in the sysmaster database. Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock mailto:mdstock@MydasSolutions.com |//////// /| | Mydas Solutions Ltd http://MydasSolutions.com |///// / //| | +-----------------------------------+//// / ///| | |We value your comments, which have |/// / ////| | |been recorded and automatically |// / /////| | |emailed back to us for our records.|/ ////////| +----------------------+-----------------------------------+-----------+

Related threads

Glossary