Hello,
this is a known problem. IBM said that it will be fixed in the next
release 5.3.2.3 (?).
regards,
Volker
Am Dienstag, den 07.02.2006, 15:24 +0100 schrieb Rainer Wolf:
> 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
>
|