Results 1 to 6 of 6
  1. #1
    Join Date
    Sep 2006
    Posts
    33

    Question Unanswered: Moving DB2 UDB from AIX 5.2 to AIX 5.3

    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

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    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.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Sep 2006
    Posts
    33
    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
    Last edited by syb_dmn; 02-19-07 at 08:53.

  4. #4
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    If you can take an offline backup, you don't have to think about rollforward at all.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  5. #5
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    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.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  6. #6
    Join Date
    Jan 2007
    Posts
    2
    If you just upgrade to 5.3, you can simply do alternate disk upgrade if you have a mirror disk.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •