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

Migrating from DB2 7.2 to 8.2 Questions

P: n/a
Hi,

We are migrating a system from DB2 7.2 to DB2 8.2.2 for a SAP installation.

We have the migration guide from SAP.

SAP recommends using 16KB page sizes instead of 4KB page sizes.

What is the best route for us? Can we export our 4KB data and IXF import it into 16KB
containers? Is there a better, more efficient, supported way to do this? There are
thousands of tables, so this not only has to be done correctly, it has to be done to
stay within SAP support-able guidelines.

We also want to set up HADR in 8.2.2. Is there a RedBook with more information than
currently supplied docs? We also have the book Learning DB2 Visually, the latest DB2
book, which is fantastic by the way, but it does not go into enough detail on log
management for HADR. We need a little more specific information than just overview.

Thanks in advance!

-RF-

Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
RollForward Wizard wrote:
Hi,

We are migrating a system from DB2 7.2 to DB2 8.2.2 for a SAP installation.

We have the migration guide from SAP.

SAP recommends using 16KB page sizes instead of 4KB page sizes.

What is the best route for us? Can we export our 4KB data and IXF
import it into 16KB
containers? Is there a better, more efficient, supported way to do
this? There are
thousands of tables, so this not only has to be done correctly, it has
to be done to
stay within SAP support-able guidelines.

We also want to set up HADR in 8.2.2. Is there a RedBook with more
information than
currently supplied docs? We also have the book Learning DB2 Visually,
the latest DB2
book, which is fantastic by the way, but it does not go into enough
detail on log
management for HADR. We need a little more specific information than
just overview.

Thanks in advance!

-RF-

You may be interested in this redbook. Fresh of the virtual press:
http://www.redbooks.ibm.com/abstracts/sg246765.html

Cheers
Serge
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab
Nov 12 '05 #2

P: n/a
Serge Rielau wrote:
RollForward Wizard wrote:
Hi,

We are migrating a system from DB2 7.2 to DB2 8.2.2 for a SAP
installation.

We have the migration guide from SAP.

SAP recommends using 16KB page sizes instead of 4KB page sizes.

What is the best route for us? Can we export our 4KB data and IXF
import it into 16KB
containers? Is there a better, more efficient, supported way to do
this? There are
thousands of tables, so this not only has to be done correctly, it has
to be done to
stay within SAP support-able guidelines.

We also want to set up HADR in 8.2.2. Is there a RedBook with more
information than
currently supplied docs? We also have the book Learning DB2 Visually,
the latest DB2
book, which is fantastic by the way, but it does not go into enough
detail on log
management for HADR. We need a little more specific information than
just overview.

Thanks in advance!

-RF-

You may be interested in this redbook. Fresh of the virtual press:
http://www.redbooks.ibm.com/abstracts/sg246765.html

Cheers
Serge


Thanks Serge. This RedBook is excellent. It solved the 4KB-to-16KB
question beautifully! ( SAP automatically sets it to 16KB during the
installation, which is exactly what the customer wants )

Do you have any RedBook recommendations for HADR?

Thanks!

-RF-

Nov 12 '05 #3

P: n/a
Hello,

and thats for HADR with SAP:

http://www-128.ibm.com/developerwork...e/dm-0508zeng/

regards
Joachim Müller

"RollForward Wizard" <ro*********@rollforward.com> schrieb im Newsbeitrag
news:bq***************@fe80.usenetserver.com...
Hi,

We are migrating a system from DB2 7.2 to DB2 8.2.2 for a SAP
installation.

We have the migration guide from SAP.

SAP recommends using 16KB page sizes instead of 4KB page sizes.

What is the best route for us? Can we export our 4KB data and IXF import
it into 16KB
containers? Is there a better, more efficient, supported way to do this?
There are
thousands of tables, so this not only has to be done correctly, it has to
be done to
stay within SAP support-able guidelines.

We also want to set up HADR in 8.2.2. Is there a RedBook with more
information than
currently supplied docs? We also have the book Learning DB2 Visually, the
latest DB2
book, which is fantastic by the way, but it does not go into enough detail
on log
management for HADR. We need a little more specific information than
just overview.

Thanks in advance!

-RF-

Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.