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: [EMAIL PROTECTED]
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:[EMAIL PROTECTED]]
Sent: Tuesday, December 10, 2002 5:16 PM
To: [EMAIL PROTECTED]
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:[EMAIL PROTECTED]> [EMAIL PROTECTED]
Phone: (858) 826-4062
Pager: (877) 905-7154
