Luc
If you have a straightforward backup of every storage pool every day,
then amount backed up = amount copied to storagepools.
This number can be gotten from the actlog for each process or from the
summary table.
Hope this helps.
Steve
Steven Harris
AIX and TSM Admin
Brisbane Australia
Richard Rhodes wrote:
>
> If you trust the summary table (which you probably shouldn't) this is
> interesting for all activity in last 25hr by activity( I overlap 1 hr
> for my reports). It's a start to add a where clase for just backup
> activity.
I use some similar queries for a daily "feel" of
If you trust the summary table (which you probably shouldn't) this is
interesting for all activity in last 25hr by activity( I overlap 1 hr
for my reports). It's a start to add a where clase for just backup
activity.
select count(*) as count, -
sum(bytes)/1024/1024/1024 as GigaBytes,
On Mar 22, 2007, at 2:13 PM, Luc Beaudoin wrote:
I have a blank
I want to know how many GB I'm taking in backup everyday ... I would
like the TOTAL not by nodes ...
any ideas
Something like the following, for backups ended thus far today:
SELECT Dec((SUM(BYTES) / (1024 * 1024 *1024)),15)
Here's a nice select command to see more detailed information .
So I don't take all the credit, this select was posted while back one time
or other. You can play around with date # to increase or decrease # of
days of report.
select entity as node_name, date(start_time) as date, cast(activity a
missed/failed schedules for the last 24-hours.
Bill Boyer
-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Mark
Stapleton
Sent: Wednesday, January 10, 2007 11:36 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: select command for Successful / Failed backups
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Gopinathan, Srinath
>1) Is there any command to find the list of all failed backups in a
>server?
>2) Is there any command to find the list of all successful backups in a
>server?
From: ADSM: Dist Stor Manager [mailto:[EMAIL PRO
- Original Message -
From: "Richard Sims" <[EMAIL PROTECTED]>
To:
Sent: Wednesday, January 10, 2007 2:20 PM
Subject: Re: select command for Successful / Failed backups
On Jan 10, 2007, at 7:50 AM, Bos, Karel wrote:
Q event
Amen. This TSM tracking of Backup even
On Jan 10, 2007, at 7:50 AM, Bos, Karel wrote:
Q event
Amen. This TSM tracking of Backup event success is one of the great
benefits of using TSM client scheduling, as opposed to having an
operating system scheduling subsystem perform backups. Centralized
reporting and control.
Richard S
Q event
-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Gopinathan, Srinath
Sent: woensdag 10 januari 2007 6:25
To: ADSM-L@VM.MARIST.EDU
Subject: select command for Successful / Failed backups
Hi,
1) Is there any command to find the list of all f
AFAIK, there is no way to do that.
All you can get is the list of files that are backed up, and the mgmt class
they are bound to, from the backups table.
No info about total amount of data.
-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Pétur
Eyþó
So as not to confuse:
Begindate=-1 > /tmp/sched.log
cat /tmp/mecc.log|grep -v ANS8000I |grep -v ANS8002I |mailx -s "TSM
the /tmp/sched.log and /tmp/mecc.log need to be the same file for this
to work. I'm sure the different names were a typo-error.
Sal
: ADSM-L@VM.MARIST.EDU
Subject: Re: SELECT COMMAND
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On
Behalf Of Lepre, James
> I am trying to figure out how to automate in an email whether the
>schedules for my nodes backed up successfully or failed during the
>previous night. Do
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On
Behalf Of Lepre, James
> I am trying to figure out how to automate in an email whether the
>schedules for my nodes backed up successfully or failed during the
>previous night. Does anyone have an idea on how to do this.
Use the TSM Opera
ackup Results" $MAILLIST
-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Lepre, James
Sent: Monday, May 09, 2005 2:16 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: SELECT COMMAND
Hello Everyone,
I am trying to figure out how to automate in an
ADSM-L@VM.MARIST.EDU
cc
Subject
Re: SELECT COMMAND
Hello Everyone,
I am trying to figure out how to automate in an email whether the
schedules for my nodes backed up successfully or failed during the
previous night. Does anyone have an idea on how to do this.
Thank you
James
Hello Everyone,
I am trying to figure out how to automate in an email whether the
schedules for my nodes backed up successfully or failed during the
previous night. Does anyone have an idea on how to do this.
Thank you
James
On Oct 7, 2004, at 10:17 AM, Smith, Rachel wrote:
To answer your question, the idea is/was to query volh for database
backups that have been written to today, checkout of library and send
offsite.
Rachel - This is one of those questions that keep coming up.
Yes, it is possible to do that w
TECTED]>
2004-10-07 16:35
Please respond to
"ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
To
[EMAIL PROTECTED]
cc
Subject
Re: select command
Hi,
I am using drm functions within tsm but the move script that is
scheduled is moving all tapes written to, I want this script
Utveckling & Drift
Exist i Stockholm AB
Propellerv=E4gen 6B
183 62 T=C4BY
V=E4xel: 08 - 754 98 00
Mobil: 070 - 399 27 51
-Original Message-
From: Smith, Rachel
Sent: 07 October 2004 15:17
To: '[EMAIL PROTECTED]'
Subject: RE: Re: select
respond to
"ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
To
[EMAIL PROTECTED]
cc
Subject
Re: select command
Yes, I already have scripts that do something similar but wanted to have
this running from TSM, not external.
To answer your question, the idea is/was to query volh
V=E4xel: 08 - 754 98 00
Mobil: 070 - 399 27 51
-Original Message-
From: Smith, Rachel
Sent: 07 October 2004 14:30
To: '[EMAIL PROTECTED]'
Subject: Re: select command
Hi, the o
; <[EMAIL PROTECTED]>
2004-10-07 15:29
Please respond to
"ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
To
[EMAIL PROTECTED]
cc
Subject
Re: select command
Hi, the option below worked, thanks for that.
But is there a way to send the output from the select command to
;mailto:ADSM-L AT VM.MARIST DOT EDU>
Subject: Re: select command
Or this one if you want to see volumes from today's backup.
select volume_name from volhistory where
Date(date_time)=3Ddate(current_timestamp) and type in
('BACKUPFULL','BACKUPINCR')
Or may be a simpler
riginal Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Das, Samiran (IDS ECCS)
Sent: Wednesday, October 06, 2004 12:19 PM
To: [EMAIL PROTECTED]
Subject: Re: select command
Rachel,
Try this select query.
select volume_name from volhistory where
date_timehttp://
Rachel,
Try this select query.
select volume_name from volhistory where
date_timehttp://www-dat.lrz.de/dat/8/asys/doc/tsmserv/adsmserv-sql/doc/pdf/adsm_s
ql.pdf
Regards, Samiran Das
-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Smith, Rachel
Se
Hi Mr Chandrasekhar,
You could probably use something like :
Select blah ... where cast((scheduled_start-current_timestamp)hours as
decimal) < 24
In this case you can replace hours by minutes or even seconds
or select blah ... where dayname(scheduled_start) ='Tuesday'
Hope it helped !
Arnaud
Try . . .
select * from events where '11/22/2002 < scheduled_start
Change the date as necessary and add any other constraints (e.g.
node_name='mynode').
Mahesh
>>> [EMAIL PROTECTED] 11/22/02 08:36AM >>>
Hi All,
How can I get old scheduled events using select commands, I can get the
same
using
You can use "q event * * begind=-1" to see yesterday's events. Modify begind
to see old ones.
Thanks
Raminder Braich
The Davey Tree Expert Company
Kent, OH 44240
330-673-9515 Ext. 270
-Original Message-
From: Charakondala, Chandrasekhar R. [mailto:[EMAIL PROTECTED]]
Sent: Friday, Novembe
What you are looking for is in the summary table. You can issue a
'select * from summary' to dig further form there.
--
Joshua S. Bassi
IBM Certified - AIX 4/5L, SAN, Shark
Tivoli Certified Consultant -ADSM/TSM
eServer Systems Expert -pSeries HACMP
AIX, HACMP, Storage, TSM Consultant
Cell (831)
select left(platform_name,13) as "PLATFORM_NAME" -
, left(node_name,13) as "NODE_NAME " -
, cast(client_version as CHAR(1)) || '.' -
|| cast(client_release as CHAR(1)) || '.' -
|| cast(client_levelas CHAR(1)) || '.' -
|| cast(client_sublevel as CHAR(2)) as "LEVEL " -
, le
al Specialist
Naptheon Inc.
757-688-8180
-Original Message-
From: Halvorsen Geirr Gulbrand [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 19, 2002 9:17 AM
To: [EMAIL PROTECTED]
Subject: Re: Select command to q client name and version
Hi Karla,
try
select node_name,client_version,client_release
TECTED]>
To: [EMAIL PROTECTED]
cc:
Subject:Re: Select command to q client name and version
Hi Carla;
Try this. I got this from group.
It will also display the OS versions.
select platform_name as OS, -
client_os_level as OS_VER, -
node_name as Node, -
cast(cast(client_version as ch
t Stor Manager" <[EMAIL PROTECTED]>
Sent by:"ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
cc:
Subject:Re: Select command to q client name and version
Hi Carla;
Try this. I got this from group.
It will also display the O
I use
select
node_name,platform_name,client_os_level,client_version,client_release,client
_level,client_sublevel from adsm.nodes
and you can add in a :
where client_version<>4 AND client_release<>2 AND client_level<>2
if you want to see nodes not at a specific vrlm...
Dwight E. Cook
Software Ap
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of
Karla Ross
> Does anyone have a select command that will show me the clients and what
> version of TSM they are running? My TSM servers are running TSM
> v4.1, 4.2,
> and 5.1.
select node_name,client_version,client_release,clie
On 19-Sep-02 Karla Ross wrote:
> Does anyone have a select command that will show me the clients and what
> version of TSM they are running? My TSM servers are running TSM v4.1, 4.2,
> and 5.1.
select node_name,client_version,client_release,client_sublevel from nodes
--
Hi Carla;
Try this. I got this from group.
It will also display the OS versions.
select platform_name as OS, -
client_os_level as OS_VER, -
node_name as Node, -
cast(cast(client_version as char(2)) || '.' -
|| cast(client_release as char(2)) || '.' -
|| cast(client_level as char(2)) || '.' -
|
Hi Karla,
try
select node_name,client_version,client_release,client_level,client_sublevel
from nodes
Rgds,
Geirr G. Halvorsen
-Original Message-
From: Karla Ross [mailto:[EMAIL PROTECTED]]
Sent: 19. september 2002 15:08
To: [EMAIL PROTECTED]
Subject: Select command to q client name and v
ail:[EMAIL PROTECTED]
Dave Canan <[EMAIL PROTECTED]>@VM.MARIST.EDU> on 07/23/2002 07:49:40 PM
Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
Sent by:"ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
To:[EMAIL PROTECTED]
cc:
Sub
This problem was addressed in TSM 5.1.1.1, APAR IC33455.
At 04:57 PM 7/23/2002 -0400, you wrote:
>Known Problem. Call Support.
>
>Paul D. Seay, Jr.
>Technical Specialist
>Naptheon, INC
>757-688-8180
>
>
>-Original Message-
>From: Linda Seeba [mailto:[EMAIL PROTECTED]]
>Sent: Tuesday, Ju
Known Problem. Call Support.
Paul D. Seay, Jr.
Technical Specialist
Naptheon, INC
757-688-8180
-Original Message-
From: Linda Seeba [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 23, 2002 4:19 PM
To: [EMAIL PROTECTED]
Subject: Select Command problems with TSM 5.1.1
Environment: AIX
select node_name,sum(physical_mb) as "Physical",sum(logical_mb) as
"Logical" -
from occupancy -
group by node_name
Zlatko Krastev
IT Consultant
Robert Ouzen <[EMAIL PROTECTED]> on 20.12.2001 13:18:49
Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
cc
Well, right off I'd say
q auditocc
now besides that use
select sum (num_files), sum (physical_mb), sum (logical_mb), node_name from
adsm.occupancy group by node_name
Dwight
Unnamed[1]: 46132
Unnamed[2]: 1554.47
Unnamed[3]: 1523.37
NODE_NAME:
Unnamed[1]: 10992
Unnamed[2]: 1317.63
Unnam
44 matches
Mail list logo
