tables to new dbspace

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

tomcaml@yahoo.com - 27 Jan 2005 19:10 GMT

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

Reply to this Message

Obnoxio The Chav - 27 Jan 2005 20:45 GMT

tomcaml@yahoo.com said:

> hello!
>
[quoted text clipped - 3 lines]
> quickest is also the best)
> infx 9.40 on HP-UX

ALTER FRAGMENT ... INIT IN ...

Signature

Bye now,
Obnoxio

"C'est pas parce qu'on n'a rien ? dire qu'il faut fermer sa gueule"
- Coluche

"I'm trying to see things your way, but I can't get my head up my a.s"
- JCH

"Ogni uomo mi guarda come se fossi una testa di cazzo"
- Marco

If anyone told you to be yourself they would be giving you bad advice.

I went to the airport to check in and they asked what I did because I
looked like a terrorist. I said I was a comedian. They said, "Say
something funny then." I told them I had just graduated from flying
school.

-- Ahmed Ahmed
sending to informix-list

Reply to this Message

Neil Truby - 28 Jan 2005 00:09 GMT

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.

Signature

Neil Truby t:01932 724027
Director m:07798 811708
Ardenta Limited e:neil.truby@ardenta.com

> hello!
>
[quoted text clipped - 7 lines]
>
> tom

Reply to this Message

tomcaml@yahoo.com - 28 Jan 2005 02:46 GMT

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

> How many tables?
> The Chav's suggestion of ALTER FRAGMENT ... INIT IN is good. Set
[quoted text clipped - 18 lines]
> >
> > tom

Reply to this Message

Neil Truby - 28 Jan 2005 05:40 GMT

> 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 ...

Reply to this Message

tomcaml@yahoo.com - 31 Jan 2005 14:51 GMT

any better suggestions?

> > not that many tables at all - dozen, tops....had a suggestion to do the
> > rename table and insert over into a new one but....
[quoted text clipped - 4 lines]
> the indexes first on the target table then add them once all the data's
> loaded ...

Reply to this Message