Just a thought I am not sure if this will work but.... Attack it from another 
angle. It sounds like you are looking at the stg pool table from the select 
statement. Instead do the select statement against the activity log table 
looking for the migration processes.

-----Original Message-----
From: ADSM: Dist Stor Manager <ADSM-L AT VM.MARIST DOT EDU>
To: ADSM-L AT VM.MARIST DOT EDU <ADSM-L AT VM.MARIST DOT EDU>
Sent: Fri Dec 08 05:19:43 2006
Subject: Select statement for individual migration processes

I'm trying to construct a select statement that returns the historic
details of individual migration processes.

The summary table regards migration (per stgpool) as a single entity and
returns the total time for all the processes (ie when the last process
completes) and the entire amount of data moved (ie summation of bytes
transferred for all the migration processes).

Is it possible to get the breakdown of each individual migration thread
via a select statement?

I am trying to avoid calculating it manually by interrogating the
activity log.

Thanks

Leigh

********************************************
This message is intended only for the use of the Addressee and
may contain information that is PRIVILEGED and CONFIDENTIAL.

If you are not the intended recipient, you are hereby notified
that any dissemination of this communication is strictly prohibited.

If you have received this communication in error, please erase
all copies of the message and its attachments and notify us
immediately.

Thank you.
********************************************