Re[2]: Determining which tables are in which chunk

An oncheck -pe will give you a report on every chunk and the tables that are in it. It will also give you a breakdown of extent sizes and available free space. This might be helpful to you. Craig Lanford Mailto:craig.lanford@alltel.com >>Has anyone written a script (or clever use of awk) to give a list of >>which tables are in which dbspace and chunk. Unless I am mistaken, this >>information is not simply available from the standard informix commands >>and it makes it very difficult to determine which table is causing the >>chunk to run out of space. >>Any help would be gratefully appreciated. >>Tan ********************************************************************** DST International Tel:+44 181 390 5000 www.dstinternational.co.uk This message and any attachments to it is intended only for the individual or company to which it is addressed and may contain information which is privileged, confidential or prohibited from disclosure or unauthorised use. If the recipient of this transmission is not the intended recipient, or the employee or agent responsible for delivering such materials to the intended recipient, you are hereby notified that any use, any form of reproduction, dissemination, copying, disclosure, modification, distribution and/or publication of this e-mail message or its attachments other than by its intended recipient is strictly prohibited by the sender. If you have received it in error, please notify us immediately by telephone on the number above and destroy the message and all copies in your possession. **********************************************************************