er [mailto:ads...@vm.marist.edu] On Behalf
> Of Gabriel Peter
> Sent: Thursday, January 29, 2009 5:47 PM
> To: ADSM-L@VM.MARIST.EDU
> Subject: Re: [ADSM-L] q mo - select command to return volume and
status
>
> Jeremy, try 'select library_name,drive_name,drive_state from DRIVES
Jeremy, try 'select library_name,drive_name,drive_state from DRIVES'.
You can also play with 'tapeutil' command on Unix platform, try 'tapeutil
help'
Regards
Gabriel Peter
2009/1/30 Conradt, Jeremy
> Does anyone know what the select command would be to return
Does anyone know what the select command would be to return a list of
the volumes currently mounted and the status.
I can get the mounted volumes with "select volume_name from drives" but
that does not tell me if it is idle or in use like the q mo command
tells me.
Thanks,
Jeremy
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
U
Dist Stor cc
Manager"
<[EMAIL PROTECTED] Subject
.EDU>
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)
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
thanks
Luc Beaudoin
Administrateur Réseau / Network Administrator
Hopital General Juif S.M.B.D.
Tel: (514) 340-8222 ext:8254
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, cas
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
Hi,
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?
Regards,
Srinath G
This e-mail has been scanned for viruses by the Cable & Wireless e-mail
security system - powered by MessageLabs. Fo
Eyþórsson
Sent: Wednesday, February 08, 2006 5:26 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Select command to show summary of bytes bound to managment class
Hi TSMers
Just wondering if anyone has made a Select command that shows the total amount
of data bound to each, or spesific managment class.
with
Hi TSMers
Just wondering if anyone has made a Select command that shows the total amount
of data bound to each, or spesific managment class.
with help in advance
Regards
peter
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
I agree, is there a select command I could use to say the following
though.
I need nodename, and whether the schedule was successful or failed
-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Stapleton, Mark
Sent: Monday, May 09, 2005 3:24 PM
To
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
o checkout only database tapes, it does not only checkout
db tapes, it checks database and data.
I was going to try the "select" command to select database tapes that
are onsite, send out to a file and run a checkout/move on the listed
media. But move and checkout does not allow you to us
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
Hi, the option below worked, thanks for that.
But is there a way to send the output from the select command to issue
the move command to checkout tapes?
select volume_name from volhistory where
Date(date_time)=date(current_timestamp)
type='BACKUPFULL' location<>'VAULT
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://
Sent: Wednesday, October 06, 2004 11:31 AM
To: [EMAIL PROTECTED]
Subject: select command
Hi,
I am trying to complete a select command to "select volume_name from
volhistory where type='backupfull' and date_time>'today'" which fails
because today is incorrect, c
Hi,
I am trying to complete a select command to "select volume_name from
volhistory where type='backupfull' and date_time>'today'" which fails
because today is incorrect, can you tell me the correct format.
Also when the above runs successfully, I will requi
Karla Ross wrote:
I am trying to find the tapes needed to recover only the "active" backups
of a client. I used the following select command and it gives me a list of
all tapes for all backups of that client. How can I narrow the search to
just "active" backups?
select volume
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On
Behalf Of Karla Ross
>I am trying to find the tapes needed to recover only the
>"active" backups of a client. I used the following select
>command and it gives me a list of all tapes for all backups of
>that cli
I am trying to find the tapes needed to recover only the "active" backups
of a client. I used the following select command and it gives me a list of
all tapes for all backups of that client. How can I narrow the search to
just "active" backups?
select volume_name,filespace_n
>Is anyone aware a command that I can issue on TSM server to get the list of
>tapes needed for restore ...
A frequently asked question...
There is no command that will provide you with pertinent volume names.
See "Restoral preview" in http://people.bu.edu/rbs/ADSM.QuickFacts
for verbiage on this.
Howdy folks,
Is anyone aware a command that I can issue on TSM server to get the list of
tapes needed for restore with point in time/date and filesystem for a
node?
I am aware of this command, but it shows me all the tapes used by the node.
I need to reduce the list of tapes further by point in t
[mailto:[EMAIL PROTECTED]
Sent: Friday, May 30, 2003 2:17 PM
To: [EMAIL PROTECTED]
Subject: Re: Need select command to show how much is backed up
From: Cinda Mullen [mailto:[EMAIL PROTECTED]
> and, from the summary table:
As has been discussed frequently (today, even!), the summary tabl
From: Cinda Mullen [mailto:[EMAIL PROTECTED]
> and, from the summary table:
As has been discussed frequently (today, even!), the summary table has a
history of inaccuracy; data from select statements issued to it are
suspect.
--
Mark Stapleton ([EMAIL PROTECTED])
Berbee Information Networks
Off
EMAIL PROTECTED]
cc:
Subject:Re: Need select command to show how much is backed up
By client:
select node_name, sum(logical_mb) as Data_In_MB, sum(num_files) as
Num_of_files from occupancy group by node_name order by node_name asc
>>> [EMAIL PROTECTED] 05/30/03 12:34PM >>>
I ne
nce Clark [mailto:[EMAIL PROTECTED]
Sent: Fri 5/30/2003 12:01 PM
To: [EMAIL PROTECTED]
Cc:
Subject: Re: Need select command to show how much is backed up
By client:
select node_name, sum(logical_mb) as Data_In_MB, sum(num_fil
By client:
select node_name, sum(logical_mb) as Data_In_MB, sum(num_files) as
Num_of_files from occupancy group by node_name order by node_name asc
>>> [EMAIL PROTECTED] 05/30/03 12:34PM >>>
I need a select command the will show me how much data is being backed
up
by my tsm
I need a select command the will show me how much data is being backed up
by my tsm server, can anyone help?
Karla Ross
61 226 17 01 |
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
-Original Message-
From: Chandrasekhar, C.R [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, 11 February, 2003 6:03
To: [EMAIL PROTECTED]
Subject: select command
hi TSM guys,
How can I write equivalent select command for the following command.
q event * * begi
hi TSM guys,
How can I write equivalent select command for the following command.
q event * * begindate=today-1 enddate=today-1
I tried many ways to achieve this some were Iam facing problem while
manipulating date function.
Thanks,
chandrasekhar.cr
System Executive,
Tivoli Certified
Oups ! Once again:
select * from libvolumes where library_name='SCALAR' and status='Private'
and last_use IS NULL
Kaj
-Original Message-
From: Robert Ouzen [mailto:[EMAIL PROTECTED]]
Sent: 30. januar 2003 08:54
To: [EMAIL PROTECTED]
Subject: Help on Select comma
Hi Robert
You can use
select * from libvolumes where library_name='SCALAR' and status='Private'
and last_use is blank
Kaj
-Original Message-
From: Robert Ouzen [mailto:[EMAIL PROTECTED]]
Sent: 30. januar 2003 08:54
To: [EMAIL PROTECTED]
Subject: Help on Select c
Kopie:
Hi to all
I try to figure the correct select syntax to get the volumes from a library
where the status is Private and the last use is empty:
I run:
select * from libvolumes where library_name='SCALAR' and status='Private'
and last_use=' '
and got: ANR2034E SELECT: No match found using this crit
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
]]
Sent: Friday, November 22, 2002 8:37 AM
To: [EMAIL PROTECTED]
Subject: select command to get old scheduled events
Hi All,
How can I get old scheduled events using select commands, I can get the same
using 'q event' but when I execute 'select * from events' I am getting only
th
Cell (831) 595-3962
[EMAIL PROTECTED]
-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]] On Behalf Of
Charakondala, Chandrasekhar R.
Sent: Friday, November 22, 2002 5:37 AM
To: [EMAIL PROTECTED]
Subject: select command to get old scheduled events
Hi All,
How can
Hi All,
How can I get old scheduled events using select commands, I can get the same
using 'q event' but when I execute 'select * from events' I am getting only
the latest events on scheduled backup.
Thanks in advance,
chandrasekhar
**
Hello TSM'ers,
I'm trying to find out my utlization of tapes per client
in order to calculate room for expansion next year.
Does anyone have a select command to fit?
FYI, I'm running TSM 4.2.1 on AIX 4.3.3
Regards,
Bassam
7; -
|| cast(client_sublevel as CHAR(2)) as "LEVEL " -
, left(option_set,6) as "OPTION_SET" -
, contact as "Contact " -
from nodes
On Thu, 19 Sep 2002, Alexander Verkooijen wrote:
> On 19-Sep-02 Karla Ross wrote:
>
> > Does any
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
PROTECTED]
Subject: Select command to q client name and version
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.
Karla Ross
rm_name,node_name
Guillaume Gilbert
CGI Canada
Karla Ross <[EMAIL PROTECTED]>@VM.MARIST.EDU> on 2002-09-19 09:08:08
Veuillez répondre à "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
Envoyé par : "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
Pour
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,cl
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 f
-Original Message-
From: Karla Ross [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 19, 2002 9:08 AM
To: [EMAIL PROTECTED]
Subject: Select command to q client name and version
Does anyone have a select command that will show me the clients and what
version of TSM they are running?
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
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.
Karla Ross
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
AIL PROTECTED]]
>Sent: Tuesday, July 23, 2002 4:19 PM
>To: [EMAIL PROTECTED]
>Subject: Select Command problems with TSM 5.1.1
>
>
>Environment: AIX 4.3.3 TSM 5.1.1 Server Code
>
>
>Prior to TSM 5.1.1 I was able to get statistics for backups from the Summary
>table
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
Environment: AIX 4.3.3 TSM 5.1.1 Server Code
Prior to TSM 5.1.1 I was able to get statistics for backups from the
Summary table using the select command. Since upgrading the Server code to
5.1.1 the summary table no longer contains information for backup activity.
When I do select commands
Sent by: "ADSM:Subject: Need a select command
Dist Stor
Manager"
<[EMAIL PROTECTED]
ST.EDU>
02/14/2002
03:39 AM
Please respond
Hi Mustafa
Thanks Can I got too from this select the total of all.
Robert
-Original Message-
From: MUSTAFA BAYTAR [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 14, 2002 10:50 AM
To: [EMAIL PROTECTED]
Subject: Re: Need a select command
Robert try this.
/* how much data in
cc: (bcc: MUSTAFA BAYTAR/ATIM/ICECEK)
Sent by: "ADSM: Subject: Need a select command
Dist Stor
Manager"
<[EMAIL PROTECTED]
ST.EDU>
Hi
To select guru I need one for calculate the amount of data store in my site.
I run q auditocc but I need the total of each domain.
T.I.A Robert Ouzen
[EMAIL PROTECTED]
IL PROTECTED]>
To: [EMAIL PROTECTED]
cc:
Subject:Select command
Hi
Did anybody know how to calculate with a select command the sum of all my Q
OCC ??
Thanks Robert Ouzen
E-Mail: [EMAIL PROTECTED]
1,318 0 0
1,318
tsm: TSMSRV06>
-Original Message-
From: Robert Ouzen [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 20, 2001 5:19 AM
To: [EMAIL PROTECTED]
Subject: Select command
Hi
Did anybody know how to calculate with a select command the sum of a
Hi
Did anybody know how to calculate with a select command the sum of all my Q
OCC ??
Thanks Robert Ouzen
E-Mail: [EMAIL PROTECTED]
77 matches
Mail list logo
