473,326 Members | 2,111 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

Change instance home dir and owner

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
Apr 11 '07 #1
4 5721
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" <gu****@cs.tum.edua écrit dans le message de news:
ev**********@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
Apr 12 '07 #2
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
Apr 12 '07 #3
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" <gu****@cs.tum.edua écrit dans le message de news:
ev**********@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
Apr 15 '07 #4
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
Apr 17 '07 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: ptass | last post by:
I have a main form (Form1) which opens a second form (Form2) when a button is clicked. Form2 has .FormBorderStyle set to FixedSingle. Form2 contains two buttons, one which unpins it from Form1...
1
by: Ange T | last post by:
Hi, I have a secured Access 2000 database, and have encountered a strange error that I can't find any similar postings on. I'd really appreciate your help! In my database, I have a number of...
2
by: Richard Sherratt | last post by:
I create a new user and make them a member of Admins. I then log on as that user and try to modify an existing query. I'm told that I don't have the necessary permissions. The Admins group has full...
5
by: Cyril Gupta | last post by:
Hello, I have a class inside another class. The Scenario is like Car->Engine, where Car is a class with a set of properties and methods and Engine is another class inside it with its own set of...
0
by: mike | last post by:
At this site, they use DB2 8.2.2 on LUW , and have thousands of DARI style stored procedures ('c', embedded-static SQL). During PREP and BIND they specify the package-owner with the OWNER...
1
by: ebusiness | last post by:
I create a new instance yesterday, now I cannot stop it, or perform any instance level operation like setup db2comm using instance id. The error message is "SQL1092N does not have the authority...
3
by: coolminded | last post by:
hi, i have create one database with owner 'postgres' and i created tables with the same owner. but now i want to change the owner of the database as well as the tables. i changed the owner of...
0
by: Patrick Finnegan | last post by:
I am checking an existing DB2 installation on Red Hat Linux and I see that root owns files in the db2 instance home directory. Stuff like: ../sqllib/adm/db2chparm ../sqllib/adm/db2stop...
1
by: robert2821 | last post by:
Hi, I'm new; greetings all! I'm wondering if the following program should work. I think it should print 'Hello, World', but instead it produces a TypeError. Is this a bug in decorators, a...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.