I must be missing something. It used to be that we could use the following select statement to get event durations from the summary table.
select event, (end_time - start_time) seconds from summary. I am keeping this simple for illustrative purposes. I verified that this works as expected in 5.5. This used to return the total number of seconds that an event like a backup or migration ran. Now it returns just the number of seconds. For instance. If the process took 1 hour 20 minutes and 30 seconds, the command should return 4800 seconds. Instead it just returns "30". The number of seconds in the timestamp field. If I run the same select statement for minutes I get 20 instead of 80... etc. This seems to only be problem with the summary table, as running a select from the processes table works as expected. Does anyone else see this??? I am running TSM 6.2.1.0 on AIX 6.1. I am having to rewrite all kinds of scripts in order to accomodate this. I know that we are supposed to cast the timestamp as an integer, but I have not had any luck with that either. That just helps me do math with it like in calculating backup speeds. Any help is appreciated.
