Hi everybody,

We have a client with a 500GB IDS 7.3 DB. The client needs to move some dbspaces (about 40GB) to a new set of drives. Which options
of the following do you prefer:

1- Can I create the new devices and then use "dd" with the DB off-line to copy the chunks to the new devices?

2- Can I create the new devices, perform a full backup, change the links of the chunks to the new devices and the restore ONLY the
dbspaces that I want to move?

3-Or should I use the traditional method: perform a full backup, change the links of the chunks to the new devices and the restore
the bull backup? (My last option, due to the size of the DB and the time required)

Thanks in advance for your help !!!

--
Manuel A. Daponte Santiago
--------------------------
Systems Consultant
GM Group

Manuel Daponte wrote:

> Hi everybody,
>
> We have a client with a 500GB IDS 7.3 DB. The client needs to move some
> dbspaces (about 40GB) to a new set of drives. Which options of the
> following do you prefer:
>
> 1- Can I create the new devices and then use "dd" with the DB off-line to
> copy the chunks to the new devices?
>
> 2- Can I create the new devices, perform a full backup, change the links
> of the chunks to the new devices and the restore ONLY the dbspaces that I
> want to move?
>
> 3-Or should I use the traditional method: perform a full backup, change
> the links of the chunks to the new devices and the restore the bull
> backup? (My last option, due to the size of the DB and the time required)

Create the new dbspaces.
Use ALTER FRAGMENT to move the data.
Drop the old dbspaces.
Or do you want to keep the same dbspace names?

--
Ciao,
The Obnoxious One

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

It's a SAP installation. I think that the client wants to keep the same names for the dbspaces. Anyway, Timothy Brown sent me an
e-mail with a good idea:

Provided that you have links to the raw devices, you might want to use
Informix mirroring to do the trick:
1. mirror the dbspace with the mirror on the new devices
2. after mirror is setup, during maintenance, shutdown the system
3. switch the links
4. startup the db and drop the mirror

--
Manuel A. Daponte Santiago
--------------------------
Systems Consultant
GM Group


"Obnoxio The Clown" <obnoxio@hotmail.com> wrote in message news:bo656a$17ul2n$2@ID-64669.news.uni-berlin.de...
Manuel Daponte wrote:

> Hi everybody,
>
> We have a client with a 500GB IDS 7.3 DB. The client needs to move some
> dbspaces (about 40GB) to a new set of drives. Which options of the
> following do you prefer:
>
> 1- Can I create the new devices and then use "dd" with the DB off-line to
> copy the chunks to the new devices?
>
> 2- Can I create the new devices, perform a full backup, change the links
> of the chunks to the new devices and the restore ONLY the dbspaces that I
> want to move?
>
> 3-Or should I use the traditional method: perform a full backup, change
> the links of the chunks to the new devices and the restore the bull
> backup? (My last option, due to the size of the DB and the time required)

Create the new dbspaces.
Use ALTER FRAGMENT to move the data.
Drop the old dbspaces.
Or do you want to keep the same dbspace names?

--
Ciao,
The Obnoxious One

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