Fragments vs location of tables

In article <bagqaewygiirvxooeapyneuki.pminews@natserv.com>, Francisco Reyes <francisco@?.Spam> writes >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? > I do not understand what you mean by table info. Can you give me some example output? Possibly this may be indexes still in the same dbspace. Also try running tbcheck -pe and see what that shows.. >I alocated the fragmentation at create table time. I also tried >another table which was in all 4 dbspaces and changed it's >fragmentation to not have db1 included to see if that would move the >data out. Table info still reports that table as using db1. Any way >to move the data out that dbspace (db1) for good? > >Remove "<No Spam>" to send me email. > > -- David Williams Maintainer of the Informix FAQ Primary site (Beta Version) http://www.smooth1.demon.co.uk Official site http://www.iiug.org/techinfo/faq/faq_top.html I see you standin', Standin' on your own, It's such a lonely place for you, For you to be If you need a shoulder, Or if you need a friend, I'll be here standing, Until the bitter end... So don't chastise me Or think I, I mean you harm... All I ever wanted Was for you To know that I care