All, I'm running some tests now ... and it looks like the volumes stay in VAULTRETRIEVE status as they should. I guess what might have happened is that we may have changed the state and caused the volumes to disappear. I will do some more testing, and IF I find anything amiss, I will update the listserv. For now, please treat the previous notes as the "premature ranting of a madman". Sorry. Glenn -----Original Message----- From: Prather, Wanda [mailto:[EMAIL PROTECTED]] Sent: Friday, April 13, 2001 1:54 PM To: [EMAIL PROTECTED] Subject: Re: Question on del volhist OK, I ran a DELETE VOLHIST for all record types all the way back to January. I checked on the oldest volumes in my OFFSITE copypool, which are marked VAULT by DRM. They no longer have ANY entry in the volume history file; running select * from volhistory where volume_name='xxxxxx' gets no hits at all, but Q DRMEDIA * still shows that volume xxxxxx is marked VAULT. So I still believe that removing STGNEW/STGDELETE via DELETE VOLHIST has NO effect on storage pool volumes. But it will make to "disappear" volumes that are tracked ONLY via VOLUMEHISTORY, including DBBACKUP, DBSNAPSHORT, and EXPORT entries. ************************************************************************ Wanda Prather The Johns Hopkins Applied Physics Lab 443-778-8769 [EMAIL PROTECTED] "Intelligence has much less practical application than you'd think" - Scott Adams/Dilbert ************************************************************************ -----Original Message----- From: Kelly J. Lipp [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 12, 2001 12:12 PM To: [EMAIL PROTECTED] Subject: Re: Question on del volhist This was not my observation, but rather that of Glenn MacIntosh. I don't know if this is what happens or not. Glenn had responded to me and not to the list so I thought I'd post his reply to garner further input on the assertion. I wouldn't think deleting volhist records would cause this to happen in DRM. Kelly J. Lipp Storage Solutions Specialists, Inc. PO Box 51313 Colorado Springs CO 80949-1313 (719) 531-5926 Fax: (240) 539-7175 Email: [EMAIL PROTECTED] or [EMAIL PROTECTED] www.storsol.com www.storserver.com -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of Prather, Wanda Sent: Thursday, April 12, 2001 9:57 AM To: [EMAIL PROTECTED] Subject: Re: Question on del volhist Yikes, I didn't know that! Thanks for pointing it out. If you think you have tapes disappearing and don't want to do a manual audit, you can write an audit program/script. 1)Pull a list of tapes that are physically in the library: q libv 2)Pull a list of tapes that are in DRM VAULT status: q drmedia * wherest=vault 3)Create a list of tapes that SHOULD be accounted for (either generate a tape range, if it's contiguous, or build a static list in a file). Have your script compare the volsers in list (3) to list (1) + (2). ANything that is on list 3, but isn't in either list (1) or (2), is MIA. It's much easier to go to the vault looking for a specific VOLSER, than to audit everything in there... I also run a script that compares (1) to (2) at least once a month, to make sure everything that was supposed to go to the vault actually did... -----Original Message----- From: Kelly J. Lipp [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 12, 2001 10:52 AM To: [EMAIL PROTECTED] Subject: FW: Question on del volhist Okay .. since we're talking del volhist ... Can someone clarify this point with the del volhist ? If I am using scratch tapes (no private tapes), and I am using the DR Module. It seems to me that if I have a DR tape, offsite, and empty (in retrieve state) and I delete the volhist entry, the tape seems to disappear totally from view. (i.e. a "q drm" command will no longer show it). I believe that scratch tapes will disappear if they are empty ... not a big deal if you know which ones they are, but if they disappear from view before you bring them back on site, how would you find them (without performing a manual offsite audit) ? (It is my understanding that tapes change from pending to empty "reuse" number of days (exactly) after they have gone pending. So you could have tapes changing from pennding to empty any time "3" days from the time the expiration freed it up.) How is anyone handling this (or are you doing what I'm doing and not deleting the volhist) ? Should I run my expiration weekly instead of daily ? Then I would know when my tapes would be changing to empty. Thanks, Glenn MacIntosh Manager of Technical Services Sobeys Inc. 123 Foord St. Stellarton, Nova Scotia (902) 752-8371 Ext. 4017 -----Original Message----- From: Kelly J. Lipp [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 11, 2001 11:51 AM To: [EMAIL PROTECTED] Subject: Re: Question on del volhist Don't over think it. Remember, information about volumes is in the database too and really, the only volume history record you are concerned about is the one indicating the most recent db backup tape. I routinely run, like daily, a delete volhist type=all todate=today-30. Kelly J. Lipp Storage Solutions Specialists, Inc. PO Box 51313 Colorado Springs CO 80949-1313 (719) 531-5926 Fax: (240) 539-7175 Email: [EMAIL PROTECTED] or [EMAIL PROTECTED] www.storsol.com www.storserver.com -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of Brazner, Bob Sent: Wednesday, April 11, 2001 8:26 AM To: [EMAIL PROTECTED] Subject: Question on del volhist Subject: Question on del volhist Attachment(s): <font size=-1></font> My vol history for stgnew and stgdelete goes back to the beginning of time. I'd like to use Del Volhist to get rid of records that aren't needed any more. but I can't see how to do this without possibly corrupting the vol history. If I understand things correctly, if a tape is in stgdelete status as of a given point in time (let's say 30 days ago), then I should be able to delete all stgnew and stgdelete records prior to that time, right? However, if a tape is in stgnew status at that time, then I better not do any deletes using that time, right? So, how do I construct my Del Volhist command(s) to make such dynamic decisions for every volume in the volhistory? Note, we have DRM, so dbbackup entires are not a problem. System is TSM 4.1.2 on AIX 4.3.3. Bob Brazner Johnson Controls, Inc. (414) 524-2570 (Embedded image moved to file: pic08360.pcx)
