Re: Determining which tables are in which chunk

This is a multipart message in MIME format --------------InterScan_NT_MIME_Boundary Content-Type: text/plain; charset=ISO-8859-1 Content-transfer-encoding: quoted-printable Tan, =20 Try, in sysmaster (on V7) =20 select dbsname, tabname, size from sysextents where physchunk(start) =3D <chunk num> order by size desc; =20 This will give you the db, table and extent size ordered largest=20 extent first=2E =20 HTH Davin =20 ______________________________ Reply Separator ____________________________= _____ Subject: Determining which tables are in which chunk Author: PC {tan@jettech=2Edircon=2Eco=2Euk} at INTERNET Date: 29/03/98 15:27 Has anyone written a script (or clever use of awk) to give a list of which=20 tables are in which dbspace and chunk=2E Unless I am mistaken, this=20 information is not simply available from the standard informix commands and= =20 it makes it very difficult to determine which table is causing the chunk to= =20 run out of space=2E =20 Any help would be gratefully appreciated=2E =20 Tan =20 =20 =20 =20 =20 =20 ********************************************************************** DST International Tel:+44 181 390 5000 www=2Edstinternational=2Eco=2Eu= k=20 This message and any attachments to it is intended only for the=20 individual or company to which it is addressed and may contain=20 information which is privileged, confidential or prohibited from=20 disclosure or unauthorised use=2E If the recipient of this=20 transmission is not the intended recipient, or the employee or agent=20 responsible for delivering such materials to the intended recipient,=20 you are hereby notified that any use, any form of reproduction,=20 dissemination, copying, disclosure, modification, distribution and/or=20 publication of this e-mail message or its attachments other than by=20 its intended recipient is strictly prohibited by the sender=2E =20 If you have received it in error, please notify us immediately by=20 telephone on the number above and destroy the message and all copies=20 in your possession=2E ********************************************************************** --------------InterScan_NT_MIME_Boundary--