I get this error running any of the select queries below. any ideas
thanks
==
ANR2905E Unexpected SQL identifier token - 'GB'.
|
.............................................................V.
select sum(cast(bytes/1024/1024/1024 as decimal(6,3))) Total GB
==
On Fri, 20 Sep 2002, Seay, Paul wrote:
> Date: Fri, 20 Sep 2002 09:57:53 -0400
> From: "Seay, Paul" <seay_pd AT NAPTHEON DOT COM>
> Reply-To: "ADSM: Dist Stor Manager" <ADSM-L AT vm.marist DOT edu>
> To: ADSM-L AT vm.marist DOT edu
> Subject: Re: Backup reporting: SUMMARY TABLE ISSUE IS FOUND
>
> They are working on a fix.
>
> Paul D. Seay, Jr.
> Technical Specialist
> Naptheon Inc.
> 757-688-8180
>
>
> -----Original Message-----
> From: Joel Fuhrman [mailto:joelf AT CAC.WASHINGTON DOT EDU]
> Sent: Friday, September 20, 2002 5:13 AM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: Re: Backup reporting: SUMMARY TABLE ISSUE IS FOUND
>
>
> To me is seems as though the worker sessions should be informing the control
> session as to the amount of work they have done. Each time the worker
> reports in, the control session would send a heart beat to the server thus
> avoiding this annoying timeout.
>
> On Wed, 18 Sep 2002, Seay, Paul wrote:
>
> > The problem is the summary table is broken right now. I just got off
> > the phone with Level 2. We think we have identified the cause of the
> > problem. As it turns out the SUMMARY table records are written by the
> > "control" session, not the actual backup sessions. What is happening
> > is the control sessions are timing out and a new control session is
> > being formed to send the statistics information. If you look at the
> > start and end timestamps with the following select and then look at
> > the activity log you will see what I am talking about. This select
> > lists all sessions that have a byte count of zero. You will notice
> > the start and end timestamps are usually the same or only a few
> > seconds apart. The reason is the wrong numbers are being recorded.
> >
> > select entity, number, start_time, end_time from summary where bytes=0
> > and start_time >current_timestamp-5 days and activity = 'BACKUP' order
> > by 1,3
> >
> > The issue is I can envision this is going to be very difficult to fix
> > in the current design.
> >
> > It will be interesting.
> >
> >
> >
> > Paul D. Seay, Jr.
> > Technical Specialist
> > Naptheon Inc.
> > 757-688-8180
> >
> >
> > -----Original Message-----
> > From: Mark Bertrand [mailto:Mark.Bertrand AT USUNWIRED DOT COM]
> > Sent: Wednesday, September 18, 2002 2:39 PM
> > To: ADSM-L AT VM.MARIST DOT EDU
> > Subject: Re: Backup reporting
> >
> >
> > Paul and all,
> >
> > When I attempt to use any of the following select statements my "Total
> > MB" returned is always 0. I get my list of nodes but there is never
> > any numbers for size.
> >
> > Since this is my first attempt at select statements, I am sure I doing
> > something wrong. I have tried from command line and through macro's.
> >
> > I am trying this on a W2K TSM v4.2.2 server.
> >
> > Thanks,
> > Mark B.
> >
> > -----Original Message-----
> > From: Seay, Paul [mailto:seay_pd AT NAPTHEON DOT COM]
> > Sent: Monday, September 16, 2002 11:43 PM
> > To: ADSM-L AT VM.MARIST DOT EDU
> > Subject: Re: Backup reporting
> >
> >
> > See if these will help:
> >
> > /* SQL Script: */
> > /* */
> > /* backup_volume_last_24hours.sql */
> > /* Date Description */
> > /* 2002-06-10 PDS Created */
> >
> > /* Create Report of total MBs per each session */
> >
> > select entity as "Node Name ", cast(bytes/1024/1024 as decimal(10,3))
> > as "Total MB ", cast(substr(cast(end_time-start_time as
> > char(17)),3,8) as
> > char(8)) as "Elapsed ", substr(cast(start_time as char(26)),1,19) as
> > "Date/Time ", case when cast((end_time-start_time) seconds as
> > decimal) >0 then cast(bytes/cast((end_time-start_time) seconds as
> > decimal)/1024/1024 as decimal(6,3)) else cast(0 as decimal(6,3)) end as "
> > MB/Sec" from summary where start_time>=current_timestamp - 1 day and
> > activity='BACKUP'
> >
> > /* Create Report of total MBs and length of backup for each node */
> >
> > select entity as "Node Name ", cast(sum(bytes/1024/1024) as
> > decimal(10,3)) as "Total MB", substr(cast(min(start_time) as
> > char(26)),1,19) as "Date/Time ",
> > cast(substr(cast(max(end_time)-min(start_time) as char(20)),3,8) as
> > char(8)) as "Length " from summary where start_time>=current_timestamp -
> > 22 hours and activity='BACKUP' group by entity
> >
> > /* Create Report of total backed up*/
> >
> > select sum(cast(bytes/1024/1024/1024 as decimal(6,3))) "Total GB
> > Backup" from summary where start_time>=current_timestamp - 1 day and
> > activity='BACKUP'
|
