By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,334 Members | 1,266 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,334 IT Pros & Developers. It's quick & easy.

Moving db2 to a dedicated partion

P: n/a
When I installed DB2 UDB 8.2 on AIX 5.3 it got installed in
/home/db2inst1 (and I didn't care about it much then but now I would
like to move the same instance of DB2 to a dedicated filesystem. May I
know the steps involved in doing this migration activity.
Thanks,
db2udbgirl

Apr 7 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
In article <11**********************@z34g2000cwc.googlegroups .com>,
db********@gmail.com says...
When I installed DB2 UDB 8.2 on AIX 5.3 it got installed in
/home/db2inst1 (and I didn't care about it much then but now I would
like to move the same instance of DB2 to a dedicated filesystem. May I
know the steps involved in doing this migration activity.


A short action list:

0 - if located in homedir relocate databases out of the homedir with
db2relocatedb
1 - List your cataloged nodes/databases (list node/db directory)
2 - drop the instance (db2idrop)
3 - set the new homedir for the instance user
4 - create the instance (db2icrt)
5 - catalog the nodes/databases again (catalog node/db directory)
Apr 7 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.