• Please help support our sponsors by considering their products and services.
    Our sponsors enable us to serve you with this high-speed Internet connection and fast webservers you are currently using at ADSM.ORG.
    They support this free flow of information and knowledge exchange service at no cost to you.

    Please welcome our latest sponsor Tectrade . We can show our appreciation by learning more about Tectrade Solutions
  • 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.

  • 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

dubweiser

Active Newcomer
#1
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
 

moon-buddy

ADSM.ORG Moderator
#2
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.
 

dubweiser

Active Newcomer
#3
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??
 

moon-buddy

ADSM.ORG Moderator
#4
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??
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.
 

dubweiser

Active Newcomer
#5
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
 

Advertise at ADSM.ORG

If you are reading this, so are your potential customer. Advertise at ADSM.ORG right now.

UpCloud high performance VPS at $5/month

Get started with $25 in credits on Cloud Servers. You must use link below to receive the credit. Use the promo to get upto 5 month of FREE Linux VPS.

The Spectrum Protect TLA (Three-Letter Acronym): ISP or something else?

  • Every product needs a TLA, Let's call it ISP (IBM Spectrum Protect).

    Votes: 8 21.6%
  • Keep using TSM for Spectrum Protect.

    Votes: 19 51.4%
  • Let's be formal and just say Spectrum Protect

    Votes: 6 16.2%
  • Other (please comement)

    Votes: 4 10.8%

Forum statistics

Threads
30,967
Messages
131,778
Members
21,224
Latest member
alexp36
Top