"preview=yes" option to get a list of required volume for a DR

[shanafin]

Pressures on, any help would be greatly appreciated



We are in the middle of a DR restore for a couple of Netware post offices. We are trying to cut down on the number of tapes that we have to recall from offsite. Will the "preview=yes" command help us do this?



We'd like to identify which tapes/volumes need to be recalled for a specific node or more specifically which tapes/volumes to retrieve for a restore of a specific node/FSID on a specified date.



We need to do the restore from a previous date since it's no longer on our onsite storage.



So far...



We've built a new TSM instance and restored the DB back to July 15, 2006, set up cross define, shared a library, and done some other config. We are ready to recall tapes at this point.



Here are the commands that we have used to identify the tapes that we need to recall...



The first one gives us over 600 tapes



select distinct volume_name from volumeusage where node_name='ADN129MBK' AND STGPOOL_NAME='COPYTPOOL'



SELECT * FROM VOLUMEUSAGE WHERE NODE_NAME='adn127mbk' AND STGPOOL_NAME='COPYTPOOL'



SELECT * FROM VOLUMEUSAGE WHERE NODE_NAME='adn127mbk' AND STGPOOL_NAME='COPYTPOOL' AND FILESPACE_NAME='ADN127MAPPS:'



When we try to use "preview=yes" we get an error of "The node has a type that is not allowed"...



Thanks,

Steve

 

[nbs03]

Fin,

Have you tried "query nodedata"?

NEil

 

[shanafin]

I get an error when I try to get help on the syntax....



tsm: TSM_AND>help query nodedata

ANR2305E No such command/subcommand: query nodedata.

ANS8001I Return code 3.



tsm: TSM_AND>



Steve

 

[shanafin]

The best we've got so far is 647 tapes to recall. Is there a way to narrow this down by FSID, 9file space ID). We only need to restore one of the three file spaces for the affected node. To get the list of 647 tapes we used...



This select to show how many tapes would be needed to restore a node (stgpool_name should be your offsite tape pool) for a DR exercise



select distinct volume_name -

from volumeusage -

where node_name='node_name' -

and stgpool_name='pool_name'



The output is a list of tapes.



-Steve

 

[shanafin]

If anyone else runs into this we actually narrowed the tapes to recall down from 647 to around 200 by restoring the latest backup sets for the two servers that we need to restore. This brought us to 90 days out rather than recalling all of the tapes for the server. We now only need to recall the offsite tapes from approximately the past 90 days.



No luck on narowing down the select staement to specific FSID's yet though. Does anyone have any ideas for that?



Thanks,

Steve