I've been having this problem for awhile. Support told me to go to 4.2.3.1 on
server and client and now these clients are missing from the summary table.
This is on my
biggest server (25 GB database). On other small and new servers, things seem to
be ok. My PMR is still open (48498) and support is working on it.
Guillaume Gilbert
Conseiller - Gestion du stockage
CGI - Gestion intégré des technologies
TEL. : (514) 281-7000 ext 3642
Pager : (514) 957-2615
Email : guillaume.gilbert AT cgi DOT com
____________________________________________________________
Kolbeinn Josepsson <Kolbeinn.Josepsson AT NYHERJI DOT IS>@VM.MARIST.EDU> on
2002-12-11 08:24:56
Veuillez répondre à "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
Envoyé par : "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
Pour : ADSM-L AT VM.MARIST DOT EDU
cc :
Objet : Re: Select Statement
I have seen this problem since 5.1.0
At one site with server 5.1.5.2 and client 5.1.5.0, not only some clients
reports 0 MB, also some clients are completly missing from the summary
table.
At other site I have recently upgrated from 4.2.x to 5.1.5.4 and clients
5.1.5.0 and I'm seeing clients report 0 MB.
If this is question about client patch level, I would like to know....
Best regards,
Kolbeinn Josepsson 7 Systems Engineer
Tel: +354 569-7700 7 Fax: +354 569-7799
www.nyherji.is
"Seay, Paul"
<seay_pd@NAPTHEO To: ADSM-L AT VM.MARIST DOT
EDU
N.COM> cc:
Sent by: "ADSM: Subject: Re: Select Statement
Dist Stor
Manager"
<[email protected]
T.EDU>
11.12.2002 01:30
Please respond
to "ADSM: Dist
Stor Manager"
As it turns out the clients also have to be updated to correct a problem
where the summary table statistics are missing. I talked to a TSM Level 2
person about this just last week. I do not know what levels you have to be
at to get the problem corrected, but I thought 5.1.5 was good enough.
Paul D. Seay, Jr.
Technical Specialist
Naptheon Inc.
757-688-8180
-----Original Message-----
From: Gill, Geoffrey L. [mailto:GEOFFREY.L.GILL AT SAIC DOT COM]
Sent: Tuesday, December 10, 2002 5:16 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Select Statement
I got this somewhere and I know it used to work on my 4x server. Now that
I'm on 5.1.5.2 I get a lot of nodes report back with 0 Megabytes but they
obviously sent files.
Anyone who can make it work since my SQL stills are pretty much non
existant?
/*--------------------------------------------*/
/* Specify a date on the run line as follows */
/* run q_backup 2001-09-30 */
/*--------------------------------------------*/
select entity as node_name, date(start_time) as date, - cast(activity as
varchar(10)) as activity, time(start_time)as start, -
time(end_time) as end, cast(bytes/1000000 as decimal(6,0))as megabytes, -
cast(affected as decimal(7,0)) as files, successful from summary - where
date(start_time)='$1' and activity='BACKUP' order by megabytes desc
NODE_NAME: NODEA
DATE: 2002-12-09
ACTIVITY: BACKUP
START: 20:00:51
END: 20:48:07
MEGABYTES: 0
FILES: 100
SUCCESSFUL: YES
This one does the same thing with some nodes. It also only reports about
half the nodes even though it looks like it's supposed to be going back a
full day.
NODEA NT_DOM WinNT 0.00
1
select summary.entity as "NODE NAME", nodes.domain_name as "DOMAIN",
nodes.platform_name as "PLATFORM", cast((cast(sum(summary.bytes) as float)
/
1024 / 1024) as decimal(10,2)) as MBYTES , count(*) as "CONECTIONS" from
summary ,nodes where summary.entity=nodes.node_name and
summary.activity='BACKUP' and start_time >current_timestamp - 1 day group
by
entity, domain_name, platform_name order by MBytes desc
A better one would also work.
Geoff Gill
TSM Administrator
NT Systems Support Engineer
SAIC
E-Mail: <mailto:gillg AT saic DOT com> gillg AT saic DOT com
Phone: (858) 826-4062
Pager: (877) 905-7154
|
