Moving DB2 UDB from AIX 5.2 to AIX 5.3

syb_dmn · #1 (**permalink**) 02-19-07, 07:18

Hi All,

We have a requirement about moving several DB2 UDB instances from a set of servers with AIX 5.2 to a new set of servers with AIX 5.3.

I am new to DB2 world and would like know methods for this migration. I have been referring to DB2 utilities guide. However, I would like to confirm if datafiles are compatible across AIX 5.2 and AIX 5.3. Kindly share your experiences / suggestions.

Thanks in advance.

Regards,
Syb

Marcus_A · #2 (**permalink**) 02-19-07, 07:29

Backup and restore commands (see Command Reference). You may have to use redirected option if the tablespace container paths are different.

But you will have to install DB2 and create the instance(s) manually on the new server before you do the restore database.

syb_dmn · #3 (**permalink**) 02-19-07, 07:38

Thanks for quick response.
Yes, need to use redirected option as directory structure may differ across source and target machines.

Also would it be possible to apply logs (rollforward) from AIX 5.2 to AIX 5.3?

Regards,
Syb

stolze · #4 (**permalink**) 02-21-07, 04:04

If you can take an offline backup, you don't have to think about rollforward at all.

Marcus_A · #5 (**permalink**) 02-21-07, 10:42

Quote:

Originally Posted by syb_dmn

Thanks for quick response.
Yes, need to use redirected option as directory structure may differ across source and target machines.

Also would it be possible to apply logs (rollforward) from AIX 5.2 to AIX 5.3?

Regards,
Syb

If you do infact need to rollforward, then you can do if the new database knows the log path and has access to the old logs. See the restore command options in the Command Reference manual.

db29999 · #6 (**permalink**) 02-23-07, 11:58

If you just upgrade to 5.3, you can simply do alternate disk upgrade if you have a mirror disk.

Internet Services

Web Development

Digital Marketing

Consumer Tech