Backup Central

Hello,
 
Over the years I've saved a lot of commands but never saw one for this. I'm not sure if it is possible but I thought I'd ask to see if anyone has it.
 
Is it possible to create a select command that I input the name of a file that was backed up and have the output tell me what tape(s) it would be on? I have a command that will tell me all the tapes a node has data on, and another to spit out the contents of a tape to a file, and from there search for the filename but I'm curious if there is an easier way.
 
Thank You
Geoff Gill

Considering that I've gone the other direction, from the contents of a tape to the backup date of every object on the tape, it should be possible, but it might not be practical; the TSM V6 DB tables aren't indexed very well for this kind of work.

Complications might include inactive copies of the file you're looking for and copy pool copies.

If you know when the file was backed up, you might play with EXPORT NODE and the PREVIEW option, not to mention limiting the dates of the data being backed up and see what that gets you.

The collocation policies you use might influence your techniques some; the more tightly you collocate, the more manageable starting with QUERY NODEDATA and going to Q CONTENT becomes -- although that doesn't deal with inactive copies with any delicacy.

Datamining on TSM: just another fun day with the database!

Nick

On Jun 28, 2012, at 7:38 PM, Geoff Gill wrote:

Hello,

Over the years I've saved a lot of commands but never saw one for this. I'm not sure if it is possible but I thought I'd ask to see if anyone has it.

Is it possible to create a select command that I input the name of a file that was backed up and have the output tell me what tape(s) it would be on? I have a command that will tell me all the tapes a node has data on, and another to spit out the contents of a tape to a file, and from there search for the filename but I'm curious if there is an easier way.

Thank You
Geoff Gill

The file name and node is in the contents table, but I don't believe
there is any way to tell which date it was backed up, so you couldn't tell
which version of the file it is. (i.e. it will just say
"/var/log/messages", but not the date it was backed up)

The backups table does have this information, but not the volume the file
is sitting on. This is extremely tough on the database, but if you
really have to, have to do this.

You would select the object_id from the "BACKUPS" table using the file
name and path (node_name, hla_name, ll_name)
Then you can use the object_id to select the volume_name from the contents
table.

I once witnessed a select for all "*.nsf" files in the BACKUPS table. It
took more than a month to finish the command (but it did work).
I would avoid this at most costs.


Regards,
Shawn
________________________________________________
Shawn Drew





Internet
avalnche96 < at > YAHOO.COM

Sent by: ADSM-L < at > VM.MARIST.EDU
06/28/2012 08:38 PM
Please respond to
avalnche96 < at > yahoo.com


To
ADSM-L
cc

Subject
[ADSM-L] select or other command






Hello,

Over the years I've saved a lot of commands but never saw one for this.
I'm not sure if it is possible but I thought I'd ask to see if anyone has
it.

Is it possible to create a select command that I input the name of a file
that was backed up and have the output tell me what tape(s) it would be
on? I have a command that will tell me all the tapes a node has data
on, and another to spit out the contents of a tape to a file, and from
there search for the filename but I'm curious if there is an easier way.

Thank You
Geoff Gill




This message and any attachments (the "message") is intended solely for
the addressees and is confidential. If you receive this message in error,
please delete it and immediately notify the sender. Any use not in accord
with its purpose, any dissemination or disclosure, either whole or partial,
is prohibited except formal approval. The internet can not guarantee the
integrity of this message. BNP PARIBAS (and its subsidiaries) shall (will)
not therefore be liable for the message if modified. Please note that certain
functions and services for BNP Paribas may be performed by BNP Paribas RCC, Inc.

Hi Geoff,



there isn't one command to do this, but a select and then 1 or 2 show commands will

find the volume name. Here is an example.



tsm: WIN2>select object_id from backups where node_name = 'A-NODE-NAME' and ll_name = 'OUTLOOK.PST'



OBJECT_ID

---------------------

590316



tsm: WIN2>show bfo 590316



Bitfile Object: 590316

Active

**Archival Bitfile Entry

Bitfile Type: PRIMARY Storage Format: 22

Bitfile Size: 10480218 Number of Segments: 1, flags: 0

Storage Pool ID: 8 Volume ID: 127 Volume Name: /tsm_nx331/win2/0000007F.BFS



tsm: WIN2>show invo 590316

Inventory object 590316 of copy type Backup has attributes:

NodeName: A-NODE-NAME, Filespace(1): \\a-node-name\c$,

ObjName: \USERS\A-NODE-NAME\APPDATA\LOCAL\MICROSOFT\OUTLOOK\OUTLOOK.PST.

hlID: 0292E2463557C3F93E61EB8A7821EA1BE364A261

llID: 93534B77D3C2BC010BCA14FAF8EB123DC0ED5D7B

Type: 2 (File) MC: 18 (OUTLOOK3) CG: 1 Size: 32016384 HeaderSize: 0

Active, Inserted 03/06/2012 11:25:28 AM (CUT Not Set)

GroupMap 00000000, bypassRecogToken NULL



Bitfile Object: 590316

Active

**Archival Bitfile Entry

Bitfile Type: PRIMARY Storage Format: 22

Bitfile Size: 10480218 Number of Segments: 1, flags: 0

Storage Pool ID: 8 Volume ID: 127 Volume Name: /tsm_nx331/win2/0000007F.BFS





Sometimes the 'show bfo' is suffiecient and sometimes the 'show invo' is required

depending on if the file is in an aggregate or by itself.





I have used this process too many time to find files which should not have been backed up

and thoroughly expunge all traces of them.



You will probably need to expand the select to distinguish active and inactive versions and

to improve performance on version 5 servers. On version 6 servers just supplying the ll_name is

very quick.



Bill Colwell

Draper Lab



-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L < at > VM.MARIST.EDU] On Behalf Of Geoff Gill
Sent: Thursday, June 28, 2012 8:38 PM
To: ADSM-L < at > VM.MARIST.EDU
Subject: select or other command



Hello,



Over the years I've saved a lot of commands but never saw one for this. I'm not sure if it is possible but I thought I'd ask to see if anyone has it.



Is it possible to create a select command that I input the name of a file that was backed up and have the output tell me what tape(s) it would be on? I have a command that will tell me all the tapes a node has data on, and another to spit out the contents of a tape to a file, and from there search for the filename but I'm curious if there is an easier way.



Thank You

Geoff Gill