Hello.

I have two databases under 1 instance (w2003, v8 ese, fp3).
I created a second instance and want to start 1 of my databases under new
instance.
Can I do this without backup / restore?

Mark.

Hi Mark ,

you can without problems, but you can also give a look at the command:
db2relocatedb
just a snip from the command reference...

If the instance that a database belongs to is changing, the following
must be done before running this command to ensure that changes to the
instance and database support files will be made:

If a database is being moved to another instance, create the new
instance.
Copy the files/devices belonging to the databases being copied onto the
system where the new instance resides. The path names must be changed as
necessary.
Change the permission of the files/devices that were copied so that they
are owned by the instance owner.
If the instance is changing, the tool must be run by the new instance
owner.

In a partitioned database environment, this tool must be run against
every partition that requires changes. A separate configuration file
must be supplied for each partition, that includes the NODENUM value of
the partition being changed. For example, if the name of a database is
being changed, every partition will be affected and the db2relocatedb
command must be run with a separate configuration file on each
partition. If containers belonging to a single database partition are
being moved, the db2relocatedb command only needs to be run once on that
partition.

Example 2

To move the database DATAB1 from the instance jsmith on the path /dbpath
to the instance prodinst do the following:

Move the files in the directory /dbpath/jsmith to /dbpath/prodinst.
Use the following configuration file with the db2relocatedb command to
make the changes to the database files:
DB_NAME=DATAB1
DB_PATH=/dbpath
INSTANCE=jsmith,prodinst
NODENUM=0

Hope this helps
Fabrizio


"Mark Barinstein" <mark@crk.vsi.ru> wrote in message
news:bm5l0g$1l0f$1@serv.vrn.ru

> Hello.
>
> I have two databases under 1 instance (w2003, v8 ese, fp3).
> I created a second instance and want to start 1 of my databases under new
> instance.
> Can I do this without backup / restore?
>
> Mark.




--
Posted via Mailgate.ORG Server - http://www.Mailgate.ORG