Question about DB backup, del volhist and DRM...

[yilas]

Hello,



I have a question about the backup of the TSM DB.

First, I use TSM vers. 5.3 on windows 2000 server and I try to use DRM



The configuration of DRM is (for the DB section) :

. set DRMDBBACKUPEXPIREDAYS 1



Now every day, I have scheduled the following action :

. delete volhistory type=dbbackup todate=today-1



Note that I used 1 day but it is only a test.



My question is :

When I make a backup of the DB on the class <LTOCLASS> (which is a class used to manage LTO tapes) and I make a move drmedia, the tape doesn't come back to the state "onsite".

Where is the mistake ?

[Benoit]

Hi



extract from : dsmadmc help delete volhistory :





5. For users of DRM, the database backup expiration should be controlled

with the SET DRMDBBACKUPEXPIREDAYS command instead of this DELETE

VOLHISTORY command. Using the DELETE VOLHISTORY command removes Tivoli

Storage Manager's record of the volume. This can cause volumes to be

lost that were managed by the MOVE DRMEDIA command. The recommended way

to manage the automatic expiration of DRM database backup volumes is by

using the SET DRMDBBACKUPEXPIREDAYS command.



Hope this helps

[yilas]

Thank you Benoit.

Now my question is : Is it possible to save the DB on tape and on the disk ?



Cordially,



Yann

[chad_small]

TSM requires at least 1 DB backup in volhist so no matter what you state in the delete volhistory it will not delete the most current FULL (and any corresponding INCREMENTALS). Also when you backup the DB and do a move DRMedia the tape wont come back to the ONSITE state until it is scratch and checked back into the library as such. You'll daily need to generate a list of tapes in the VAULTRETRIEVE state to bring back then move them to the ONSITERETRIEVE state and they can be checked in and reused as scratch.



Q DRM * SO=DBB WHERESTATE=VAULTR



Give the list from this query to IRON MOUNTAIN or whoever handles your offsite tapes to bring back for reuse. Once back onsite use this command:



MOVE DRM * SO=DBB WHERESTATE=VAULTR TOSTATE=ONSITERETRIEVE

[noodles]

Hi,

I didn't want to start a new thread for this topic.
Just a simple question:

When using the "SET DRMDBBACKUPEXPIREDAYS" option and using DRM when does DRM expire the DBBackups?
So what command causes the expirey?
I don't use DRM script automatically but run the commands manually once a week.

Regards
/noodles

[BBB]

Noodles I think its when you run "MOVE DRMEDIA" that it expires ones that can be expired.

Edit: I checked and its "move drmedia" when they're real vols, or its "expire inventory" when they're virtual vols.