467,189 Members | 1,305 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,189 developers. It's quick & easy.

Moving db2 to a dedicated partion

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
  • viewed: 1108
Share:
1 Reply
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.

Similar topics

6 posts views Thread by Michael J. Moore | last post: by
4 posts views Thread by el emperador | last post: by
7 posts views Thread by Borys Power | last post: by
4 posts views Thread by LaSalamandra | last post: by
3 posts views Thread by Brian Simmons | last post: by
2 posts views Thread by David Thielen | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.