1. Community Tip: Please Give Thanks to Those Sharing Their Knowledge.
    If you receive helpful answer on this forum, please show thanks to the poster by clicking "LIKE" link for the answer that you found helpful.
  2. Community Tip: Forum Rules (PLEASE CLICK HERE TO READ BEFORE POSTING)
    Click the link above 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 notice will disappear after you have made at least 3 posts.

DBbackup DBsnapshot tapes not expiring

Discussion in 'Disaster Recovery Module' started by dubweiser, Mar 31, 2016.

  1. dubweiser

    dubweiser Active Newcomer

    Joined:
    Nov 1, 2011
    Messages:
    6
    Likes Received:
    0
    Occupation:
    Systems Administrator
    Location:
    Baltimore, Md
    I've recently acquired a TSM environment (7.1.1) with a huge stack of VTL tapes on a DataDomain. It's been a few years since i've used TSM and my prior experience was with disk and file pools and physical tapes for DR. That being said, I've found that we have a TON of database backups (VTL tapes and physical tapes).

    I should note that when they moved from physical tapes to the DD VTL solution, they called back all of their physical tapes which are now sitting in a box in the datacenter. I suspect they didn't do anything in TSM to basically expire the data and remove those physical tapes from the TSM inventory.

    I found this KB article: http://www-01.ibm.com/support/docview.wss?uid=swg21584678
    But I'm not sure if changing their state from Mountable to Vault is the right thing to do since they are VTL tapes.

    Here's what i'm working with: (Note: "DDLIB" tapes are obviously DD VTL tapes)


    tsm: TSM01>q drm source=dbbackup

    Volume Name State Last Update Automated
    Date/Time LibName
    ---------------- ----------------- ------------------- ----------------
    B00006L4 Vault 07/09/2013 08:15:01
    B00008L4 Vault 11/26/2013 09:24:34
    B00017L4 Vault 02/28/2014 09:56:36
    B00018L4 Vault 07/06/2011 14:27:05
    B00019L4 Vault 02/27/2014 08:46:12
    B00033L4 Vault retrieve 06/03/2013 08:38:34
    B00041L4 Vault 03/10/2014 08:09:48
    B00052L4 Vault 02/21/2014 08:18:08
    B00057L4 Vault 08/05/2013 08:47:31
    B00073L4 Vault 08/21/2013 08:52:11
    B00074L4 Vault retrieve 06/11/2014 08:24:01
    B00075L4 Vault retrieve 12/05/2012 08:53:31
    B00078L4 Vault retrieve 08/01/2013 14:35:09
    B00082L4 Vault 02/25/2014 12:43:09
    B00086L4 Vault 03/05/2014 13:54:33
    B00095L4 Vault retrieve 06/18/2014 09:01:49
    B00121L4 Vault 05/01/2014 07:58:09
    B00122L4 Vault 06/25/2014 10:33:10
    B00133L4 Vault 12/04/2013 14:30:22
    B00134L4 Vault retrieve 09/20/2013 16:31:55
    B00137L4 Vault retrieve 07/15/2013 16:23:16
    B00139L4 Vault retrieve 07/11/2013 09:15:26
    B00144L4 Vault 01/20/2014 15:22:05
    B00149L4 Vault retrieve 06/02/2014 13:05:29
    B00151L4 Vault retrieve 05/29/2013 08:36:31
    B00152L4 Vault 12/10/2013 15:37:23
    B00154L4 Vault retrieve 01/20/2014 15:22:35
    B00156L4 Courier retrieve 08/14/2013 16:09:39
    B00158L4 Vault retrieve 12/18/2013 12:29:57
    B00167L4 Vault 12/26/2013 08:15:16
    B00168L4 Vault 07/26/2013 13:36:26
    B00169L4 Vault 09/09/2013 09:36:08
    B00170L4 Vault 08/05/2013 08:48:00
    B00173L4 Vault 03/03/2014 16:03:43
    B00176L4 Vault retrieve 03/10/2014 08:11:19
    B00182L4 Vault 03/06/2014 09:46:42
    B00187L4 Vault 03/03/2014 08:19:38
    B00189L4 Vault 08/26/2013 15:08:07
    B00190L4 Vault 03/07/2014 08:40:33
    B00191L4 Vault 10/14/2013 09:46:56
    B00194L4 Vault retrieve 11/11/2013 14:49:46
    B00195L4 Vault retrieve 02/19/2014 09:15:49
    B00196L4 Vault 02/03/2014 11:35:50
    B00198L4 Vault 03/24/2014 08:11:38
    B00199L4 Vault retrieve 06/28/2013 09:01:24
    B00200L4 Vault retrieve 06/28/2013 09:01:57
    B00201L4 Vault retrieve 07/23/2013 10:10:10
    B00202L4 Vault 02/21/2014 16:34:21
    B00203L4 Vault 03/06/2014 09:48:11
    B00204L4 Vault 02/18/2014 10:40:12
    B00215L4 Vault 03/31/2014 08:01:26
    B00217L4 Vault 02/21/2014 16:35:52
    W00119L4 Mountable 03/31/2016 03:00:25 DDLIB
    W00116L4 Mountable 03/30/2016 03:00:27 DDLIB
    W00113L4 Mountable 03/29/2016 03:00:30 DDLIB
    W00112L4 Mountable 03/28/2016 03:00:31 DDLIB
    W00109L4 Mountable 03/27/2016 03:00:04 DDLIB
    W00107L4 Mountable 03/26/2016 03:00:07 DDLIB
    W00106L4 Mountable 03/25/2016 03:00:10 DDLIB
    W00105L4 Mountable 03/24/2016 03:00:23 DDLIB
    W00102L4 Mountable 03/23/2016 03:00:25 DDLIB
    W00101L4 Mountable 03/22/2016 03:00:27 DDLIB
    W00099L4 Mountable 03/21/2016 03:00:29 DDLIB
    W00094L4 Mountable 03/20/2016 03:00:02 DDLIB
    W00091L4 Mountable 03/19/2016 03:00:06 DDLIB
    W00090L4 Mountable 03/18/2016 03:00:03 DDLIB
    W00089L4 Mountable 03/17/2016 03:00:05 DDLIB
    W00088L4 Mountable 03/16/2016 03:00:08 DDLIB
    W00084L4 Mountable 03/15/2016 03:00:11 DDLIB
    W00081L4 Mountable 03/14/2016 03:00:10 DDLIB
    W00077L4 Mountable 03/13/2016 03:00:14 DDLIB
    W00076L4 Mountable 03/12/2016 03:00:16 DDLIB
    W00074L4 Mountable 03/11/2016 03:00:18 DDLIB
    W00072L4 Mountable 03/10/2016 03:00:07 DDLIB
    W00071L4 Mountable 03/09/2016 03:00:10 DDLIB
    W00070L4 Mountable 03/08/2016 03:00:08 DDLIB
    W00069L4 Mountable 03/07/2016 03:00:09 DDLIB
    W00068L4 Mountable 03/06/2016 03:00:08 DDLIB
    W00065L4 Mountable 03/05/2016 03:00:08 DDLIB
    W00064L4 Mountable 03/04/2016 03:00:08 DDLIB
    W00063L4 Mountable 03/03/2016 03:00:09 DDLIB
    W00061L4 Mountable 03/02/2016 03:00:14 DDLIB
    W00060L4 Mountable 03/01/2016 03:00:14 DDLIB
    W00059L4 Mountable 02/29/2016 03:00:14 DDLIB
    W00058L4 Mountable 02/28/2016 03:00:14 DDLIB
    W00057L4 Mountable 02/27/2016 03:00:14 DDLIB
    W00054L4 Mountable 02/26/2016 03:00:14 DDLIB
    W00053L4 Mountable 02/25/2016 03:00:14 DDLIB
    W00052L4 Mountable 02/24/2016 03:00:13 DDLIB
    W00051L4 Mountable 02/23/2016 03:00:14 DDLIB
    W00049L4 Mountable 02/22/2016 03:00:13 DDLIB
    W00048L4 Mountable 02/21/2016 03:00:13 DDLIB
    W00045L4 Mountable 02/20/2016 03:00:12 DDLIB
    W00044L4 Mountable 02/19/2016 03:00:12 DDLIB
    W00042L4 Mountable 02/18/2016 03:00:13 DDLIB
    W00041L4 Mountable 02/17/2016 03:00:12 DDLIB
    W00035L4 Mountable 02/16/2016 03:00:12 DDLIB
    W00034L4 Mountable 02/15/2016 03:00:11 DDLIB
    W00033L4 Mountable 02/14/2016 03:00:11 DDLIB
    W00032L4 Mountable 02/13/2016 03:00:11 DDLIB
    W00031L4 Mountable 02/12/2016 03:00:11 DDLIB
    W00029L4 Mountable 02/11/2016 03:00:13 DDLIB
    W00028L4 Mountable 02/10/2016 03:00:13 DDLIB
    W00026L4 Mountable 02/09/2016 03:00:13 DDLIB
    W00024L4 Mountable 02/08/2016 03:00:13 DDLIB
    W00023L4 Mountable 02/07/2016 03:00:13 DDLIB
    W00021L4 Mountable 02/06/2016 03:00:13 DDLIB
    W00019L4 Mountable 02/05/2016 03:00:12 DDLIB
    W00018L4 Mountable 02/04/2016 03:00:19 DDLIB
    W00017L4 Mountable 02/03/2016 03:00:19 DDLIB
    W00016L4 Mountable 02/02/2016 03:00:19 DDLIB
    W00014L4 Mountable 02/01/2016 03:00:19 DDLIB
    W00009L4 Mountable 01/31/2016 03:00:19 DDLIB
    W00004L4 Mountable 01/30/2016 03:00:18 DDLIB
    W00003L4 Mountable 01/29/2016 03:00:18 DDLIB
    W00000L4 Mountable 01/28/2016 03:00:19 DDLIB
    W00199L4 Mountable 01/27/2016 03:00:17 DDLIB
    W00198L4 Mountable 01/26/2016 03:00:16 DDLIB
    W00196L4 Mountable 01/25/2016 03:00:16 DDLIB
    W00195L4 Mountable 01/24/2016 03:00:17 DDLIB
    W00192L4 Mountable 01/23/2016 03:00:16 DDLIB
    W00187L4 Mountable 01/22/2016 03:00:16 DDLIB
    W00181L4 Mountable 01/21/2016 03:00:15 DDLIB
    W00179L4 Mountable 01/20/2016 03:00:15 DDLIB
    W00174L4 Mountable 01/19/2016 03:00:15 DDLIB
    W00171L4 Mountable 01/18/2016 03:00:15 DDLIB
    W00169L4 Mountable 01/17/2016 03:00:15 DDLIB
    W00168L4 Mountable 01/16/2016 03:00:18 DDLIB
    W00165L4 Mountable 01/15/2016 03:00:16 DDLIB
    W00150L4 Mountable 01/14/2016 03:00:15 DDLIB
    W00140L4 Mountable 01/13/2016 03:00:15 DDLIB
    W00122L4 Mountable 01/09/2016 03:00:22 DDLIB
    W00118L4 Mountable 01/08/2016 03:00:22 DDLIB
    W00115L4 Mountable 01/07/2016 03:00:22 DDLIB
    W00110L4 Mountable 01/06/2016 03:00:22 DDLIB
    W00108L4 Mountable 01/05/2016 03:00:22 DDLIB
    W00098L4 Mountable 01/04/2016 03:00:22 DDLIB
    W00092L4 Mountable 01/03/2016 03:00:22 DDLIB
    W00087L4 Mountable 01/02/2016 03:00:22 DDLIB
    W00085L4 Mountable 01/01/2016 03:00:22 DDLIB
    W00083L4 Mountable 12/31/2015 03:00:22 DDLIB
    W00082L4 Mountable 12/30/2015 03:00:23 DDLIB
    W00080L4 Mountable 12/29/2015 11:57:49 DDLIB
    W00008L4 Mountable 10/17/2015 03:01:27 DDLIB

    tsm: TSM01>q drm source=dbsnapshot

    Volume Name State Last Update Automated
    Date/Time LibName
    ---------------- ----------------- ------------------- ----------------
    B00006L4 Vault 07/09/2013 08:15:01
    B00008L4 Vault 11/26/2013 09:24:34
    B00017L4 Vault 02/28/2014 09:56:36
    B00018L4 Vault 07/06/2011 14:27:05
    B00019L4 Vault 02/27/2014 08:46:12
    B00033L4 Vault retrieve 06/03/2013 08:38:34
    B00041L4 Vault 03/10/2014 08:09:48
    B00052L4 Vault 02/21/2014 08:18:08
    B00057L4 Vault 08/05/2013 08:47:31
    B00073L4 Vault 08/21/2013 08:52:11
    B00074L4 Vault retrieve 06/11/2014 08:24:01
    B00075L4 Vault retrieve 12/05/2012 08:53:31
    B00078L4 Vault retrieve 08/01/2013 14:35:09
    B00082L4 Vault 02/25/2014 12:43:09
    B00086L4 Vault 03/05/2014 13:54:33
    B00095L4 Vault retrieve 06/18/2014 09:01:49
    B00121L4 Vault 05/01/2014 07:58:09
    B00122L4 Vault 06/25/2014 10:33:10
    B00133L4 Vault 12/04/2013 14:30:22
    B00134L4 Vault retrieve 09/20/2013 16:31:55
    B00137L4 Vault retrieve 07/15/2013 16:23:16
    B00139L4 Vault retrieve 07/11/2013 09:15:26
    B00144L4 Vault 01/20/2014 15:22:05
    B00149L4 Vault retrieve 06/02/2014 13:05:29
    B00151L4 Vault retrieve 05/29/2013 08:36:31
    B00152L4 Vault 12/10/2013 15:37:23
    B00154L4 Vault retrieve 01/20/2014 15:22:35
    B00156L4 Courier retrieve 08/14/2013 16:09:39
    B00158L4 Vault retrieve 12/18/2013 12:29:57
    B00167L4 Vault 12/26/2013 08:15:16
    B00168L4 Vault 07/26/2013 13:36:26
    B00169L4 Vault 09/09/2013 09:36:08
    B00170L4 Vault 08/05/2013 08:48:00
    B00173L4 Vault 03/03/2014 16:03:43
    B00176L4 Vault retrieve 03/10/2014 08:11:19
    B00182L4 Vault 03/06/2014 09:46:42
    B00187L4 Vault 03/03/2014 08:19:38
    B00189L4 Vault 08/26/2013 15:08:07
    B00190L4 Vault 03/07/2014 08:40:33
    B00191L4 Vault 10/14/2013 09:46:56
    B00194L4 Vault retrieve 11/11/2013 14:49:46
    B00195L4 Vault retrieve 02/19/2014 09:15:49
    B00196L4 Vault 02/03/2014 11:35:50
    B00198L4 Vault 03/24/2014 08:11:38
    B00199L4 Vault retrieve 06/28/2013 09:01:24
    B00200L4 Vault retrieve 06/28/2013 09:01:57
    B00201L4 Vault retrieve 07/23/2013 10:10:10
    B00202L4 Vault 02/21/2014 16:34:21
    B00203L4 Vault 03/06/2014 09:48:11
    B00204L4 Vault 02/18/2014 10:40:12
    B00215L4 Vault 03/31/2014 08:01:26
    B00217L4 Vault 02/21/2014 16:35:52
     
  2.  
  3. moon-buddy

    moon-buddy ADSM.ORG Moderator

    Joined:
    Aug 24, 2005
    Messages:
    6,814
    Likes Received:
    358
    Occupation:
    Electronics Engineer, Security Professional
    Location:
    Somewhere in the US
    Working with VTL is no different than a Physical TL or PTL.

    Using DRM to manage the "tapes" calls for the same procedure except that you don't physically remove tapes - instead, you just virtually remove them.

    Reuse times applies as well between VTL and PTL.
     
  4. dubweiser

    dubweiser Active Newcomer

    Joined:
    Nov 1, 2011
    Messages:
    6
    Likes Received:
    0
    Occupation:
    Systems Administrator
    Location:
    Baltimore, Md
    Got it. So should I just follow the KB and change their state from Mountable to Vault (MOVE DRM wherestate=mountable tostate=vault) and then run expiration?

    I'm curious if that will actually work since there are DBbackups that are already in the Vault state with a last update date/time of 2013/2014??
     
  5. moon-buddy

    moon-buddy ADSM.ORG Moderator

    Joined:
    Aug 24, 2005
    Messages:
    6,814
    Likes Received:
    358
    Occupation:
    Electronics Engineer, Security Professional
    Location:
    Somewhere in the US
    If the DB Expire settings are set correctly, then the 'old' backups should be retrievable, zero in size and can be checked in as scratch.
     
  6. dubweiser

    dubweiser Active Newcomer

    Joined:
    Nov 1, 2011
    Messages:
    6
    Likes Received:
    0
    Occupation:
    Systems Administrator
    Location:
    Baltimore, Md
    What specific expiration settings should I be looking for, and how can I see them? The KB simply states "EXPIRE INV Type=Other " with no other options/flags
     
  7. moon-buddy

    moon-buddy ADSM.ORG Moderator

    Joined:
    Aug 24, 2005
    Messages:
    6,814
    Likes Received:
    358
    Occupation:
    Electronics Engineer, Security Professional
    Location:
    Somewhere in the US
    help q drmstatus
     

Share This Page