1. Could we move the installation path to other mount point. (from /
opt/ibm/db2/V9.7 to /db2home/ibm/db2/V9.7). What is the impact of
moving.
2. Can we move instance owner home path (from /home/db2stga to /
db2home/db2stga)
3. Is it mandatory to install DB2 and create instances by user with
Root privilege? The initial concern was that other user with ROOT and
drop the instances.

Thanks!

If you move the DB2 executables, your instance won't start. You would have to
do a db2iupdt afterwards.

It depends on your environment.

No, however there are limitations of non-root installations.
see:
http://publib.boulder.ibm.com/infoce.../c0050562.html

I don't understand this sentence.

It takes 5 minutes to install DB2, so I'm not quite sure why you want to move
the executables in the first place.

Please tell me what you want to do.

I hope you don't tell me that you want to use root as the instance owner.

--
Helmut K. C. Tessarek
DB2 Performance and Development

/*
Thou shalt not follow the NULL pointer for chaos and madness
await thee at its end.
*/

On Jun 24, 3:01*pm, Aakash <bor... (AT) gmail (DOT) com> wrote:
You would be much better off installing another copy of DB2 into the
new
location, and then using db2iupdt to point the existing instance at
the
new location.

It is possible to do this, but if you have databases that have any
files
anywhere inside the old home directory you will need to fix that.
This
requires either doing a backup/redirected restore or using the
db2relocatedb
utility.