Re: Off Topic: Cesar Cruz

bozon wrote:<SNIP> > Art Kagel Said: > ALTER FRAGMENT ON xyz INIT IN dbspace1;> > Is this part safe? > >>3.- update systables set fextsize 2000000 where tabname = 'xyz'; > > > So would you do: > > UPDATE systables SET fextsize = 20000 WHERE tabname = '<tablename>';> ALTER TABLE <tablename> MODIFY NEST SIZE 4000 ; > ALTER FRAGMENT ON <tablename> INIT IN <dbspace>;> To straighten out a table with too many extents? Yes, but I'd skip the UPDATE Systables. That always makes me nervous amd unless the dbspace's free space is fragmented I'll on ly end up with one or two extents per chunk anyway. Art S. Kagel

Thanks Art, The update systables made me nervous too. I tried the other and it works great.