Re: Fragments vs location of tables

Posted in 1998

Art S. Kagel — Wed, 28 Jan 1998 14:28:21 -0500 — source: Informix-list mailing list archive (1991-1998)

Francisco Reyes > I have several tables which I fragmented. i.e. in db1, db2, db3 and > db4. > I placed all my small non fragmented tables in db1 and to balance > some of the biggest ones NOT in db1. > Today while looking at table info I noticed the tables which are NOT > supposed to be on db1 report to be using the dbspace. One of them > even had db1 listed 3 times. Any clues why these tables are using > db1? What do you mean by the table info? Do you mean the partnum in systables? This is always zero (0) for fragmented tables. Look in sysfragments instead. Art S. Kagel