Re: Finding dbs for table

Bill Ennis wrote: > > With fragmentation a table can belong to more than one dbspace. > I belive the first 3 chars in partnum contain the dbspace number > for the table. You can view partnum in the systables table. > My guess is that if you do fragment a table you will have multiple > systables entries for those tables. Not quite. The partnum will be NULL, and you will get one record in sysfragments for each fragment. These records have the fragment partnum. 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"!|/ ////////| +----------------------+-----------------------------------+-----------+