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 >
