Cesar Cruz Said>
>Hi,
>
>We spend 3 hours doing this
>
>1.- alter table xyz modify nextsize 1000000
>2.- drop all contraints from table xyz
>3.- update systables set fextsize 2000000 where tabname = 'xyz';
>4.- ontape -s -L 0 -N BDD
>5.- onunload -t /dev/st0 -b 8192 -s 20000000 BDD:xyz
>6.- onload -t /dev/st0 -b 8192 -s 20000000 -d DBspace1 BDD:xyznew
>7.- rename table xyz xyzold
>8.- selec count(*) from xyzold where 1 = 1;
>9.- selec count(*) from xyznew where 1 = 1;
>10.- create primary key, secondary index and 3 constraints on table xyznew
>11.- rename table xyznew xyz
>12.- ontape -s -L 0 -U BDD
>13.- down instance
>14.- up instance
>
>Just for fix a table xyz with 209 extents, with table xyznew with 4 extents.
>
>There is another way (HPL for example) for doing this more faster?
>
>Because Linux Red Hat don't let us create file grather than 2GB!!!.
>
>Regards.
>
>_________________________________________________ __________
>Do You Yahoo!?
>La mejor conexisn a Internet y <b >2GB</b> extra a tu correo por $100 al mes. http://net.yahoo.com.mx
>
>Reply

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?