Docstoc

DB2_AIX-Exploiting_an_AIX_LVM_Mirror_to_Enable_Fast__Volume-Independent_

Document Sample
DB2_AIX-Exploiting_an_AIX_LVM_Mirror_to_Enable_Fast__Volume-Independent_ Powered By Docstoc
					                                                   I B M P r o f e s s i o n a l s' P a p e r s




             Exploiting an AIX LVM Mirror to Enable Fast, Volume-Independent DB2 System
                                              Migration
                           Norifumi Kanda, Kazumi Yamamoto, Yohei Noguchi, Toshiaki Sota and Kunio Arai




                                                                                                                            AIX LVM




           A service outage lasting several hours is necessary for database system migrations, including server and
           storage subsystem renewals, due to the time required to perform a data backup and system restore. As client
           demand for continuous operations has grown, it has been a challenge to minimize the outage time required
           to perform such migrations. This paper describes a method of resolving this issue by exploiting an AIX
           LVM mirror for database systems migration. This method enables volume-independent database system
           migrations to be performed with a short service outage time.

           Key Words & Phrases                                 DB2 AIX LVM
                                       System migration, short service outage time, DB2, AIX LVM Mirror




                                                                                                                            3
     TCO




                                                                                                      2
                                                                                                              3       LVM
                                                                                                          4
                                                                                                                  5
                                                                                                                                 6
                                  AIX LVM      Logical Volume                                     7                                  LVM
     Manager               1                LVM                                                                                            8
                    DB2
                                             AIX     DB2




                                                                                              DB2                     DB2




88    P ROVISION No.66 / Summer 2010
                                                                                                              export
                                                             DB2                                                         load
                                 3
 1 DB2            db2imigr                migrate database                        2        backup/restore
         1


 2 DB2 backup                        restore
 3 DB2           export               load


             3
                                                                                                              DB2
                                                                                                  Q                        5
                                                                                                         ®
                 DB2                                  db2imigr                Q             WebSphere MQ 6


     migrate database
                             2
  db2imigr                   DB2
             migrate database
                                                  2




     db2imigr/migrate database


                                                                                                  7
                                                         DB2
backup
                           restore
                  3    restore


                                                                          2       DB2   backup/restore                export/
                                                                   load



                                                              4
                                                                   AIX LVM




                                                                                               P ROVISION No.66 / Summer 2010   89
                                              IO                                   AIX      DB2


                                                                          DB2


                                                                          LVM


                               LVM
                                       db2imigr      migrate database                                          DB2


                               3                                                                        db2imigr
                                                                         migrate database
                                                                                                         db2imigr
                                                                          migrate database




                                       DB2                              LVM
     DB2                                                        LVM      LVM




       LVM
                                                                                                  LVM
        Logical Volume LV



        AIX


        AIX


                                        AIX                   Volume
     Group VG                                  AIX
                                   LVM                   3
                                              LVM


                          LV


                                                             PowerHA
     SystemMirror for AIX 8              DB2




90    P ROVISION No.66 / Summer 2010
                         LVM




                                               ,




DB2




                                           2




LVM
                     2


                                                                              DB2
                               DB2


           A
       DB2                                                     .
               DB2                                             LVM

        VG
               PowerHA                                        DB2
                                         db2nodes.
cfg                                                                                      PV       Physical
                db2imigr                             Volume         recreatevg -f             3


                         B                                                   PV                     VG
                                   DB2
migrate database                                              PowerHA
                             DB2
                         C
                   LVM


                                     D




                                                                           P ROVISION No.66 / Summer 2010    91
                                                          db2nodes.                            V9.5                  DB2
       cfg
                           db2imigr


                                                DB2                             4                                                     LVM
       migrate database
                                          DB2


                                                                            db2imigr/migrate database



                                                                           LVM                                        recreatevg –f
           3           LVM            db2imigr/migrate database
                                                                      recreatevg –f                        VG          VG         Physical
                                                                      Volume PV
                                                2



                                                                                    LVM
                                                                                                4.1                     LVM
                                           backup/restore                                                                         AIX
                                                                           DB2                               1


                                                                                                1                                       DB2
                               TM
                   POWER5                                 AIX V5.3
      LPAR                 AIX V6.1        LPAR             DB2             2                                        DB2
                                                                                            migrate database                 DB2 V9.5
                                                    AIX
                                          DB2    V8        V9.5
                                                                                                           time
                           1    backup/restore                 2
     LVM             db2imigr         2
                     20GB       40GB




                                                                        4.1
                                                 NFS                       DB2 V9.5
                                DB2 V9.5


                        DB2                                                             1       20GB
       DB2       backup                   NFS                                       7                 11
                                                                      20                     40GB                           15
                                                                           16                                   33
                                                                                                                      20GB       40GB




92   P ROVISION No.66 / Summer 2010
                                                                                        IO



                                                                                                                 VG


                                                                                                   2



                                                                                                             1                   IO      IOPS
               2                                                                LVM                                                         LVM
                                                             2                                         15%                        IO
                         V9.5                                                                                   LVM


                                                                                                                        Read
               2         20GB                                    DB2                   Read                               LVM
                                          V8                                                                                          Read:Write
                         10          30        db2imigr          migrate
database                         V9.5                                  3
                   V8                     V9.5
     14                                                                                                                VG               VG Big
  40GB                                           V8                        VG          1VG              PV         1PV            PP Physical
                                                                           Partition                                         1          VG
                                               db2imigr                                  PV
                                30        migrate database                        1           PV
35
20GB                     14                                                             AIX V5.3                           Scalable VG
                                      2                                    1VG               PV          1024 1PV                PP
                                                                                              1VG            2097152
                                                                                              VG       Big VG
                            1                                                Scalable VG
                                                 2                                                           VG                        VG
                                                                             Scalable VG
                                                                                                       AIX V5.2                           VG
                                                                           Scalable VG                                            Scalable VG
                                                                                                   LVM             AIX V5.3
  LVM


          LVM
          VG




                        LVM
                        2




                                                                                                                  P ROVISION No.66 / Summer 2010   93
                                                                                 LVM


                                                                    db2 export/load
                                                                                                              backup/
                                                            HBA   restore
     FibreChannel                       SAN
                                                       HA         LVM                    DB2
                    DLPAR
       HBA        SAN                                                                                  DB2    backup/
                                                                     restore



                                      DB2
                  AIX                                       DB2


               2004                       2009
                             DB2 V8.2                       AIX
           AIX V6
                         DB2                     AIX
                                          export/load               DB2        backup/restore   export/load



                                                                                                 LVM


                                                                                  14
      db2 backup/restore                 Q




94   P ROVISION No.66 / Summer 2010
                                    1   IBM, AIX Logical Volume Manager from A to Z: Introduction and
                                        Concepts, ITSO Redbook, SG24-5432-00, pp. 101-136 (2000).
                                    2   DB2 Version 9.5 for Linux, UNIX, and Windows
                                              , GC88-4438-02, pp. 75-82 (2009).
                                    3   DB2 Version 9.5 for Linux, UNIX, and Windows
                                              , GC88-4438-02, pp. 85-87 (2009).
                                    4   DB2 Version 9.5 for Linux, UNIX, and Windows
                                              , GC88-4438-02, pp. 21 (2009).
                                    5                                  : DB2 24       365
                                                                          PROVISION No.45 pp. 83-89
                          AIX LVM       (2005).
                                    6   WebSphere MQ: http://www-06.ibm.com/software/jp/websphere/
                                        integration/wmq/ (2010.06.01).
                                    7   IBM InfoSphere Replication Server IBM InfoSphere Data Event
            AIX LVM                     Publisher           9.7
               DB2                                     , SC88-4191-02, pp. 102-104 (2009).
                                    8   IBM PowerHA SystemMirror for AIX: http://www.ibm.com/
                                        systems/jp/power/software/ha/ (2010.05.27).




             ISE
      ACP      ITS    STH
GBS             ITS


                                                                   Yohei Noguchi




        Norifumi Kanda

                                                                   Toshiaki Sota




                                                                   Kunio Arai
        Kazumi Yamamoto




                                                                      P ROVISION No.66 / Summer 2010    95

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:5
posted:6/23/2012
language:English
pages:8