Ahh, I see. I knew that TSM tables were built 'on the fly'; but had't
realised that the events table is essentially unbounded, hence the need
for the 'special' behaviour.
Thanks,
Matt.
> -----Original Message-----
> From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU]
> On Behalf Of Henrik Wahlstedt
> Sent: 07 November 2006 11:01
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: Re: [ADSM-L] select events table
>
> Nope, see the explanation in 'Why does it Work that Way (Andy
> Raibeck).pdf' from TSM Symposoium in Oxford 2005.
>
> "Events table is calculated at runtime..." etc
>
> Cheers
> Henrik
>
> -----Original Message-----
> From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU]
> On Behalf Of
> Matthew Warren
> Sent: den 7 november 2006 11:37
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: Re: select events table
>
> Odd, how can it be that select * from events returns
> different to select
> * from events where scheduled_start>'1900-01-01' How is the table
> 'special'?
>
>
>
> Matt.
> > -----Original Message-----
> > From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU]
> On Behalf
> > Of Rainer Tammer
> > Sent: 07 November 2006 09:15
> > To: ADSM-L AT VM.MARIST DOT EDU
> > Subject: Re: [ADSM-L] select events table
> >
> > Hello,
> >
> > goc wrote:
> > > hi,
> > > when i make select * from events i get data only for
> current date ,
> > > i know with q event you can get back as defined in server options
> > > but i would like to make some count(*) and stuff on
> events data, so
> > > my question is can i get further in past with direct
> > select statement
> > > to events table ?
> > >
> > This is a special table.
> > You need a SELECT similar to the following statement:
> >
> > select count(*) as \"Administrative Schedules Successful\"
> from events
>
> > where LENGTH(domain_name) IS NULL and scheduled_start >
> '1900-01-01'
> > and scheduled_start between (current_timestamp - 24 hours) and
> > current_timestamp and status='Completed' and result=0
> >
> > The important part is the scheduled_start > '1900-01-01' .
> > Without the boundary you will get no useful events.
> >
> > > thanks big time
> > >
> > > goran
> > >
> > >
> > Bye
> > Rainer Tammer
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > > -----------------------------------
> > > 3.3TB in 12hours
> > >
> > >
> >
> >
> >
> >
>
>
> This email is confidential and may be privileged. If you are not the
> intended recipient please notify the sender immediately and delete the
> email from your computer.
>
> You should not copy the email, use it for any purpose or disclose its
> contents to any other person.
> Please note that any views or opinions presented in this email may be
> personal to the author and do not necessarily represent the views or
> opinions of Digica.
> It is the responsibility of the recipient to check this email for the
> presence of viruses. Digica accepts no liability for any damage caused
> by any virus transmitted by this email.
>
> UK: Phoenix House, Colliers Way, Nottingham, NG8 6AT UK
> Reception Tel: +
> 44 (0) 115 977 1177 Support Centre: 0845 607 7070
> Fax: + 44 (0) 115 977 7000
> http://www.digica.com
>
> SOUTH AFRICA: Building 3, Parc du Cap, Mispel Road, Bellville, 7535,
> South Africa
> Tel: + 27 (0) 21 957 4900
> Fax: + 27 (0) 21 948 3135
> http://www.digica.com
>
>
> -------------------------------------------------------------------
> The information contained in this message may be CONFIDENTIAL and is
> intended for the addressee only. Any unauthorised use,
> dissemination of the
> information or copying of this message is prohibited. If you
> are not the
> addressee, please notify the sender immediately by return
> e-mail and delete
> this message.
> Thank you.
>
>
>
>
|
