Can I Move a Fragment?

Good Morning people, Is it possible to detach a fragment from a fragmented table and reattach it to another dbspace? IDS 11.50.FC5 on AIX 5.3. thanx, dan

You dont have to detach it, just ALTER it: ALTER FRAGMENT ON TABLE <mytable> INIT FRAGMENT BY .... and give the new fragmentation scheme. The engine will move all fragments to satisfy the new scheme, not just the changed ones. IB you can just move one, but I don't remember the syntax. Note that you will need enough logical log space to log the changed pages and enough free space on the new dbspace (it can be the same one it's already in BTW which is like a reorg) to hold the new partition. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Mon, Oct 11, 2010 at 6:52 AM, DAN MUELLER <dan.mueller@trnswrks.com>wrote: > Good Morning people, > > Is it possible to detach a fragment from a fragmented table and reattach it > to > another dbspace? IDS 11.50.FC5 on AIX 5.3. > > thanx, > dan > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --0016361e87ac841f220492554d00