log shipping tables

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Peter Sands
    #1

    log shipping tables

    Hi,
    If I implement log shipping, will tables created on the master server
    be created on the stand-by server when the logs are shipped and are
    rolled forward. Or do I have to do a regular DB load to take care of
    this ?

    aix 5.2
    db2 v8.1
    thanks
    PS
    Tags: None
    • Blair Adamache
      #2
      Re: log shipping tables

      We have an article on log shipping here:

      http://www7b.boulder.ibm.com/dmdd/library/techarticle/0304mcinnis/0304mcinnis.html


      I suspect that DDL will be okay, but that it will be much smoother if
      the entire dataabase and tables are already created, and you're only
      rolling forward through the DML.

      Peter Sands wrote:
      [color=blue]
      > Hi,
      > If I implement log shipping, will tables created on the master server
      > be created on the stand-by server when the logs are shipped and are
      > rolled forward. Or do I have to do a regular DB load to take care of
      > this ?
      >
      > aix 5.2
      > db2 v8.1
      > thanks
      > PS[/color]

        Comment

        • Fan Ruo Xin
          #3
          Re: log shipping tables



          Blair Adamache wrote:
          [color=blue]
          > We have an article on log shipping here:
          >
          > http://www7b.boulder.ibm.com/dmdd/li...04mcinnis.html
          >
          > I suspect that DDL will be okay, but that it will be much smoother if
          > the entire dataabase and tables are already created, and you're only
          > rolling forward through the DML.
          >
          > Peter Sands wrote:
          >[color=green]
          > > Hi,
          > > If I implement log shipping, will tables created on the master server
          > > be created on the stand-by server when the logs are shipped and are
          > > rolled forward. Or do I have to do a regular DB load to take care of
          > > this ?
          > >
          > > aix 5.2
          > > db2 v8.1
          > > thanks
          > > PS[/color][/color]

          Yes, the rolling forward process will take care of this.

            Comment

            • Paul Reddin
              #4
              Re: log shipping tables

              Hi,

              One gotcha (highlighted in the article too) that I remember is
              creating indexes (DDL ?) on the primary system aren't created on the
              secondary during the roll-forward etc.....

              Paul.

                Comment

                • Fan Ruo Xin
                  #5
                  Re: log shipping tables

                  Thanks Paul to point this out.
                  I am wondering why?
                  DB2 UDB INDEX REBUILD is different with that in the other dbms. But I
                  thought the DDL (CREATE INDEX) is not the exactly the same thing as
                  INDEX REBUILD.
                  Regards,
                  Fan

                  Paul Reddin wrote:
                  [color=blue]
                  >Hi,
                  >
                  >One gotcha (highlighted in the article too) that I remember is
                  >creating indexes (DDL ?) on the primary system aren't created on the
                  >secondary during the roll-forward etc.....
                  >
                  >Paul.
                  >
                  >[/color]

                    Comment

                    Previous template Next
                    Working...