Select 'move data ', volume_name, ' reconstruct=yes', ' stg=newstgpool' from
volumes where stgpool_name='OLDSTGPOOL' > /temp/macrofile

Notice the where clause is in caps.  This will create a file of output that
you will have to delete the first couple of lines from the output file as
shown below:

Unnamed[1]     VOLUME_NAME            Unnamed[3]           Unnamed[4]
----------     ------------------     ----------------     ---------------
move data      421999                  reconstruct=yes      stg=newstgpool

Next you will do a "macro /temp/macrofile" command.

MOVE DATA only works on primary storage pools to a different primary storage
pool.  And, every tape has to be mounted and the data copied to the new
pool.  I would set your reuse delay on the source pool to 0 so the tapes
will immediately scratch after the moves complete.

Paul D. Seay, Jr.
Technical Specialist
Naptheon Inc.
757-688-8180


-----Original Message-----
From: David Gratton [mailto:david.gratton AT SCOTIABANK DOT COM]
Sent: Thursday, August 29, 2002 12:50 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Moving Stgpools question


I have several storage pools in my environment and I would like to
consolidate them all into one storage pool (same dev type). My question is ,
is there any easy way to do this or do I have to do a "move data $volume
stg=newstgpool" for each volume of every storage pool? I guess I could write
a script to do it but I was hoping there was a was to move a full storage
pool with one command....Any help would be  appreciated..

Dave Gratton
IBM Global Services