Oninit cdi / Archive
Talk to an expert →

Re: best procedure for table moving one dbspace to other

Posted in 2000

Topics: Storage & Space Management, Licensing & Editions, Clustering, Grid & MACH11

Mark D. Stock — — source: Informix-list mailing list archive (1991-1998)

"Art S. Kagel" wrote: > > In WGS which does not support fragmentation, and so apparently ALTER > FRAGMENT, you will have to either use ALTER INDEX...TO CLUSTER or export/ > import. Mmmm, interesting point. As I understand it, the two products are identical. So you can technically use fragmentation commands in IDS-WE, but as you say, it is not supported because you are not licensed to use that functionality. However, does using the ALTER FRAGMENT command on a non-fragmented table constitute using fragmentation? I think not, but will probably be proved wrong. :-) Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock mailto:mdstock@mydas.freeserve.co.uk |//////// /| | http://www.informix.com http://www.informixhandbook.com |///// / //| | http://www.iiug.org +-----------------------------------+//// / ///| | |What year 2000 bug? year 2000 bug? |/// / ////| | |year 2000 bug? year 2000 bug? year |// / /////| | |2000 bug? year 2000 bug? year 1900 |/ ////////| +----------------------+-----------------------------------+-----------+

↪ replying to Mark D. Stock
David Williams — — source: Informix-list mailing list archive (1991-1998)

In article <877r6g$ep2$1@news.xmission.com>, Mark D. Stock <mdstock@myda s.freeserve.co.uk> writes > >"Art S. Kagel" wrote: >> >> In WGS which does not support fragmentation, and so apparently ALTER >> FRAGMENT, you will have to either use ALTER INDEX...TO CLUSTER or export/ >> import. > >Mmmm, interesting point. As I understand it, the two products are >identical. So you can technically use fragmentation commands in IDS-WE, >but as you say, it is not supported because you are not licensed to use >that functionality. > Using >1 dbspace for a table in Workgroup Edition results in an error. Using just 1 dbspace is ok and since I logged a support call on it where I was getting a spurious error. The support call was accepted by UK Technical Support...!! <GRIN...> <DUCK>. >However, does using the ALTER FRAGMENT command on a non-fragmented table >constitute using fragmentation? I think not, but will probably be proved >wrong. :-) > >Cheers, -- David Williams

Glossary