SEO

#1 (**permalink**) 02-27-2008, 12:08 PM

Hi,

I'm integrating a database server running Linux and DB2 V9.1 into an
LDAP based authentication system.
Unfortunately, this will include changing the location of the DB2
instance home directories (it remains the same physical partition, it's
just mounted somewhere else) as well as a uid/gid change of the instance
owner.
Is there any way of performing such a migration except backing up all
the databases, dropping and recreating the instances and restoring all data?
Any idea is appreciated.

Thanks,
Benjamin

#2 (**permalink**) 02-27-2008, 12:08 PM

Go to the IBM docs and look for info on DB2RELOCATEDB command.
A Google search might be quicker.
It will show how you can relocate an instance, a db or portion thereof.
Regards, Pierre.

--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
"Benjamin Gufler" <gufler@cs.tum.edu> a écrit dans le message de news:
evi942$qnv$1@news.in.tum.de...
> Hi,
>
> I'm integrating a database server running Linux and DB2 V9.1 into an
> LDAP based authentication system.
> Unfortunately, this will include changing the location of the DB2
> instance home directories (it remains the same physical partition, it's
> just mounted somewhere else) as well as a uid/gid change of the instance
> owner.
> Is there any way of performing such a migration except backing up all
> the databases, dropping and recreating the instances and restoring all
> data?
> Any idea is appreciated.
>
> Thanks,
> Benjamin

#3 (**permalink**) 02-27-2008, 12:08 PM

Hi Pierre,

On 2007-04-12 02:13, Pierre Saint-Jacques wrote:
> Go to the IBM docs and look for info on DB2RELOCATEDB command.
> A Google search might be quicker.
> It will show how you can relocate an instance, a db or portion thereof.

thanks for this hint. I've tried db2relocatedb on one of the databases
following the instructions in IBM's publib. All the paths I can see in
the DB2 system registry (using db2greg -dump), the dbm configuration,
the db configuration and the tablespace snapshot now point to the new
location. However, if I unmount the old database location, I get an
SQL0293N :-(

Cheers,
Benjamin

#4 (**permalink**) 02-27-2008, 12:09 PM

The db2relocatedb command only changes the pointers, paths, and so on. It
does NOT move any of the data files.
Are you sure you moved all required data files to the new mount point?
It seems from the message that one container path specified is not valid.
Either it was specified wrong in the relocate or in its move, I think.
Regards, Pierre.

--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
"Benjamin Gufler" <gufler@cs.tum.edu> a écrit dans le message de news:
evkljk$fdj$1@news.in.tum.de...
> Hi Pierre,
>
> On 2007-04-12 02:13, Pierre Saint-Jacques wrote:
>> Go to the IBM docs and look for info on DB2RELOCATEDB command.
>> A Google search might be quicker.
>> It will show how you can relocate an instance, a db or portion thereof.
>
> thanks for this hint. I've tried db2relocatedb on one of the databases
> following the instructions in IBM's publib. All the paths I can see in
> the DB2 system registry (using db2greg -dump), the dbm configuration,
> the db configuration and the tablespace snapshot now point to the new
> location. However, if I unmount the old database location, I get an
> SQL0293N :-(
>
> Cheers,
> Benjamin

#5 (**permalink**) 02-27-2008, 12:10 PM

On 2007-04-15 22:04, Pierre Saint-Jacques wrote:
> The db2relocatedb command only changes the pointers, paths, and so on.
> It does NOT move any of the data files.
> Are you sure you moved all required data files to the new mount point?

DB2 has a partition on it's own, which I mounted to the new position, so
all the files should be there.
For now I've "solved" the problem by creating symlinks from the old
instance home's positions to the new ones. It's not the perfect
solution, but it seems to work.

Thanks,
Benjamin

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Change instance home dir and owner