Hi there guys,

After much searching and figuring out how to do select statements on TSM 6.2
This is what I have come up with for backups.

You can manipulate it to suit you.

SELECT substr(char(start_time),1,19) AS 
START_TIME,timestampdiff(4,char(timestamp(end_time) - (start_time))) AS 
ELAPTIME_IN_Minutes,cast(activity as varchar(16)) as Activity,cast(number as 
varchar(16)) as Process_Number,cast(entity as varchar(30)) as 
Entity,cast(float(bytes) /1024/1024/1024 AS DEC(10,2)) AS GB,cast(successful as 
varchar(16)) as Successful FROM summary WHERE activity='BACKUP' AND 
end_time>current_timestamp-48 HOURS

Hope this helps you.

Let me know if you need anything else.

Kind Regards
Rennad Murugan
rennad AT gmail DOT com
Certified Deployment Professional
Tivoli Storage Manager 6.1






Rejean Larivee wrote:
> Hello,
> indeed, the documentation is incorrect and time calculation changed.
> We have apar IC67375 that makes changes to the documentation.
> You can find the apar here :
>
> http://www-1.ibm.com/support/docview.wss?uid=swg1IC67375
>
> Rejean Larivee
> IBM Tivoli Storage Manager Level 2 support.
>
> "ADSM: Dist Stor Manager" <ADSM-L < at > vm.marist.edu> wrote on 06/23/2010
> 11:37:40 AM:
>
>
> > [image removed]
> >
> > Re: Getting backup duration in TSM 6.2 select statement
> >
> > Prather, Wanda
> >
> > to:
> >
> > ADSM-L
> >
> > 06/23/2010 11:38 AM
> >
> > Sent by:
> >
> > "ADSM: Dist Stor Manager" <ADSM-L < at > vm.marist.edu>
> >
> > Please respond to "ADSM: Dist Stor Manager"
> >
> > I feel your pain.  The conversion guide says there are changes to the
> > way SELECT does time calculation, but it is very non-specific (and the
> > example it gives is incorrect).
> >
> > The timestampdiff function appears to work consistently.  It's
> > documented in the DB2 SQL guide.  An example:
> >
> > select timestampdiff(8,cast( (current_timestamp-last_backup_date) as
> > char(22))) as DBHRS from db
> >
> > /* 2  seconds
> > /* 4  minutes
> > /* 8  hours
> > /* 16 days
> > /* 32 weeks
> > /* 64 months
> > /*128 quarters
> > /*256 years
> >
> > -----Original Message-----
> > From: ADSM: Dist Stor Manager [mailto:ADSM-L < at > VM.MARIST.EDU] On 
> > Behalf Of
> > Gary Bowers
> > Sent: Monday, June 21, 2010 3:00 PM
> > To: ADSM-L < at > VM.MARIST.EDU
> > Subject: [ADSM-L] Getting backup duration in TSM 6.2 select statement
> >
> > 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.
>


+----------------------------------------------------------------------
|This was sent by rennad AT gmail DOT com via Backup Central.
|Forward SPAM to abuse AT backupcentral DOT com.
+----------------------------------------------------------------------