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

Moving a database from v8.2 to v9

P: n/a
If I have a 30gb windows database on 8.2.5, what are ones options in
trying to move such to v9 system while at the same time enabling
automatic storage, automatic maintanence and automatic memory ? I need
to test the existing functionality on Express C v9 before upgrading my
existing server, so I want to try it out on a test setup where I have
installed Express C.

Seems I cannot restore from a backup 8.2.5 image, as I cannot get
redirect to give me an option to create a new database with automatic
storage. v9 DB2MOVE cannot use the new copy schema options from a
previous version, I have a number of generated by default / generated
always column tables that may cause problems with db2move import.

So what are ones options ?

Aug 14 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
p175 wrote:
If I have a 30gb windows database on 8.2.5, what are ones options in
trying to move such to v9 system while at the same time enabling
automatic storage, automatic maintanence and automatic memory ? I need
to test the existing functionality on Express C v9 before upgrading my
existing server, so I want to try it out on a test setup where I have
installed Express C.

Seems I cannot restore from a backup 8.2.5 image, as I cannot get
redirect to give me an option to create a new database with automatic
storage. v9 DB2MOVE cannot use the new copy schema options from a
previous version, I have a number of generated by default / generated
always column tables that may cause problems with db2move import.

So what are ones options ?
You cannot alter a database to become automatic storage. That's probably
the most called for requirement in that area :-)
In your situation take a look at my copy/backup schema article on
developer works.
http://www.ibm.com/developerworks/db...dm-0602rielau/
The alternative is to first migrate to DB2 9 and then use the DB9
improved db2move support.

Cheers
Serge

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

IOD Conference
http://www.ibm.com/software/data/ond...ness/conf2006/
Aug 14 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.