Great script for hunting down "problem children" backing up the
wrong stuff! At our site we have a lot of archives being pushed from hosts,
so I changed "BACKUP" to "ARCHIVE" and I get some great summary stats.
Kudos to Miles for a very helpful script. The one I was using to get
this information out of the server was U-G-L-Y because I am not all that
good with SQL queries, but I am good with kornshell scripting. This is
~much~ better.
Thanks,
Ben
Micron Technology
-----Original Message-----
From: Miles Purdy [mailto:PURDYM AT FIPD.GC DOT CA]
Sent: Friday, September 27, 2002 6:55 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: Calculating amount of data being backed up every 24 hours.
This reports on MB / Node:
*
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
Ex:
NODE NAME DOMAIN PLATFORM
MBYTES CONECTIONS
------------------ ------------------ ----------------
------------ -----------
UNXR NISA_DOM AIX
72963.48 8
UNXP NISA_DOM AIX
34052.88 9
UNXM NISA_DOM AIX
10923.21 6
CITRIX01 NT_CLIENTS WinNT
734.06 2
WAG NT_CLIENTS WinNT
454.40 2
CWS NISA_DOM AIX
178.12 15
NISAMTA NT_CLIENTS WinNT
48.38 2
UNXD NISA_DOM AIX
42.87 3
KOSTELNJ NT_CLIENTS WinNT
30.72 1
MILES NT_CLIENTS WinNT
26.45 2
99 NOVELL_CLIENTS NetWare
4.32 2
MAX NOVELL_CLIENTS NetWare
4.32 2
UNXA AIX_TEST_SERVERS AIX
0.04 17
UNXB AIX_TEST_SERVERS AIX
0.02 1
----------------------------------------------------------------------------
------------------
Miles Purdy
System Manager
Agriculture and Agri-Food Canada,
Information Systems Team,
Farm Income Programs Directorate
Winnipeg, MB, CA
purdym AT fipd.gc DOT ca
ph: (204) 984-1602 fax: (204) 983-7557
"If you hold a UNIX shell up to your ear, can you hear the C?"
----------------------------------------------------------------------------
---------------------
>>> Robert.Andrew.Dowsett AT HYDRO DOT COM 27-Sep-02 6:46:55 AM >>>
Hi everyone.
Does anyone have any suggestions regarding how to calculate how much data
is being handled by TSM every day ??
Ideally I would like to write a script which tells me how much data is
being backed up by TSM every day (in total), how much is going to disk
storage pools and how much is going to tape storage pools. The trouble is I
can't seem to think up a simple way to measure these statistics without
resorting to complicated select statements and mathematics.
Thanks in advance for your help.
Robert Dowsett
|