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.

Help! TSM DB backups consumed all my scratch volumes!

Discussion in 'TSM Database' started by higgies, Dec 17, 2009.

  1. higgies

    higgies New Member

    Joined:
    Dec 17, 2009
    Messages:
    4
    Likes Received:
    0
    Hi There!

    I have a single storage pool for tape that is in use with Windows HSM. It's allowed to take up to 50 volumes from scratch to use for storage.

    My daily admin script to backup the DB is configured to also use scratch volumes. It has now taken up 43 of my 64 volumes total!! How can I reconfigure the script to take from a list of volumes instead, and allocate those volumes outside of scratch?? My HSM has stopped working and is rapidly filling the disk cache now that the TSM server can't take in the data.

    Thanks in advance!!
     
  2.  
  3. jbautista

    jbautista New Member

    Joined:
    Apr 11, 2007
    Messages:
    306
    Likes Received:
    2
    Are you using DRM? If not, use a "del volhist" command to make some of your old db backup tape to scratch.
     
  4. higgies

    higgies New Member

    Joined:
    Dec 17, 2009
    Messages:
    4
    Likes Received:
    0
    Thanks for the reply! How do I determine which volumes are the latest, so as not to delete that volhist?
     
  5. jbautista

    jbautista New Member

    Joined:
    Apr 11, 2007
    Messages:
    306
    Likes Received:
    2
    issue "q volhist" and you will see the date of backup. delete volhist will not delete the latest backup. look in the admin reference guide for the "delete volhist" command and you will pretty much have an idea after reading it or issue help delete volhist from the tsm command line
     
  6. higgies

    higgies New Member

    Joined:
    Dec 17, 2009
    Messages:
    4
    Likes Received:
    0
    Got it! Thanks! Can I add this as a admin script to delete backups older than a period of time?

    In order to get here, I did the following:

    del volhist date=today-7 type=DbBackup
     
  7. jbautista

    jbautista New Member

    Joined:
    Apr 11, 2007
    Messages:
    306
    Likes Received:
    2
    yes, this means you only retaining 7 days of dbbackup.
     
  8. higgies

    higgies New Member

    Joined:
    Dec 17, 2009
    Messages:
    4
    Likes Received:
    0
    Great. Thanks for the fast response. I really appreciate it, and am very impressed with the forum. Glad I found the right place to be!
    :):)
     

Share This Page