umbers listed above. Thank you.
**
-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Anders
Räntilä
Sent: Monday, December 11, 2017 10:30 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: Select statement for deduplication & co
Hi
This is simple math
select
stgpool_name,DEDUP_SPACE_SAVED_MB/(DEDUP_SPACE_SAVED_MB+COMP_SPACE_SAVED_MB+(EST_CAPACITY_MB*PCT_UTILIZED/100))*100||'%'
as "Dedup savings" from stgpools
select
stgpool_name,COMP_SPACE_SAVED_MB/(COMP_SPACE_SAVED_MB+(EST_CAPACITY_MB*PCT_UTILIZED/100))*100||'%'
s Prof. Sr.
TSM Delivery Architect
IBM Cloud
(918) 493-4678
From: Efim
To: ADSM-L@VM.MARIST.EDU
Date: 04/11/2016 08:20 AM
Subject:Re: Select statement for client occupancy by management
class...???
Sent by:"ADSM: Dist Stor Manager"
Do you use different s
Do you use different storage pools for each management class?
If no - it is very very difficult to calculate occupancy for each stored object
because you must select from backups table.
I don’t have select for do it.
Efim
> 11 апр. 2016 г., в 15:43, Dwight Cook написал(а):
>
> Does anyone hav
Thanks for the help!
This what I ended up with.
SELECT CAST((NODE_NAME) AS CHAR(20)) AS "Node Name",CAST(MIN(BACKUP_DATE) AS
DATE) AS "BACKUP DATE" FROM BACKUPS WHERE NODE_NAME LIKE '%_TDP' AND
STATE='ACTIVE_VERSION' AND CLASS_NAME LIKE
'%DB%' AND BACKUP_DATE < '2015-02-01' AND FILESPACE_NAME N
This probably isn't completely right, but it might be a start:
select node_name,hl_name,min(backup_date) from backups group by
node_name,hl_name
--
Cameron Hanover
chano...@umich.edu
"Let's get dangerous."
--Darkwing Duck
On Mar 9, 2015, at 3:42 PM, Kamp, Bruce (Ext) wrote:
> I am found a co
Bruce,
You could do a group by node_name at the end of your select statement.
Best Regards,
_
email: ron.delaw...@us.ibm.com
Storage Services Offerings
From: "Kamp, Bruce (Ext)"
To: ADSM-L@VM.MARIST.EDU
Date: 03/09/15 12:46
SELECT * FROM ACTLOG WHERE MSGNO IN (406,4952,4954,4958,4960,4957,
4970,4959,4961,4965,4963,4966,4967,4968,4969,4964, 4976, 4981) and
start_time>current_timestamp - 24 hours
On 24 June 2014 19:39, Lepre, James wrote:
> Hello Everyone -
>
> I am attempting miserably I might add to write a select
Version 7.1
James Lepre
Infrastructure Support Specialist
Solix, Inc. | 30 Lanidex Plaza West | Parsippany, NJ 07054
T: 973.581.5362 | F: 973.599.6544
www.solixinc.com | Solix on Facebook | Solix on Twitter
-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On
James,
What version of TSM? Your select statement will work in TSM 6.3 if
you change "start_time" to "date_time". Please note that I did not
verify the output, only that I got output.
Rick
At 01:39 PM 6/24/2014, you wrote:
Hello Everyone -
I am attempting miserably I might add to write a sele
Hi Joni,
As you could see, size is not shown is archive table. It would need to select
from the content table too. The select required will need a join between
archive and content and would be impossible to execute on a real life TSM
server.
I think that you may find an answer with export node
Carefully consider extending the retention on the Summary table, as the amount
of data can be large, taxing your database. What I prefer to do is keep a
smallish Summary table, given that the need to query old data is rare, where I
keep 30 days of Activity Log data in the database and older day
James,
set summaryretention xx
Merry Christmas
Bob.
-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Lepre,
James
Sent: Thursday, December 22, 2011 10:05 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] Select Statement
Does anyone know how
Does anyone know how to take this select command which produces only one month
of data and allow it to go back say 1 year if possible. I have tried to figure
it out but nothing works
select date(start_time) as "Start Date",time(start_time) as "Start
Time",date(end_time) as "End Date",time(end_t
Thanks Maurice, Thomas, Guido, keith, Heinz, Richard and Steven for
your responses
I had to retype the command there must have been a character binary
character not visible that was the issue which cause the error. I
originally did a cut and paste.
Best
Regards
On 11/15/2010 12:00 PM, Mauric
Thanks for this script
Regards
Tim
On 11/16/2010 6:49 AM, J. Pohlmann wrote:
For what it's worth, here is my "reado" script to display problem tapes:
issue message i "Read Only Volumes"
q vol acc=reado
issue message i "Unavailable Volumes"
q vol acc=unav
issue message i "Destroyed Volumes"
q v
For what it's worth, here is my "reado" script to display problem tapes:
issue message i "Read Only Volumes"
q vol acc=reado
issue message i "Unavailable Volumes"
q vol acc=unav
issue message i "Destroyed Volumes"
q vol acc=destroyed
issue message i "The following volumes had I/O errors:"
select v
Heey Timothy
Seems you accidently copied 2 lines, in stead of the command in 1
line. status='FILLING' has been processed as an other command, so
both lines gave errors.
Try again the same command, but be sure it's in 1 line.
Or use a - at the end of each line to continue, but best is to just use
-Timothy Hughes wrote: -
>I tried that command failed, and also I want to select the
>"readonly"
>tapes that say "filling" also. So I replaced the "or" with "and".
>this
>command failed also
>
>tsm: >select VOLUME_NAME,ACCESS from volumes where access='READONLY'
>or
>status='FILLING'
Perhaps this would also work:
Select VOLUME_NAME from VOLUMES where status='FILLING' and access='READONLY'
El nov 15, 2010 11:30 a.m., "Keith M Williams"
escribió:
How about this for TSM:
select VOLUME_NAME,ACCESS from volumes where access ='READONLY', STATUS
from media where VOLUME_NAME='FIL
How about this for TSM:
select VOLUME_NAME,ACCESS from volumes where access ='READONLY', STATUS
from media where VOLUME_NAME='FILLING'
Keith M Williams/Dubuque/IBM
Unix System Administrator, IBM Dubuque
ITDelivery, Global Technology Services
kwill...@us.ibm.com
From:
Timothy Hughes
To:
ADSM
According to Timothy Hughes:
> thanks steve!
>
> I tried that command failed, and also I want to select the "readonly"
> tapes that say "filling" also. So I replaced the "or" with "and". this
> command failed also
>
> tsm: >select VOLUME_NAME,ACCESS from volumes where access='READONLY' or
> status
If you only want to find tapes in "FILLING" this select should be more than
enough:
Select VOLUME_NAME from VOLUMES where status='FILLING'
El nov 15, 2010 10:50 a.m., "Steven Langdale"
escribió:
How about:
select VOLUME_NAME,ACCESS from volumes where access='READONLY' or
status='FILLING'
Stev
thanks steve!
I tried that command failed, and also I want to select the "readonly"
tapes that say "filling" also. So I replaced the "or" with "and". this
command failed also
tsm: >select VOLUME_NAME,ACCESS from volumes where access='READONLY' or
status='FILLING'
ANR0162W Supplemental database
How about:
select VOLUME_NAME,ACCESS from volumes where access='READONLY' or
status='FILLING'
Steven
Timothy Hughes
Sent by: "ADSM: Dist Stor Manager"
15/11/2010 13:39
Please respond to
"ADSM: Dist Stor Manager"
To
ADSM-L@VM.MARIST.EDU
cc
Subject
[ADSM-L] select statement to display rea
That worked like a charm! Thanks so much!
-Original Message-
From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of
Sheridan, Peter T.
Sent: Tuesday, June 29, 2010 1:49 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: Select statement to only list backups with particular event
Here is a select statement that I use to get all of this info for the
last 24 hours:
select * from events where status!='Completed' and status!='Future' and
status!='Pending' and status!='Started' and scheduled_start >=
'2010-01-01' and scheduled_start >= current_timestamp - 24 hours
---
n progress or has been started.
>
> Any suggestions/ideas are appreciated! This one has me stumped!
>
> -Original Message-
> From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of
> Richard Sims
> Sent: Tuesday, June 29, 2010 12:09 PM
> To: ADSM-L@VM.
The only way to see status=Started jobs is if you perform a query while they
are under way: if you really wanted that, a cron job capture would take care of
it. Running a query after all scheduled backups have finished will report
final status of Completed (or Missed or Failed), which is probab
e 29, 2010 12:09 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: Select statement to only list backups with particular event status
The EVENTS table has been an oddball in TSM, as I note in ADSM QuickFacts,
because of the way it was engineered. Using relative timestamp references
traditionally doesn&#x
The EVENTS table has been an oddball in TSM, as I note in ADSM QuickFacts,
because of the way it was engineered. Using relative timestamp references
traditionally doesn't work, so you need to employ an absolute timestamp, as in
select * from events WHERE SCHEDULED_START >= '2010-06-28'
Not
OK, then, back to my ugly select, shich I'm sure needs correction - No
way in heck I'm going to run it on my server.
-Original Message-
From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of
Thomas Denier
Sent: Friday, February 27, 2009 11:27 AM
To: ADSM-L@VM.MARIST.ED
-Timothy Conway wrote: -
>Ok, here. Do a stgpool backup, disable sessions and do another
>stgpool backup to eliminate and prevent new data. While sessions
>are still disabled, mark the volume in question destroyed, and do
>a stgpool backup preview. That should tell you every primary
>vo
What he means is no onsite copypool, and not all primary volumes are in
the library. Our library's inadequate too.
A restore volume preview isn't an option for a copypool volumes either
:(
Move data doesn't have a preview.
Ok, here. Do a stgpool backup, disable sessions and do another stgpoo
Select volume_name fron contents where object_id in (select object_id from
contents where volume_name='volumename') and stgpool='primarypoolname') group
by volume_name
I think it would take a LONG freaking time to run, though.
-Original Message-
From: ADSM: Dist Stor Manager [mailto:ads
I too am confused, not that that is so unusual. I am not sure I
understand what you are saying.
There are offsite volumes, but no copypool. So, the (physically ?)
offsite volumes are in the primary pool hierarchy? Is that the case?
If so, and reclamation is really what is going on, then it is s
I am confusing. What i am trying to say is I know the tape being reclaimed but
that tape need other tapes to pull files from simce it is non collocated. Am i
making sense
- Original Message -
From: ADSM: Dist Stor Manager
To: ADSM-L@VM.MARIST.EDU
Sent: Tue Feb 24 16:24:03 2009
Subject:
Hmm. I'm confused. IF you don't have a copy pool then the volume
required for reclamation is the volume, or volumes that are set to be
reclaimed.
A good way to find out which volumes need reclamation is:
select volume_name as TAPEPOOL_VOL,est_capacity_mb as
CAPACITY,pct_utilized as UTILIZATION,
There is a command to find out which volumes would be required to
"restore" a volume. So I'd assume they'd be the same offsite volumes
that would be required for reclamation. Right?
Restore vol volnum preview=yes
See Ya'
Howard
> -Original Message-
> From: ADSM: Dist Stor Manager [mai
Well The reason I am asking is that we do not have a copypool setup for
our offsite tapepool since we are using a VTL. However, the physical
library is small and some of the tapes needed to reclaim may not be in
the system. If I can generate a list of tapes needed to reclaim a
certain volume then
Interesting question.
Why would you want to know? I hope your primary volumes are all on-line?
On Feb 24, 2009, at 21:48 , Lepre, James wrote:
Hello Everyone,
Is there a select statement or preview to see which tapes will be
needed to reclaim an offsite volume.
Thank you
James
Hello Everyone,
Is there a select statement or preview to see which tapes will be
needed to reclaim an offsite volume.
Thank you
James
---
Confidentiality Notice: The information in this e-mail and any attachm
hodes"
Sent by: "ADSM: Dist Stor Manager"
12/30/2008 07:20 AM
Please respond to
"ADSM: Dist Stor Manager"
To
ADSM-L@VM.MARIST.EDU
cc
Subject
Re: Select statement to output backup & archive summary per domain
Here is what I use for this info . . . from our morn
Here is what I use for this info . . . from our morning_report.ksh scripts.
function r184 {
Title="r184 backup objects and bytes per domain "
PrintTitle
# objects and MB for each domain over the last 24 hr
# NOTE: This is some overlap given the "< 25" hour period, but
# that'
Avy,
If it is a case of having duplicates where one is Unicode and the other is
non-Unicode, it is likely that the non-Unicode file space is no longer
used. Use QUERY FILESPACE with F=D to see when each was last backed up.
You can either delete the old file space (if no longer needed -- check
Hi Andrew,
Yes I found them, there are duplicate filespace on one node, at least
for now, there might be some more on others.
What do you do to resolve this? If I delete the dups, the filespace that
are empty, will that solve the problem?
Avy Wong
Business Continuity Administrator
Mohegan Su
Hi Avy,
We've seen this when the node has a duplicate file space name. For
example, if a Windows client had a non-unicode file space that was not
converted to Unicode, but instead created a new Unicode file space might
cause this.
While you could construct a SELECT statement to identify duplic
Hi Andrew,
Thank you for pointing me to take a look at the act logs, there sure
is a lot more than the error ANR2956E. The following link does not exactly
tell me the problem as my server version is 5.4.3.0 and I am just running a
select statement. I might submit a PMR to look further into t
Hi Avy,
If you look up message ANR2956E, you'll see it says the message might be
preceded by other messages. If you didn't see anything else on your
console, check the activity log from when you ran the SELECT command to
see if there are any other anomalous messages.
Best regards,
Andy
Andy
Hmmm... I will take another look. Thanks for verifying it.
Avy Wong
Business Continuity Administrator
Mohegan Sun
1 Mohegan Sun Blvd
Uncasville, CT 06382
(860)862-8164
(cell) (860)961-6976
"Patel, Ankur"
Avy,
I tried your query on my machine and it has worked fine.
See results:
~~
AUCFTSM01_PROD>select vu.node_name, ao.total_mb, count(distinct
vu.volume_name) as tapes, ao.total_mb/count(distinct vu.
volume_name) as "AVG MB/tape" from volumeusage vu, auditocc ao where
vu.node_name
On Aug 13, 2008, at 8:53 AM, Tim Brown wrote:
Is it possible to query TSM with a select statement that will detail
out
a particular
filespace. If so does any one have one.
Say a filespace \\NODE1\D$ for node NODE1. This particular drive has 5
folders
Can TSM show the percentage of storage for e
http://www-1.ibm.com/support/docview.wss?rs=1019&context=SSSQWC&context=
SSGSG7&q1=ACTIVE+Data+pool+size&uid=swg21267260&loc=en_US&cs=utf-8&lang=
en
Regards, Rama
-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Tim Brown
Sent: Wednesday, August 13,
select session_id,client_name from sessions where session_type='Node'
and client_name in (select node_name from nodes where
domain_name='DOMAIN_NAME')
-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Tim Brown
Sent: Tuesday, June 03, 2008 4:48 PM
To:
Well, you can check the SESSIONS table to answer the question as to
whether the DOMAIN appears in there (it does not).
So do a SELECT from the SESSIONS table and add a WHERE criterion that
includes a subquery from the NODES table. The subquery can return node
names that are in the desired domain.
Q DRM * gives you the list of tapes in the COPY pool that aren't marked
OFFSITE.
(By default it also includes the DBBACKUPS, unless you specify something
else on the Q DRM)
Depending on when you run the Q DRM, it MAY be the same as the tapes
created that day.
It will USUALLY be the tapes created s
Would this be the count of tapes made mountable that day?, q drm *
wherestate=mountable? - I don;'t have access to a TSM server to test a
select for the same info. That would assume you are moving mountable tapes
to state 'vault' each day.
Matt.
Internet
[EMAIL PROTECT
Good idea, thanks
Ricardo Ribeiro
Storage Administrator
623-217-4139
- Original Message -
From: ADSM: Dist Stor Manager
To: ADSM-L@VM.MARIST.EDU
Sent: Fri Jan 04 16:38:41 2008
Subject: Re: [ADSM-L] Select statement
You could also look at volhistory where use(?)='STGNEW' and date =desire
You could also look at volhistory where use(?)='STGNEW' and date =desired range.
From: ADSM: Dist Stor Manager on behalf of Ribeiro, Ricardo
Sent: Fri 1/4/2008 2:51 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] Select statement
Thank you!
-Original Mes
Thank you!
-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Richard Sims
Sent: Friday, January 04, 2008 12:47 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] Select statement
On Jan 4, 2008, at 1:12 PM, Ribeiro, Ricardo wrote:
> Hello,
> Does any
On Jan 4, 2008, at 1:12 PM, Ribeiro, Ricardo wrote:
Hello,
Does anyone has a select statement I can use to find out how many
tapes
I used on a daily basis?
Thanks!
Most commonly, tapes automatically come from the scratches collection
and return to scratch when emptied (rather than being assign
This is what I run to get that kind of information:
select library_name,volume_name from libvolumes where status='Scratch'
select stgpool_name,status,count(*) from volumes where scratch='YES' group
by stgpool_name,status
select library_name, last_use, status, count(status) from libvolumes
group
No, I need one that tells me how many I used and not how many I have...
Thanks!
-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Choudarapu, Ramakrishna (GTI)
Sent: Friday, January 04, 2008 11:17 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] Sele
We use this to find out the scratch counts:
select library_name, status, count(*) as VOL_COUNT from libvolumes group
by library_name,status
Is this the one, you are looking for?
-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Ribeiro, Ricardo
Sent:
I suspect the value of passexp can be NULL, so it should be
select node_name,passexp from nodes where not (passexp is null)
Rainer
On Tue, 27 Nov 2007, goc wrote:
> try this -->
>
> select node_name, passexp from no
try this -->
select node_name, passexp from nodes where PASSEXP!=0
On Nov 27, 2007 4:06 PM, Herrmann, Boris <[EMAIL PROTECTED]> wrote:
> Hello,
>
> we would like to get a list of nodes where the option "PASSEXP" is unequal 0.
> We used the following SQL statement:
>
> tsm: SA023ADD>select node_n
Thanks very much guys!
-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
William Boyer
Sent: Friday, October 19, 2007 9:13 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: Select statement for space occupied by type of file?
Maybe the easiest is to either
Maybe the easiest is to either from the original server or from another Windows
box with the TSM client, start the client CLI and
run a QUERY BACKUP for *.PST files with -SUBDIR=YES. If you want all, the
include the -INA flag to get the inactive version(s), too.
It's quick and easy. Pipe the outp
dsmc q backup -nodename=node '{\\node\d$}\directory\*.pst' -subdir=yes
>c:\path\output.txt
Load the output into excel as fixed width text.
-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of
Thach, Kevin G
Sent: Friday, October 19, 2007 5:20 AM
To: ADSM-L
On 9/6/07, Henrik Wahlstedt <[EMAIL PROTECTED]> wrote:
> Hi,
>
> No, but try:
>
> Select 'upd node', node_name as "node_name ",
> 'clopt=win_optset' as "clopt=win_optset" from nodes where
> platform_name='WinNT'
>
> Copy or redirect the output to a text file ex. cloptset.mac.
>
> And r
Hi,
No, but try:
Select 'upd node', node_name as "node_name ",
'clopt=win_optset' as "clopt=win_optset" from nodes where
platform_name='WinNT'
Copy or redirect the output to a text file ex. cloptset.mac.
And run the macro, macro c:\cloptset.mac.
//Henrik
-Original Messag
-Brenda Collins wrote: -
>Does anyone know of a way to determine what files existed under a
>specific directory path for a node as of a certain date and time?
Your subject line suggests that you are looking for a select command,
but I think it will be easier to get the information using o
This should give you what your looking for:
select node_name as "Nodes Not Associated" -
from nodes -
where node_name not in -
(select node_name from associations)
best regards
Hans-Jørgen Bergmann
Total Storage Solutions AS
[EMAIL PROTECTED]
ons, 07.02.2007 kl. 13.29 +0100, skrev Herrmann, B
> Now I want also a select statement which shows me all the nodes
> which haven't any associated Schedules. How could I do that?
select node_name from nodes \
where node_name not in (select distinct node_name from associations)
Regards,
Andy
Andy Raibeck
IBM Software Group
Tivoli Storage Man
Just a thought I am not sure if this will work but Attack it from another
angle. It sounds like you are looking at the stg pool table from the select
statement. Instead do the select statement against the activity log table
looking for the migration processes.
-Original Message-
Fro
I'm not sure if you can do this with a select. One thing you could try
would be an export node, with filedata=ALLActive and preview=yes.
Matt.
> -Original Message-
> From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]
> On Behalf Of Fawad Baig
> Sent: 07 November 2006 15:09
> To: A
t; backed up in over 5 days, but that's another battle.
>
> Thanks again!
>
>
> Joni Moyer
> Highmark
> Storage Systems, Senior Systems Programmer
> Phone Number: (717)302-9966
> Fax: (717) 302-9826
> [EMAIL PROTECTED]
> *
-9966
Fax: (717) 302-9826
[EMAIL PROTECTED]
"Andrew Raibeck" <[EMAIL PROTECTED]>
Sent by: "ADSM: Dist Stor Manager"
10/05/2006 01:03 PM
Please respond to
"ADSM: Dist Stor Manager"
To
ADSM-L@VM.MARIST.EDU
cc
Subject
Re: Se
Highmark
> Storage Systems, Senior Systems Programmer
> Phone Number: (717)302-9966
> Fax: (717) 302-9826
> [EMAIL PROTECTED]
>
>
>
>
> "Andrew Carlson" <[EMAIL PROTECTED]>
> Sent by: "ADSM: Dist Stor Manager"
Joni,
Run the command using dsmadmc executable and pass the command as a parameter
dsmadmc -id=admin -PASSWORD=admin -DISPL=LIS select
node_name,filespace_name,backup_start,backup_end from filespaces where
node_name like 'NAS%' or node_name like 'SERVER%'
Aravind
-Original Message-
From:
t by: "ADSM: Dist Stor Manager"
10/05/2006 10:45 AM
Please respond to
"ADSM: Dist Stor Manager"
To
ADSM-L@VM.MARIST.EDU
cc
Subject
Re: Select Statement Syntax
I went through this same problem. Never got a satisfactory answer,
totally. It behaves differently depen
Srinath,
SELECT * FROM CLIENT_SCHEDULES
SELECT * FROM ADMIN_SCHEDULES
Regards,
Ramakrishna Choudarapu
-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Gopinathan, Srinath
Sent: Thursday, October 05, 2006 10:33 AM
To: ADSM-L@VM.MARIST.EDU
Subject
Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Gopinathan, Srinath
Sent: Thursday, 05 October, 2006 16:33
To: ADSM-L@VM.MARIST.EDU
Subject: Re: Select Statement Syntax to view the schedule
Hi All,
I am able to see the node info using the following command
TSM>Select * from nodes
Howe
Try
select tabname, remarks from tables
to get information about available tables you can query. You should see
some table names that might be suitable.
Andy Raibeck
IBM Software Group
Tivoli Storage Manager Client Development
Internal Notes e-mail: Andrew Raibeck/Tucson/[EMAIL PROTECTED]
Int
I went through this same problem. Never got a satisfactory answer,
totally. It behaves differently depending on if you do it from a terminal,
or disconnected, like from cron. Also it depends on the setting of
sqldisplaymode. Try the command `set sqldisplaymode wide` and see if that
makes it lo
On Oct 5, 2006, at 9:00 AM, Joni Moyer wrote:
Hello Everyone,
I have been trying to figure out how to have the syntax of the below
output so that it will all go on 1 line, but so far I have been very
unsuccessful.
...
Joni -
Explore the capabilities of SQL in order to use it effectively, and
dsmadmc -se= -id= -pa= -commad
-outfile= select
node_name,filespace_name,date(backup_start) as
start_date,time(backup_start) as start_time,date(backup_end) as
end_date,time(backup_end) as end_time from filespaces where node_name
like 'NAS%' or node_name like 'SERVER%'
Regards,
Rama
-Origi
Joni,
Try this and see if it makes any difference, it will manipulate the
returned backup_start and backup_end to only be 16 chars and thus loose
the ".00"
I feel sure that there is tidier way to do this, but I have yet to find
it. Suggestions gladly appreciated. In the meantime this might he
Use:
select node_name as "NODE_NAME ",
filespace_name as "FILESPACE_NAME", ...
padding the quoted titles with enough blank spaces to achieve what you
want.
Alternatively, consider using a Windows spreadsheet or database program to
access the TSM
Joni,
Node_name column is wrapping because the overall length of the output is
too long : you should try to reduce it.
You where on the right track for doing this while trying to reduce the
output for backup_start/end fields.
To achieve this, try to use :
select node_name,filespace_name,time(ba
Hi All,
I am able to see the node info using the following command
TSM>Select * from nodes
However, the same doesn't work as
TSM>Select * from schedules
Can anybody let me know the right command for getting info about
schedules using select statement
Regards,
Srinath G
This e-mail has been s
Joni Moyer said the following on 10/5/06 9:00 AM:
Hello Everyone,
I have been trying to figure out how to have the syntax of the below
output so that it will all go on 1 line, but so far I have been very
unsuccessful.
Here is the statement I am issuing:
select node_name,filespace_name,backup_s
Joni,
Have a look at the CONTENTS table, as that includes volume names, node
names and file names.
Another approach that I'd suggest you follow first: check for any volumes
or storage pools with access other than readwrite or readonly; any random
access disk storage pool volumes that are offline;
First you need to find out what filespace it is assigned to. If you
don't already know the filespace that it came from, this can be
identified by running the following select statement in the
administrative command line:
select filespace_name,hl_name,ll_name where node_name='NAME_OF_NODE' and
ll_
The onsite tape is probably is not readable. Check to see if you have any
volumes where access=unavailable.
Orville L. Lantto
Glasshouse Technologies, Inc.
From: ADSM: Dist Stor Manager on behalf of Joni Moyer
Sent: Wed 4/19/2006 1:52 PM
To: ADSM-L@VM.MARIST.
Try running this one (I can't remember if this is long running or not and I
don't have TSM DB available to me right now):
select distinct date (archive_date) as date, node_name, filespace_name,
description from archives
__
John Monahan
Senior Consultant Enterprise Sol
f you do just 1 select without the index.
Wanda Prather
"I/O, I/O, It's all about I/O" -(me)
-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Richard Sims
Sent: Friday, January 06, 2006 7:56 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Re:
On Jan 6, 2006, at 3:10 AM, De Keyser Bart wrote:
...
Within the retrieve module of the Backup-Archive Gui, you can view a
list of all available archives.. so it should be possible to generate
this list with a select, no?? ...
Yes, but fishing expeditions are very expensive in the TSM database
Hi Joni,
The timestamp format is:
'-mm-dd hh:mm:ss.nn'
where:
= year
mm = month
dd = day
hh = hours
mm = minutes
ss = seconds (optional)
nn = fraction of a second (optional)
When referring to a timestamp, put it in single quotes and use the above
format, i.
This command looks very familiar.
Here's ya go. try this
select with duration
select left(entity,10) as node_name, date(start_time) as date,-
cast(activity as varchar(8)) as activity, time(start_time) as start, -
time(end_time) as end,cast(bytes/1024/1024 as decimal(6,0)) as mb, -
cast(substr(c
1 - 100 of 243 matches
Mail list logo
