ADSM-L

[ADSM-L] Getting backup duration in TSM 6.2 select statement

2010-06-21 15:00:52
Subject: [ADSM-L] Getting backup duration in TSM 6.2 select statement
From: Gary Bowers <gbowers AT ITRUS DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Mon, 21 Jun 2010 14:00:05 -0500
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.

<Prev in Thread] Current Thread [Next in Thread>