EDU
Subject: Re: SQL query replnodes
Bonjour Eric,
If you find the node in the REPLICATIONVIEW table, it means it has replicated
at least once, which means it would also show up in Q REPLNODE.
Now, what I can't test at the moment is that once you do a REMOVE REPLNODE,
does it clea
T.EDU
Subject: Re: SQL query replnodes
Hi Eric,
I had the same issue with the q replnode always returning a RC 0. I worked
around it by assuming the node was replicated UNLESS either ANR2726E or
ANR1701E was found in the q replnode output. I know it is not the most elegant
approach but it worked f
2 17:09
To: ADSM-L@VM.MARIST.EDU
Subject: Re: SQL query replnodes
Hi Eric,
I do not think there is any trivial way to use SELECT, as I suspect the output
is computed rather than merely copied from an internal table. Is there some
special reason why the QUERY REPLNODE command is inadequate? If you
Kind regards,
Eric van Loon
Core Infra
-Original Message-
From: ADSM: Dist Stor Manager On Behalf Of Andrew Raibeck
Sent: donderdag 22 september 2022 17:09
To: ADSM-L@VM.MARIST.EDU
Subject: Re: SQL query replnodes
Hi Eric,
I do not think there is any trivial way to use SELECT, as I suspec
= nodes.node_name
order by filespaces.node_name, filespaces.filespace_name
Hope this helps.
Regards,
Joerg Pohlmann
-Original Message-
From: ADSM: Dist Stor Manager On Behalf Of Loon, Eric
van (ITOP DI) - KLM
Sent: Thursday, September 22, 2022 05:47
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-
--Original Message-
From: ADSM: Dist Stor Manager On Behalf Of Griggs, James
F. (JMD) (CTR)
Sent: Thursday, 22 September, 2022 11:00
To: ADSM-L@VM.MARIST.EDU
Subject: [EXTERNAL] Re: SQL query replnodes
Seems to me you could use the following fields from the "NODES" table:
REPL_STATE
R
stern
IBM
-Original Message-
From: ADSM: Dist Stor Manager On Behalf Of Loon, Eric
van (ITOP DI) - KLM
Sent: Thursday, September 22, 2022 09:47 AM
To: ADSM-L@VM.MARIST.EDU
Subject: [EXTERNAL] Re: [ADSM-L] SQL query replnodes
Hi Dmitry,
That still doesn't show me if replnodes e
nation replication node
Should both the repl_state and repl_node = "None" it is not being replicated
-Original Message-
From: ADSM: Dist Stor Manager On Behalf Of Loon, Eric
van (ITOP DI) - KLM
Sent: Thursday, September 22, 2022 8:47 AM
To: ADSM-L@VM.MARIST.EDU
Subject: [EXT
t: Re: SQL query replnodes
Hi all
Better to use
Select * from nodes where repl_state='NONE'
Repl_state can have three status: none, enabled, disabled
I think it's more correct
Dmitry Dukhov
https://www.tsmexplorer.copm
> On 21 Sep 2022, at 19:28, Rick Adamson wrote:
>
lsteren
> Sent: Wednesday, September 21, 2022 11:04 AM
> To: ADSM-L@VM.MARIST.EDU
> Subject: Re: [ADSM-L] SQL query replnodes
>
> * This email originated outside of the organization. Use caution when opening
> attachments or clicking links. *
>
> --
just checking for the repl_state won't always do.
Thanks for your help!
Kind regards,
Eric van Loon
Core Infra
-Original Message-
From: ADSM: Dist Stor Manager On Behalf Of Rick Adamson
Sent: woensdag 21 september 2022 19:29
To: ADSM-L@VM.MARIST.EDU
Subject: Re: SQL query replnodes
M
Sent: 21 September 2022 16:21
To: ADSM-L@VM.MARIST.EDU
Subject: [EXTERNAL] Re: [ADSM-L] SQL query replnodes
Hi Oscar,
The only statement related to replication in the script is a select * from
REPLICATIONVIEW with ur, which is not really what I'm looking for. I'm hoping
to find a SQL quer
r 21, 2022 11:04 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] SQL query replnodes
* This email originated outside of the organization. Use caution when opening
attachments or clicking links. *
--
Hey Eric,
Have a look i
Hi Oscar,
The only statement related to replication in the script is a select * from
REPLICATIONVIEW with ur, which is not really what I'm looking for. I'm hoping
to find a SQL query with basically the same output as a q replnode .
By the way, for us, this is definitely not the be
new report.
Best Regards,
Oscar Kolsteren
Lead Storage Consultant, IBM Client Storage Assessment Team (UKI)
-Original Message-
From: ADSM: Dist Stor Manager On Behalf Of Loon, Eric
van (ITOP DI) - KLM
Sent: 21 September 2022 09:16
To: ADSM-L@VM.MARIST.EDU
Subject: [EXTERNAL] [ADSM-L]
Hi everybody,
I'm trying to find a way to list replnode(s) through a SQL query, does anybody
know where this information can be found? So something like QUERY RPELNODE
, but than through a SQL query.
Thanks for any help in advance!
Kind regards,
Eric van Loon
Air France/KLM Core
Manager On Behalf Of Loon, Eric
van (ITOP DI) - KLM
Sent: piatok 12. augusta 2022 9:24
To: ADSM-L@VM.MARIST.EDU
Subject: [EXTERNAL] [ADSM-L] SQL query to identify all nodegroup members
Hi everybody,
I'm trying to create a SQL query to identify all nodegroup members for a
specific n
Hi,
Does anyone know how to query the TSM DB2 for outstanding requests with a
SELECT statement?
I basically need to do much the same as QUERY REQUEST does, but I only need a
Yes or No and would like to avoid parsing the output of QUERY REQUEST.
- Bent
COWI handles personal data as stated i
e
>
> Thank you VERY much for your help, I really appreciate it!
>
> Kind regards,
> Eric van Loon
> Air France/KLM Storage & Backup
>
>
> -Original Message-
> From: ADSM: Dist Stor Manager On Behalf Of Skylar
> Thompson
> Sent: donderdag 9 april 2020
Sent: donderdag 9 april 2020 20:21
To: ADSM-L@VM.MARIST.EDU
Subject: Re: SQL query
I forgot that GROUP BY depended on having an entry in the result table.
Unfortunately I don't have a TSM server with a reasonably-sized backups table
to test on (production ones are 1+ billion entries), so
a.
> ANS8001I Return code 11.
>
> Thanks again for your help!
>
> Kind regards,
> Eric van Loon
> Air France/KLM Storage & Backup
>
>
>
> -Original Message-
> From: ADSM: Dist Stor Manager On Behalf Of Skylar
> Thompson
> Sent: woensdag 8 april 2020 16:03
>
p; Backup
-Original Message-
From: ADSM: Dist Stor Manager On Behalf Of Skylar
Thompson
Sent: woensdag 8 april 2020 16:03
To: ADSM-L@VM.MARIST.EDU
Subject: Re: SQL query
Ah, I think the problem is that comparing anything with NULL will be NULL
(except comparing NULL with NULL, which is t
have 0 files) are not listed.
> Thanks for your help!
>
> Kind regards,
> Eric van Loon
> Air France/KLM Storage & Backup
>
> -Original Message-
> From: ADSM: Dist Stor Manager On Behalf Of Skylar
> Thompson
> Sent: dinsdag 7 april 2020 23:42
> To: ADSM-L@V
half Of Skylar
Thompson
Sent: dinsdag 7 april 2020 23:42
To: ADSM-L@VM.MARIST.EDU
Subject: Re: SQL query
I think what you're looking for is an outer join:
select a.node_name, count(*)
from backups a
right join nodes b on a.node_name=b.node_name and a.node_name like '%-ORC'
where
I think what you're looking for is an outer join:
select a.node_name, count(*)
from backups a
right join nodes b on a.node_name=b.node_name and a.node_name like '%-ORC'
where
((days(current_date) - days(backup_date) >= 30))
and a.state='ACTIVE_VERSION'
and b.contact like '%
Hi guys,
It must be something very easy, but I can't seem find the solution myself...
This is the query I use to list the total amount of Oracle backup files older
than 30 days:
select count(*) as OBSOLETE_BACKUPS from backups a,nodes b where
((days(current_date) - days(backup_date) >= 30)) an
Y,f.PCT_UTIL
>order by 1
>
>Regards,
>Maurice van 't Loo
>
>http://mvantloo.nl/maupack.php
>Personal pack of selects (in scripts)
>
>
>2016-04-22 16:35 GMT+02:00 Schneider, Jim :
>
>> You can also start the session with -virtualnodename. It works with dsmc
>
need for the proxy setting.
>
> Jim Schneider
> Essendant
>
> -Original Message-
> From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of
> Skylar Thompson
> Sent: Friday, April 22, 2016 9:30 AM
> To: ADSM-L@VM.MARIST.EDU
> Subject: Re: [ADSM
9:30 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] SQL QUERY FOR AMOUNT OF ACTIVE VS INACTIVE DATA
You can also GRANT PROXY and then use -ASNODE from one of your own nodes, using
your node's password. I think the general node type has to match (i.e. any UNIX
can proxy to any UNIX, bu
9:11 AM
> To: ADSM-L@VM.MARIST.EDU
> Subject: Re: [ADSM-L] SQL QUERY FOR AMOUNT OF ACTIVE VS INACTIVE DATA
>
> Wish I could do that. This comes from three levels above me in management.
> Trying to buy more storage to sell to departments.
> Don't ask me, I have no clue what they
Thanks for reminding me about this, I had completely forgotten. At the
time, the customers wanted per-directory stats so it wasn't an option for
us.
On Fri, Apr 22, 2016 at 10:11:27AM -0400, Zoltan Forray wrote:
> Per this document, IBM's suggestion/recommendation is to perform EXPORT
> NODE FILE
@VM.MARIST.EDU
Subject: Re: [ADSM-L] SQL QUERY FOR AMOUNT OF ACTIVE VS INACTIVE DATA
Wish I could do that. This comes from three levels above me in management.
Trying to buy more storage to sell to departments.
Don't ask me, I have no clue what they are doing.
I'll look into the q backup on c
Per this document, IBM's suggestion/recommendation is to perform EXPORT
NODE FILED=BACKUPActive PREVIEW=YES
http://www-01.ibm.com/support/docview.wss?uid=swg21267260
On Fri, Apr 22, 2016 at 10:00 AM, Skylar Thompson
wrote:
> If you have access to the clients, you can use QUERY BACKUP and parse
ssage-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Skylar
Thompson
Sent: Friday, April 22, 2016 10:00 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] SQL QUERY FOR AMOUNT OF ACTIVE VS INACTIVE DATA
If you have access to the clients, you can use QUERY BACKUP and parse
If you have access to the clients, you can use QUERY BACKUP and parse the
A/I column.
Honestly, though, when we've gotten this query, I've managed to push this
back on the customers; it's not TSM's problem what's active or inactive,
it's the customers' applications that are actually responsible fo
Just got a request for the amount of active versus inactive data on our tsm
servers.
Is there a better way than traversing the backups table and summing?
That would be a mighty long query.
We have three servers, and approximately 300 clients about 200 tB total data.
Thanks for any suggestions.
[BS]"
À: ADSM-L@VM.MARIST.EDU
Envoyé: Mardi 20 Mai 2014 19:18:06
Objet: [ADSM-L] SQL Query for "replstate"
I need to run a query (such as SELECT * FROM WHERE =
'ENABLED') to list nodes and their "replstate" status But I don't find
"REPLSTAT
I need to run a query (such as SELECT * FROM WHERE =
'ENABLED') to list nodes and their "replstate" status But I don't find
"REPLSTATE" as a column in the NODES table.
And I don't see a column name that seems related.
Q REPLNODE * returns multiple rows for each node; but REPLNODE is not a
Eric
I'm guessing from your email that you've managed to change the packaged
SQL to work with v6 and it's only your bespoke customisations that are
posing a challenge.
For anyone else attempting a similar change this is a great resource for
'tweaking' the vanilla Operational Reporting to work wit
Subject: Re: SQL query in v6 server
Hi Eric,
the timestampdiff function will do what you need. This works -
select node_name, platform_name, date(lastacc_time) - from nodes -
where cast(timestampdiff(16, current_timestamp - lastacc_time) as
decimal(4,1))> 2
The first number in timestampdiff
ent: Wednesday, November 20, 2013 10:40 AM
To: ADSM-L@VM.MARIST.EDU
Subject: SQL query in v6 server
Hi TSM-ers!
We just migrated a second server to v6 and now I need to 'patch' TSM
Operational Reporter. Among others, the following SQL statement no
longer works:
select node_name, platfo
On Behalf Of Loon,
EJ van - SPLXM
Sent: Wednesday, November 20, 2013 10:40 AM
To: ADSM-L@VM.MARIST.EDU
Subject: SQL query in v6 server
Hi TSM-ers!
We just migrated a second server to v6 and now I need to 'patch' TSM
Operational Reporter. Among others, the following SQL statement no
ginal Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Loon,
EJ van - SPLXM
Sent: Wednesday, November 20, 2013 8:40 AM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] SQL query in v6 server
Hi TSM-ers!
We just migrated a second server to v6 and now I need to
an - SPLXM
Sent: Wednesday, November 20, 2013 8:40 AM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] SQL query in v6 server
Hi TSM-ers!
We just migrated a second server to v6 and now I need to 'patch' TSM
Operational Reporter. Among others, the following SQL statement no longer works:
select
Hi TSM-ers!
We just migrated a second server to v6 and now I need to 'patch' TSM
Operational Reporter. Among others, the following SQL statement no
longer works:
select node_name, platform_name, date(lastacc_time) from nodes where
cast((current_timestamp-lastacc_time)days as decimal) >=2 and c
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of
Lee, Gary
Sent: Thursday, November 07, 2013 8:15 AM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] sql query question
I want a list of all top level directories on a windows file system;
specifically, c:.
How can I get this from t
ginal Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Lee,
Gary
Sent: Thursday, November 07, 2013 9:15 AM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] sql query question
I want a list of all top level directories on a windows file system;
specifically, c:.
How can
Hi Gary,
>From a client perspective, I would simply use a query backup command: dsmc q
>ba c:\ -subdir=no
--
Best regards / Cordialement / مع تحياتي
Erwann SIMON
- Mail original -
De: "Gary Lee"
À: ADSM-L@VM.MARIST.EDU
Envoyé: Jeudi 7 Novembre 2013 15:14:57
Objet: [A
I want a list of all top level directories on a windows file system;
specifically, c:.
How can I get this from tsm?
The problem is I need to restore several directories, back to a machine with a
replaced hard disk.
However, I am totally blind, and unable to use the gui; so thought I would
cre
i
+Storage+Manager/page/Home
"ADSM: Dist Stor Manager" wrote on 2013-08-01
08:21:59:
> From: "Lee, Gary"
> To: ADSM-L@vm.marist.edu,
> Date: 2013-08-01 08:23
> Subject: Re: another sql query problem
> Sent by: "ADSM: Dist Stor Manager"
>
> Mr. R
Sent: Thursday, August 01, 2013 8:14 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] another sql query problem
Hi Gary,
What time of day does the script run?
What time of day did the backup start?
If you look at the dsmsched.log file, what was the time frame when most of
the files were backed
perworks/wikis/home/wiki/Tivoli
+Storage+Manager/page/Home
"ADSM: Dist Stor Manager" wrote on 2013-07-31
13:55:09:
> From: "Lee, Gary"
> To: ADSM-L@vm.marist.edu,
> Date: 2013-07-31 13:56
> Subject: another sql query problem
> Sent by: "ADSM: Dist Stor Mana
Forgot to mention tsm server 6.2.4 under RHEL 6.
If I run the following script with the command
Run listback node_name 20
I receive a list of 128 objects.
However, a check of the dsmsched.log file shows the following:
07/31/2013 07:53:26 Total number of objects inspected: 634,241
07/31/2013 07:53:26 Total number of objects assigned:
@VM.MARIST.EDU] On Behalf Of
Yuvaraja Shivarama
Sent: 20 03 2012 2:16 PM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] sql query from tsm end...please help me out.
Hi all,
can any one knows how to extract the occupancy report along with domain name
and node together
regards
Yuvaraj
@VM.MARIST.EDU
Date: 03/20/2012 07:17 AM
Subject:sql query from tsm end...please help me out.
Sent by:"ADSM: Dist Stor Manager"
Hi all,
can any one knows how to extract the occupancy report along with
domain name and node together
regar
Hi all,
can any one knows how to extract the occupancy report along with
domain name and node together
regards
Yuvaraj
AM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] Antwort: [ADSM-L] Sql query problem in tsm 6.2
Hi,
use following Syntax:
select ev.node_name, ev.status, no.email_address from events ev, -
nodes no where ev.node_name = no.node_name and -
ev.status != 'Completed' and -
ev.scheduled_start
#x27;2011-09-06 08:00:00' and ev.scheduled_start< '2011-09-07
07:00:00'
Dan Fiske
-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Lee,
Gary D.
Sent: Wednesday, September 07, 2011 9:02 AM
To: ADSM-L@VM.MARIST.EDU
Subject: [
: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of
Richard Sims
Sent: Wednesday, September 07, 2011 9:28 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] Sql query problem in tsm 6.2
Do select * from syscat.columns where tabname='NODES'
and see if the column name is still
7;
Thorsten
Von:"Lee, Gary D."
An: ADSM-L@VM.MARIST.EDU
Datum: 07.09.11 15:07
Betreff:[ADSM-L] Sql query problem in tsm 6.2
Gesendet von: "ADSM: Dist Stor Manager"
TSM folks,
tsm server 6.2.2 on redhat enterprise linux 6.0
I submit the following f
Do select * from syscat.columns where tabname='NODES'
and see if the column name is still NODE_NAME, or perhaps changed to NODENAME.
Beyond that: There were a bunch of APARs involving TSM tables, such as IC70346,
which may be impacting your attempted Select.
Unfortunately, TSM version 6 has be
TSM folks,
tsm server 6.2.2 on redhat enterprise linux 6.0
I submit the following file as a macro and recieve the errors below.
This query works in tsm 5.5
file c:\tsmscripts\pl3
-
select events.node_name, events.status, nodes.email_address from events, -
nodes where events.node_na
Zhou Tianxiang
Sent from HTC mobile!
- Reply message -
发件人: "Paul_Dudley"
日期: 周一, 7 月 18 日, 2011 年 12:00 下午
主题: [ADSM-L] SQL query - large files
收件人:
> -Original Message-
>
> On Jul 17, 2011, at 9:07 PM, Paul_Dudley wrote:
>
> > Is it possible to
> -Original Message-
>
> On Jul 17, 2011, at 9:07 PM, Paul_Dudley wrote:
>
> > Is it possible to interrogate the TSM database with an SQL query to display
> > the
> list of backed up files whose size is larger than - for example - 160 Mbs?
> >
> >
On Jul 17, 2011, at 9:07 PM, Paul_Dudley wrote:
> Is it possible to interrogate the TSM database with an SQL query to display
> the list of backed up files whose size is larger than - for example - 160 Mbs?
>
> I understand that this will be a query that will take a while to
Is it possible to interrogate the TSM database with an SQL query to display the
list of backed up files whose size is larger than - for example - 160 Mbs?
I understand that this will be a query that will take a while to run so I am
prepared to run it on the weekend. While the total number of
Does this do what you want?
tsm: ULTSM>q script q_stgsum f=l
Name Line Command
Number
-- --
Q_STGSUM 1 select stgpool_name, -
5 devclass, -
10maxscratch
18 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] Sql query help
There is a field in the stgpools table that shows how many tapes are used,
so I don't think you need a join.
select MAXSCRATCH, NUMSCRATCHUSED from stgpools
The way I monitor maxscratch is with this:
select STGPOOL_NAME,
.@bsu.edu
Sent by: ADSM-L@VM.MARIST.EDU
04/06/2010 03:10 PM
Please respond to
ADSM-L@VM.MARIST.EDU
To
ADSM-L
cc
Subject
[ADSM-L] Sql query help
Tsm server 5.5.4 running on suse 9 linux under zvm 5.3.
Trying to create a query which will give me the count of volumes in a
storage pool, and its
Tsm server 5.5.4 running on suse 9 linux under zvm 5.3.
Trying to create a query which will give me the count of volumes in a storage
pool, and its maxscratch setting on a single line.
Nice to watch for filling pools which need a larger maxscratch value.
Query follows:
---
select a
does anyone know of an SQL Query Client (like MS Query Editor) that works
without having to install MS office?
Thanks for All your replies! I was able to come up with SQL query to
display the nodes and their Management Classes
Best Regards!
Richard Sims wrote:
On Jan 28, 2010, at 11:16 AM, Timothy Hughes wrote:
Hi all,
I am trying to find all nodes that are associated with a particular
Lindsay Morris wrote:
Right, we did some magic on the dsmc client...
But I see this question here repeatedly: "how can I list all of my backup
files?"
And the answer is always "Don't do that, or tread carefully" like Richard
just said.
...
So why are people wanting to do this?
Hey, you lurkers w
Hello Timothy,
I am using next scripts:
define script F3_Node_Backup_Copy_Groups description=" Active backup copy
groups for node"
update script F3_Node_Backup_Copy_Groups \
"select b.node_name, a.domain_name, a.class_name as Management_Class,
a.destination as Destination_Pool, \
a.verexists as
From: ADSM: Dist Stor Manager [ads...@vm.marist.edu] On Behalf Of Timothy
Hughes [timothy.hug...@oit.state.nj.us]
Sent: Thursday, January 28, 2010 7:16 PM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] SQL Query find nodes associated with management class
Hi
iginal Message-
> From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of
> Lindsay Morris
> Sent: Thursday, January 28, 2010 11:34 AM
> To: ADSM-L@VM.MARIST.EDU
> Subject: Re: [ADSM-L] SQL Query find nodes associated with management
> class
>
> We deal
orris
Sent: Thursday, January 28, 2010 11:34 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] SQL Query find nodes associated with management
class
We deal with this problem by using the dsmc client, rather than the
dsmadmc client.
"dsmc query backup..." seems to be more efficient that &q
processing as light as possible.
>
> George Huebschman
>
> -Original Message-
> From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of
> Timothy Hughes
> Sent: Thursday, January 28, 2010 11:16 AM
> To: ADSM-L@VM.MARIST.EDU
> Subject: [ADSM-L] SQL Quer
as possible to keep the select processing as light as possible.
George Huebschman
-Original Message-
From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of
Timothy Hughes
Sent: Thursday, January 28, 2010 11:16 AM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] SQL Query find no
hives for the many responses.
Nodes are not assigned to management classes: individual file system objects
are, where such binding can vary by Include spec and TSM directory processing
rules. The SQL query to scan millions of files to determine this fully is
infeasible. The only realistic thing
Hi all,
I am trying to find all nodes that are associated with a particular
management class, does anyone have a SQL statement that will produce
this information?
Thanks
to format SQL query. No result is a
result as well.
Grigori
From: ADSM: Dist Stor Manager [ads...@vm.marist.edu] On Behalf Of Colwell,
William F. [bcolw...@draper.com]
Sent: Thursday, October 15, 2009 10:01 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L
y, October 15, 2009 8:49 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Formating SQL query
I am not very cool in SQL and I need help.
I have query like "select distict a,b from c group by a,b"
Response on this SQL query in TSM Server is:
A1 B1
A1 B2
A2 B3
A2 B4
A2 B5
I would like to h
...@bkme.com
Please consider the environment before printing this Email
-Original Message-
From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of
Michael Green
Sent: Thursday, October 15, 2009 3:58 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] Formating SQL query
A year ago
QL and I need help.
> I have query like "select distict a,b from c group by a,b"
> Response on this SQL query in TSM Server is:
> A1 B1
> A1 B2
> A2 B3
> A2 B4
> A2 B5
> I would like to have:
> A1 B1
> B2
> A2 B3
> B4
> B5
> I know exac
I am not very cool in SQL and I need help.
I have query like "select distict a,b from c group by a,b"
Response on this SQL query in TSM Server is:
A1 B1
A1 B2
A2 B3
A2 B4
A2 B5
I would like to have:
A1 B1
B2
A2 B3
B4
B5
I know exactly it is possible in Oracle SQL*P
environment before printing this Email
-Original Message-
From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of
Richard Sims
Sent: Sunday, May 10, 2009 1:35 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] Problem with SQL query in TSM 6.1
This is what you run into when you
This is what you run into when you are on "the bleeding edge" in going
with a very new version of software.
See IBM Technote 1380830.
Richard Sims
I have query to TSM database which is working fine with TSM 5.5, but gives an
error in TSM 6.1:
tsm: BKME>select volume_name,state,location,upd_date from drmedia where
volume_name like 'TSM%' and voltype = 'DBBackup' order by volume_name
ANR2944E The reference 'ORDER' is an unknown SQL scalar fu
excellence.
"ADSM: Dist Stor Manager" wrote on 01/27/2009
05:18:06 AM:
> [image removed]
>
> SQL query question
>
> Loon, EJ van - SPLXM
>
> to:
>
> ADSM-L
>
> 01/27/2009 05:18 AM
>
> Sent by:
>
> "ADSM: Dist Stor Manager"
>
> P
ADSM: Dist Stor Manager" wrote on 01/27/2009
05:18:06 AM:
> [image removed]
>
> SQL query question
>
> Loon, EJ van - SPLXM
>
> to:
>
> ADSM-L
>
> 01/27/2009 05:18 AM
>
> Sent by:
>
> "ADSM: Dist Stor Manager"
>
> Please respond to
Hi *SM-ers!
I'm trying to create an SQL query to list all filespaces with more than
500 Gb. stored in TSM, but only for nodes belonging to a certain
department. I want to use the contact field for this, but I must be
doing something wrong, because it still lists all nodes. Here's what
On May 16, 2008, at 10:02 AM, Choudarapu, Ramakrishna (GTS) wrote:
...
Am I right Richard?
Looks good.
Thanks for posting that - I had to run to a meeting.
Richard
lf Of
Loon, E.J. van - SPLXM
Sent: Friday, May 16, 2008 9:52 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] Speeding up my SQL query
Hi Richard!
Thank you very much for your reply!
Since I'm not much of an SQL wizzard, could you please help met with
rebuilding the query?
Kindest regar
-Eric van Loon wrote: -
>Hi *SM-ers!
>My TSM Operational Reporter creates a daily report for our Windows
>guys.
>Part of this report is a SQL query which returns all missed files.
>This
>is the query:
>
>select -
> actlog.nodename as "Node Name", -
lf Of
Richard Sims
Sent: vrijdag 16 mei 2008 15:08
To: ADSM-L@VM.MARIST.EDU
Subject: Re: Speeding up my SQL query
Eric -
One thing you can do is use the SQL clause IN rather than a succession
of OR conditions to improve the query performance of testing for
multiple values.
Richard
@VM.MARIST.EDU
Subject: Re: Speeding up my SQL query
Eric,
Did you try Q ACTLOG instead, using NODE=NODE_NAME, MSG=MSGNUM BEGINTIME
and ENDTIME parameters, which may be faster than the select, but the
resluts may not be as straight and detailed as your select...
Regards, Rama
-Original Message
PROTECTED] On Behalf Of
Loon, E.J. van - SPLXM
Sent: Friday, May 16, 2008 9:01 AM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] Speeding up my SQL query
Hi *SM-ers!
My TSM Operational Reporter creates a daily report for our Windows guys.
Part of this report is a SQL query which returns all missed
Eric -
One thing you can do is use the SQL clause IN rather than a succession
of OR conditions to improve the query performance of testing for
multiple values.
Richard Sims
1 - 100 of 238 matches
Mail list logo