Professional Web Applications Themes

log shipping tables - IBM DB2

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...

  1. #1

    Default 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
    Peter Guest

  2. #2

    Default 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:
     

    Blair Guest

  3. #3

    Default Re: log shipping tables



    Blair Adamache wrote:
     [/ref]

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

    Fan Guest

  4. #4

    Default 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.
    Paul Guest

  5. #5

    Default 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:
     

    Fan Guest

Similar Threads

  1. Shipping rates
    By Shawn in forum ASP
    Replies: 1
    Last Post: August 21st, 02:49 PM
  2. Log shipping
    By Madison Pruet in forum Informix
    Replies: 0
    Last Post: August 5th, 06:56 PM
  3. B&H shipping
    By Ron Goodman in forum Photography
    Replies: 0
    Last Post: July 11th, 05:09 PM
  4. A70 shipping problems?
    By Herman Kikkert in forum Photography
    Replies: 2
    Last Post: July 11th, 06:46 AM
  5. UPS Shipping
    By Mark Hewitt in forum PHP Development
    Replies: 2
    Last Post: June 30th, 11:02 AM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139