tables to new dbspace
Tom asked for the best and quickest way to move about a dozen large tables to another dbspace on IDS 9.40 on HP-UX. Neil Truby recommended ALTER FRAGMENT ... INIT IN, with PSORT_NPROCS (and possibly PSORT_DBTEMP) set, or HPL for few tables, and warned that rename-and-insert is slow and leaves fragmented indexes unless indexes are dropped first.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
hello! i am needing to move some existing tables that are rather large to a different dbspace. what is the best and quickest method to do this? (hoping that the quickest is also the best) infx 9.40 on HP-UX thanks! tom
How many tables? The Chav's suggestion of ALTER FRAGMENT ... INIT IN is good. Set PSORT_NPROCS and if you believe Art maybe PSORT_DBTEMP too to speed up its index build element. It doesn't give you much direct info about what it's up to though, and with a small number of tables I might use HPL. -- Neil Truby t:01932 724027 Director m:07798 811708 Ardenta Limited e:neil.truby@ardenta.com <tomcaml@yahoo.com> wrote in message news:1106853004.824321.235930@z14g2000cwz.googlegroups.com... > hello! > > i am needing to move some existing tables that are rather large to a > different dbspace. > what is the best and quickest method to do this? (hoping that the > quickest is also the best) > infx 9.40 on HP-UX > > > > thanks! > > > tom >
not that many tables at all - dozen, tops....had a suggestion to do the rename table and insert over into a new one but.... i have not used hpl yet, so may be time to dig deeper into that as well thanks for the tips - i will check them out. tom Neil Truby wrote: > How many tables? > The Chav's suggestion of ALTER FRAGMENT ... INIT IN is good. Set > PSORT_NPROCS and if you believe Art maybe PSORT_DBTEMP too to speed up its > index build element. It doesn't give you much direct info about what it's > up to though, and with a small number of tables I might use HPL. > > -- > Neil Truby t:01932 724027 > Director m:07798 811708 > Ardenta Limited e:neil.truby@ardenta.com > > > <tomcaml@yahoo.com> wrote in message > news:1106853004.824321.235930@z14g2000cwz.googlegroups.com... > > hello! > > > > i am needing to move some existing tables that are rather large to a > > different dbspace. > > what is the best and quickest method to do this? (hoping that the > > quickest is also the best) > > infx 9.40 on HP-UX > > > > > > > > thanks! > > > > > > tom > >
<tomcaml@yahoo.com> wrote in message news:1106880366.164635.247230@f14g2000cwb.googlegroups.com... > not that many tables at all - dozen, tops....had a suggestion to do the > rename table and insert over into a new one but.... > i have not used hpl yet, so may be time to dig deeper into that as well That's an awful suggestion if they are large, as it will be very slow and you'll end up with deeply fragmented indexes. At least if you do that drop the indexes first on the target table then add them once all the data's loaded ...