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.

Significance of STGNEW,STGDELETE,STGREUSE volume history entries

Discussion in 'Disaster Recovery Module' started by anandgmenon, Apr 2, 2012.

  1. anandgmenon

    anandgmenon New Member

    Joined:
    Jun 27, 2011
    Messages:
    97
    Likes Received:
    0
    Hi Team

    Our environment uses TSM6.2 Server.

    Can anyone explain the significance of STGNEW,STGDELETE,STGREUSE in volume history. Is it still relevant in TSM 6.2 ???

    We backup Database every day and just before the database backup, We use the following script "delvolh" daily to clear out the Volume history entries

    Name Line Command
    Number
    ---------- ------ ------------------------------------------------------------
    DELVOLH 5 del volh tod=today t=DBS
    10 del volh tod=today t=STGN
    15 del volh tod=today t=STGR
    20 del volh tod=today t=STGD
    25 del volh tod=today t=DBB

    The script is run in the follwing order

    1 ba stg disk offsite w=y
    5 ba stg onsite offsite w=y
    10 ru delvolh ( Volume history deletion script )
    15 ba db dev=lto5 t=dbs w=y
    20 ru delvolh ( Volume history deletion script )
    25 ba db dev=lto5 t=f w=y
    30 ru delvolh ( Volume history deletion script )
    35 ba volh filename=/home/pzatsm/recoverydir/volhist.out
    40 ba devconf filename=/home/pzatsm/recoverydir/devconf.out

    Please confirm if this is ok ???
     
  2.  
  3. moon-buddy

    moon-buddy Moderator

    Joined:
    Aug 24, 2005
    Messages:
    6,256
    Likes Received:
    282
    Occupation:
    Electronics Engineer, Security Professional
    Location:
    Somewhere in the US
    Do you use DRM? If you use DRM, you should not be using DEL VOLHIST.

    STGNEW - new volume added to a stgpool
    STGDELETE - deleted volume from a stgpool
    STGREUSE - scratch tapes


    They are all relevant in TSM even for 6.2

    Your script looks fine but 'del volhist' removed IF you use DRM.
     
  4. sjl

    sjl Member

    Joined:
    Oct 30, 2007
    Messages:
    92
    Likes Received:
    12
    Location:
    Australia
    I'd amend moon-buddy's comments slightly. DEL VOLHIST on STGNEW, STGDELETE, and STGREUSE is not unreasonable (in my opinion, in the general case), but on DB backups, it certainly is a bad thing if you use DRM; I would be using DRM to manage the cycling of database backup tapes, rather than relying on volume history manipulations.

    Why? Simply put: tape leaks. If you do a DEL VOLHIST TYPE=DBB, it circumvents the normal DRM expiration process, and forcibly removes all record of the database backup(s) in question. Unless you have other ways to track DR volumes, that means that you lose track of those tapes. Extremely dodgy.
     
  5. anandgmenon

    anandgmenon New Member

    Joined:
    Jun 27, 2011
    Messages:
    97
    Likes Received:
    0
    Hi Moon-buddy,

    We use DRM..

    We run the script everyday in Production after all the backups and move the copy tapes to DR Site nearby

    We do a DR restore on the same day on a daily basis.

    Hope this is fine. Please confirm.
     
  6. sjl

    sjl Member

    Joined:
    Oct 30, 2007
    Messages:
    92
    Likes Received:
    12
    Location:
    Australia
    Then I would ditch - completely - the line that says "del volh tod=today t=DBB", and amend the other del volh commands to keep at least a few days - a month, perhaps, or even two - worth of volume history. The DBS history entries should also not be deleted. Use the MOVE DRM command to manage the offsite tapes instead, and look into the DB expiration option in the DRM options (QUERY DRMSTATUS will tell you what it's set to, and the help for that command will give you other relevant commands; sorry, I'm not in front of TSM right now.)
     
  7. anandgmenon

    anandgmenon New Member

    Joined:
    Jun 27, 2011
    Messages:
    97
    Likes Received:
    0
    Hi Sjl,

    Every day in DR we do a point in time restore of the latest TSM DB and then proceed with the DR Client restores.

    This ensures that DR and Production are having the same data backup.

    I hope this is perfect. . Is it not ???
     
  8. moon-buddy

    moon-buddy Moderator

    Joined:
    Aug 24, 2005
    Messages:
    6,256
    Likes Received:
    282
    Occupation:
    Electronics Engineer, Security Professional
    Location:
    Somewhere in the US
    As mentioned - get away from del volhist for the DB volumes -

    What a tedious way of syncing your systems. There are more effecient and less tedious ways of doing this.
     

Share This Page