Hello all,
we currently have tsm server 5.3.2.1 on solaris and i have difficulties with 
the following select:

 select start_time, end_time,start_time-end_time as -
"Elapsed Time" ,entity,processes, bytes,((cast(bytes as decimal(18,0)) / 
cast((end_time -start_time)seconds as decimal(18,0))))/1024
-
"KB/second" from summary where activity='MIGRATION' and 
cast((current_timestamp-end_time)minutes as decimal) >0 -
and cast((current_timestamp-start_time)hours as decimal) <168  and 
cast((end_time -start_time)seconds as decimal) >0

It should give back the throughput values in kB/s on migration processes - all 
migration processes of the last
7 days should be listed. The purpose is to keep an eye on the 
migration-performance - knowing
that the time of the whole process including mount(wait)-times is used.

It formerly went fine but I think since one tsm-update ( 5.3.2 ? ) I got no 
output anymore
although migration happens.
The output is only :
        ANR2034E SELECT: No match found using this criteria.
        ANS8001I Return code 11.

The same sql-query still runs fine for 'RECLAMAION' processes instead 
'MIGRATION'.

Can anyone help - I am not very firm with select
It looks like the start_time for Migrations is somewhow cummulativ in the 
summary table ?
Can I take some other select to get the migration performance ( in kB/s ) on the
whole migration process ? Maybe not from the summary ?

Thanks in advance for any help !
Rainer



tsm: TSM1>select * from summary where activity='MIGRATION'

...

      START_TIME: 1900-01-01 00:00:00.000000
        END_TIME: 2006-02-07 07:38:57.000000
        ACTIVITY: MIGRATION
          NUMBER: 393
          ENTITY: BACKUPPOOL2
        COMMMETH:
         ADDRESS:
   SCHEDULE_NAME:
        EXAMINED: 4114238
        AFFECTED: 4114238
          FAILED: 0
           BYTES: 836764217344
            IDLE: 0
          MEDIAW: 1106
       PROCESSES: 14
      SUCCESSFUL: YES
     VOLUME_NAME:
      DRIVE_NAME:
    LIBRARY_NAME:
        LAST_USE:
       COMM_WAIT: 0
NUM_OFFSITE_VOLS:


tsm: TSM1>

For the migration-Processes the start-time looks 'normal' like

tsm: TSM1>select * from summary where activity='RECLAMATION'

...

      START_TIME: 2006-02-05 11:40:52.000000
        END_TIME: 2006-02-05 16:03:43.000000
        ACTIVITY: RECLAMATION
          NUMBER: 346
          ENTITY: DA-COPY-VBA
        COMMMETH:
         ADDRESS:
   SCHEDULE_NAME:
        EXAMINED: 203830
        AFFECTED: 203830
          FAILED: 1
           BYTES: 52093334736
            IDLE: 0
          MEDIAW: 1055
       PROCESSES: 1
      SUCCESSFUL: NO
     VOLUME_NAME:
      DRIVE_NAME:
    LIBRARY_NAME:
        LAST_USE:
       COMM_WAIT:
NUM_OFFSITE_VOLS: 68