My goal is migration of the application and data from AppServer A to
AppServer B.  I will also be migrating ADSM from ADSMServer A to
ADSMServer B.  All of this while minimizing downtime.  I set up a storage
pool called MIGRATION_TAPES and then pointed the copy groups to backup
directly to the pool via

"update copy MYDOMAIN MYPOLICY DAILY STANDARD type=Archive
dest=MIGRATION_TAPES".
"update copy MYDOMAIN MYPOLICY DAILY STANDARD type=Backup
dest=MIGRATION_TAPES".

I did the same command on the STANDARD domain as well.

I then did a full backup of the AppServer A application and data onto the
MIGRATION_TAPES storage pool.  I then did a database backup.

I then did a "q vol" and identified which tapes were in the
MIGRATION_TAPES storage pool, and a "q volhist tpye=dbb" and identified
the tape where the full database backup resides.

I then did a "checkout vol ######" on the volumes that I would be
transporting.  I also copied the volhist, the devconfig and and
dsmserv.opt at this time.

When I got the tapes to the new location with ADSMServer B I loaded the
them into the 3494, modified and copied the config files and did a
"dsmserv restore db todate=today".  I then ran an "audit library" which
marked all of the tapes not present as unavaiable.

I was able to restore most of the the data from AppServer A onto AppServer
B ubti I got to a couple of filesystems that said they required a tape
that was not in the MIGRATION_TAPES storage pool.  Additionally, some
filesspaces were not found as they were pointing to the disk storage
pools on ADSMServer A.  How, doing a full backup to a specific storage
pool, would this be possible?  How can I better identify exactly which
volumes I will need to restore all of the filespaces on a particular node?

I have tried:

dsmadmc -id=xxx -pa=xxx "select volume_name, filespace_name from contents
where node_name='nodename'"

This returns nothing.

I am afraid that the SQL statement "select volume_name from contents where
node_name='nodename'" is returning ALL volumes that have the nodes files
on them.  Can it be narrowed down to just the files I backed up the the
MIGRATION_TAPES storage pool?

Thank you in advance for your help.


Sometimes poet, sometimes hacker
Living the life of a burned out slacker
Bye
Josh