Hello,

as far as understand your wish,
you want to collocate (data for)
a couple of previously non-collocated nodes.
But not all nodes from the non-collocated 
pool should become co-located.


Check this proposal against your needs:

1) pick all tapes where nodes concerned have data saved on 
(in the current, non-collocated pool). 
SQL queries how to achieve this have been published here repeatedly.

2) for each such tape do
query its content > into an flat file.

3) using this listings determine 
 how many different nodes have their data saved there. 

 The  "sort" and "uniq"
 commands will help you - they are standard on unix 
 or part of NT mks utilities, shareware, etc.

 This count includes all nodes which you want to collocate,
 and some extra nodes which happen to share tapes
 with nodes concerned.
 
 
4) create your new, collocated storage pool
(NewCollocatedStoragePool)
and define enough tapes into it.
Enough means at least one for each node found in (3).

For nodes which are larger than a tape capacity is, 
add enough extra tapes.


5) change definitions of nodes concerned
so that their new backups (incrementals, as usuall,
no extra full-backup necessary) point to the
NewCollocatedStoragePool(4).

6) for each tape volume from (1) perform
MOVE DATA VolumeXXX STGPool=NewCollocatedStoragePool.
Yeah, this will cost you many tape mounts in 
the NewCollocatedStoragePool.


7) This will let you just where you wanted to go,
but probably with some/many extra files from nodes which you
did not want to collocate 
with (part of) their data 
in the NewCollocatedStoragePool as well.

Now you can decide to

7A) ignore it, live with that and let this 
    files expire during some time

7B) for each such "extra" tape perform
    MOVE DATA VolumeYYY STGPool=OldNotCollocatedStoragePool.

Here you go!

Juraj Salak 

KEBA AG
Softwareentwicklung Bankautomation
Gewerbepark Urfahr 14 - 16
Postfach 111
A-4041 Linz
Österreich

Tel. ++43/732/7090-7461
Fax ++43/732/730910
e-mail: sal AT keba.co DOT at
www.keba.co.at









 

create 
for each such tape perf