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 <[email protected]> To: [email protected] <[email protected]> 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. ********************************************
