1. Forum Rules (PLEASE CLICK HERE TO READ BEFORE POSTING) Click the link to access ADSM.ORG Acceptable Use Policy and forum rules which should be observed when using this website. Violators may be banned from this website. This message will disappear after you have made at least 12 posts. Thank you for your cooperation.

TSM 6.3 DB Hardware Replication

Discussion in 'TSM Server' started by robinsonjas, Jun 8, 2012.

  1. robinsonjas

    robinsonjas New Member

    Joined:
    Nov 1, 2006
    Messages:
    19
    Likes Received:
    0
    Does anyone have experience replication at the hardware level the db/log vols for TSM 6.3?
    We want to 'quiesce' the database and perform a hardware level snapshot (i.e. SVC Flashcopy...etc) and recover the TSM database on another server @ DR. We do this in Oracle today but have questions about the quiesce piece of TSM and how/if it's possible to leave TSM up when the flash is taken. Any tips are greatly appreciated.

    Thanks in advance.
     
  2.  
  3. park0624

    park0624 New Member

    Joined:
    Feb 2, 2004
    Messages:
    2
    Likes Received:
    0
    that's a great question. I too would be interested as to how to do this.!!
     
  4. moon-buddy

    moon-buddy Moderator

    Joined:
    Aug 24, 2005
    Messages:
    6,206
    Likes Received:
    279
    Occupation:
    Electronics Engineer, Security Professional
    Location:
    Somewhere in the US
    To 'quiesce' TSM DB means to shutdown TSM.

    I replicate the DB2 instance BUT from a PIT basis - DBB full backups.

    If you really want to replicate the DB2 instance, why don't you just use mirroring instead of using SVC? Mirror the dbspace with the remote site. Caveat? watch out for propagation delays and mirror 'site' distances.
     
  5. robinsonjas

    robinsonjas New Member

    Joined:
    Nov 1, 2006
    Messages:
    19
    Likes Received:
    0
    We do PIT DBB daily, but recover from tape @ DR. Latency is our concern w/ mirror, which is why we have chosen the snap/sync approach. We've tested multiple dirty flashcopies w/ SVC and DB2 does crash recovery and comes up...admittedly not the greatest method though.
     
  6. moon-buddy

    moon-buddy Moderator

    Joined:
    Aug 24, 2005
    Messages:
    6,206
    Likes Received:
    279
    Occupation:
    Electronics Engineer, Security Professional
    Location:
    Somewhere in the US
    Then the only choice (short of crashing the DB2 instance) is to stop the TSM server while doing a copy.

    Another way is to have a local mirror, break the mirror (I believe you can do this on the fly with DB2), and replicate the mirror to the remote site. Still is not 'live' but will shorten the PIT gaps considerably.
     
  7. robinsonjas

    robinsonjas New Member

    Joined:
    Nov 1, 2006
    Messages:
    19
    Likes Received:
    0
    So what affect does the DB2 quiesce have on TSM?

    I wonder if something like this might work:

    db2 connect to tsmdb1
    db2 quiesce database immediate force connections
    db2 connect reset

    *flash*

    db2 connect to tsmdb1
    db2 unquiesce database
     
  8. moon-buddy

    moon-buddy Moderator

    Joined:
    Aug 24, 2005
    Messages:
    6,206
    Likes Received:
    279
    Occupation:
    Electronics Engineer, Security Professional
    Location:
    Somewhere in the US
    My understanding is that TSM stops working (may crash) when the DB is quiesce when it is busy. You may get away with this when there is no load.
     

Share This Page