odename1 1123123131223
>
> 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: vrijdag 12 maart 2021 16:49
> To
ent: Friday, March 12, 2021 11:28 AM
To: ADSM-L@VM.MARIST.EDU
Subject: [EXTERNAL] [ADSM-L] SQL statement for multiple classes
Hi everybody,
I'm trying to figure out how to create a SQL query to retrieve the amount of
files, per management class, per node in just one query. T
U
Subject: Re: SQL statement for multiple classes
Hi Eric,
You can part of the way there with GROUP BY:
SELECT node_name,class_name,COUNT(*) FROM archives GROUP BY node_name,class_name
This will give you one row per (node_name,class_name) tuple. In order to get
row values as columns, though, you n
L@VM.MARIST.EDU
Subject: [EXTERNAL] [ADSM-L] SQL statement for multiple classes
Hi everybody,
I'm trying to figure out how to create a SQL query to retrieve the amount
of files, per management class, per node in just one query. The ideal
output would be:
Nodename Class1
Hi Eric,
You can part of the way there with GROUP BY:
SELECT node_name,class_name,COUNT(*) FROM archives GROUP BY node_name,class_name
This will give you one row per (node_name,class_name) tuple. In order to
get row values as columns, though, you need to do a pivot (aka crosstab),
which I'm not
Hi everybody,
I'm trying to figure out how to create a SQL query to retrieve the amount of
files, per management class, per node in just one query. The ideal output would
be:
Nodename Class1 Class2 Class3
Mynode1 1234
24 hours)
-Rick Adamson
-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Lepre,
James
Sent: Monday, January 22, 2018 9:43 AM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] SQL STATEMENT
* This email originated outside of the organization. Use caut
: Monday to Friday, 7:00 to 16:00 Eastern
Follow me on: Twitter, developerWorks, LinkedIn
-Original Message-
From: Lepre, James [mailto:james.le...@solixinc.com]
Sent: Monday, January 22, 2018 10:45 AM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] SQL STATEMENT
Hey Everyone -
I am looking
Hey Everyone -
I am looking for a sql select statement that show completions, missed, and
failures of daily schedules. This output should be similar to the q event
command
Thank you in advance for the assistance
James Lepre
should get
> the job done.
>
> On Tue, Apr 12, 2016 at 01:39:03PM +, Robert Talda wrote:
>> EJ:
>>
>> Wish I could be as helpful this time. Sadly, I???ve not found a way to
>> generate this output with a single SQL statement - the TSM SQL engine
>>
2016 at 01:39:03PM +, Robert Talda wrote:
> EJ:
>
> Wish I could be as helpful this time. Sadly, I???ve not found a way to
> generate this output with a single SQL statement - the TSM SQL engine
> doesn???t seem to support the concept of OUTER JOIN. I???ve had to r
EJ:
Wish I could be as helpful this time. Sadly, I’ve not found a way to
generate this output with a single SQL statement - the TSM SQL engine doesn’t
seem to support the concept of OUTER JOIN. I’ve had to resort to doing 2
queries - one of the occupancy table and one of the filespaces
n for your help!
Kind regards,
Eric van Loon
Air France/KLM Storage Engineering
-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Robert
Talda
Sent: maandag 11 april 2016 19:34
To: ADSM-L@VM.MARIST.EDU
Subject: Re: SQL statement
EJ:
Are you sur
Apr 11, 2016, at 10:07 AM, Loon, EJ van (ITOPT3) - KLM
> wrote:
>
> Hi guys!
> I'm trying to create a SQL statement which should list all filespaces, along
> with their occupancy, with a backup date longer than 2 days ago, but only for
> nodes with an last access date of
Hi guys!
I'm trying to create a SQL statement which should list all filespaces, along
with their occupancy, with a backup date longer than 2 days ago, but only for
nodes with an last access date of today or yesterday. If the node hasn't
contacted the server for two days or more it
Unsubscribe.
-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Erwann
SIMON
Sent: Saturday, January 30, 2016 4:03 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: SQL statement
Hi Eric,
You're absolutely right, the SQL resultas are just to be use
rwann SIMON
- Mail original -
De: "EJ van Loon (ITOPT3) - KLM"
À: ADSM-L@VM.MARIST.EDU
Envoyé: Vendredi 29 Janvier 2016 16:09:22
Objet: Re: [ADSM-L] SQL statement
Hi Erwann!
As a matter of fact this one requires a little more care. Null can be the
result of a filespace
D ((o.type<>'Arch' AND f.backup_end IS NULL) -
OR days(f.backup_end)<(days(current_date)-30)) -
ORDER BY o.physical_mb DESC
On Fri, Jan 29, 2016 at 03:43:24PM +, Rhodes, Richard L. wrote:
> If you get to a definitive sql statement, would love to see it!
>
If you get to a definitive sql statement, would love to see it!
Rick
-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Skylar
Thompson
Sent: Friday, January 29, 2016 10:14 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: SQL statement
You could get a
> Erwann SIMON
> Sent: donderdag 28 januari 2016 16:46
> To: ADSM-L@VM.MARIST.EDU
> Subject: Re: SQL statement
>
> Hi Eric,
>
> You maybe should add a condition if backup_end is null
>
> --
> Best regards / Cordialement /
> Erwann SIMON
>
&g
[mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Erwann
SIMON
Sent: donderdag 28 januari 2016 16:46
To: ADSM-L@VM.MARIST.EDU
Subject: Re: SQL statement
Hi Eric,
You maybe should add a condition if backup_end is null
--
Best regards / Cordialement / مع تحياتي
Erwann SIMON
- Mail original -
D
You could do that but the query does not fail for filespaces with a
BACKUP_END of null it just lists a blank value for DAYS_SINCE_BACKUP
On 1/28/2016 10:46 AM, Erwann SIMON wrote:
Hi Eric,
You maybe should add a condition if backup_end is null
--
William Sefranek
University of Buffalo
Enterp
Hi,I'm looking for some help on SQL statement as well.
Would you have a statement that lists just the amount of active data a node has
stored - not the active and inactive...
Thank youMichael
On Thursday, January 28, 2016 10:08 AM, William Sefranek
wrote:
Eric,
One other lin
DSM-L@VM.MARIST.EDU
Subject: Re: SQL statement
Hi Eric,
You maybe should add a condition if backup_end is null
--
Best regards / Cordialement / مع تحياتي
Erwann SIMON
- Mail original -
De: "EJ van Loon (ITOPT3) - KLM"
À: ADSM-L@VM.MARIST.EDU
Envoyé: Jeudi 28 Janvier 2016 16:
hysical_mb/1024) as int) as "GB Stored" -
> >> FROM -
> >> filespaces f, -
> >> occupancy o -
> >> WHERE -
> >> o.node_name=f.node_name -
> >> AND o.filespace_name=f.filespace_name -
> >> AND days(f.backup_end)<(da
egards / Cordialement /
> Erwann SIMON
>
> - Mail original -
> De: "EJ van Loon (ITOPT3) - KLM"
> ?: ADSM-L@VM.MARIST.EDU
> Envoy?: Jeudi 28 Janvier 2016 16:20:57
> Objet: Re: [ADSM-L] SQL statement
>
> Hi Skylar!
> This is exactly what I
aces f, -
>> occupancy o -
>> WHERE -
>> o.node_name=f.node_name -
>> AND o.filespace_name=f.filespace_name -
>> AND days(f.backup_end)<(days(current_date)-30) -
>> ORDER BY o.physical_mb DESC
>>
>> On Thu, Jan 28, 2016 at 02:43:54PM +,
Hi Eric,
You maybe should add a condition if backup_end is null
--
Best regards / Cordialement / مع تحياتي
Erwann SIMON
- Mail original -
De: "EJ van Loon (ITOPT3) - KLM"
À: ADSM-L@VM.MARIST.EDU
Envoyé: Jeudi 28 Janvier 2016 16:20:57
Objet: Re: [ADSM-L] SQL statement
Hi Sk
@VM.MARIST.EDU
Subject: Re: SQL statement
Eric,
One other line you can add to the select section is:
DAYS(current_timestamp)-DAYS(f.BACKUP_END) AS DAYS_SINCE_BACKUP -
Which will list the number of days since this filespace completed a backup. I
use that in our query to list old filespaces due for cleanup
To: ADSM-L@VM.MARIST.EDU
Subject: Re: SQL statement
Hi EJ,
I think this will do the trick:
SELECT -
f.node_name, -
f.filespace_name, -
f.backup_end, -
CAST(ROUND(o.physical_mb/1024) as int) as "GB Stored" - FROM -
filespaces f, -
occupancy o -
WHERE -
o.node_name=f
-
AND o.filespace_name=f.filespace_name -
AND days(f.backup_end)<(days(current_date)-30) -
ORDER BY o.physical_mb DESC
On Thu, Jan 28, 2016 at 02:43:54PM +, Loon, EJ van (ITOPT3) - KLM wrote:
Hi guys!
I'm trying to join the filespaces and occupancy tables in one SQL statement,
but I get
e -
AND days(f.backup_end)<(days(current_date)-30) -
ORDER BY o.physical_mb DESC
On Thu, Jan 28, 2016 at 02:43:54PM +, Loon, EJ van (ITOPT3) - KLM wrote:
> Hi guys!
> I'm trying to join the filespaces and occupancy tables in one SQL statement,
> but I get stuck on the poin
Hi guys!
I'm trying to join the filespaces and occupancy tables in one SQL statement,
but I get stuck on the point where I want to calculate with the amount of
days...
I would like to create a list of filespaces (node_name,
filespace_name,backup_end) which are not backed up for more th
@VM.MARIST.EDU
Subject: Re: SQL statement not working
you’re missing the from clause of your sql statement.
> Op 1 jul. 2015, om 09:49 heeft Loon, EJ van (ITOPT3) - KLM
> het volgende geschreven:
>
> Hi guys!
> I'm trying to select all ANE4987E messages for all nodes with the tex
you’re missing the from clause of your sql statement.
> Op 1 jul. 2015, om 09:49 heeft Loon, EJ van (ITOPT3) - KLM
> het volgende geschreven:
>
> Hi guys!
> I'm trying to select all ANE4987E messages for all nodes with the text
> 'Component Team Windows' in t
Hi guys!
I'm trying to select all ANE4987E messages for all nodes with the text
'Component Team Windows' in the contact field. For some reason I cannot get the
SQL statement to work. What am I doing wrong?
select actlog.date_time, actlog.nodename, actlog.message, nodes.node_name,
U] On Behalf Of Loon,
EJ van (SPLXM) - KLM
Sent: Monday, March 17, 2014 5:35 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] SQL statement to list fs not backed up sorted on size
Hi Skylar!
Thank you very much for your help!
The end result looks like this, just so it's available for others in
: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of
Skylar Thompson
Sent: donderdag 13 maart 2014 17:37
To: ADSM-L@VM.MARIST.EDU
Subject: Re: SQL statement
You'll want to do a join across both tables on the node name. Something
like this:
SELECT f.node_name,f.filespace_name,o.ph
LM wrote:
Dear TSM-ers,
I'm trying to generate a SQL statement to create a list of filespaces
which are not backed up for more than 30 days, sorted on their occupancy
size. This is what I've got so far:
select node_name, filespace_name, physical_mb from occupancy where
filespa
ent_date)-30)) -
ORDER BY o.physical_mb DESC
On Thu, Mar 13, 2014 at 05:16:37PM +0100, Loon, EJ van (SPLXM) - KLM wrote:
> Dear TSM-ers,
>
> I'm trying to generate a SQL statement to create a list of filespaces
> which are not backed up for more than 30 days, sorted on the
Can't you combine a node name and a filespace name to a unique combination?
Cheers,
Rick
On Thu, Mar 13, 2014 at 5:16 PM, Loon, EJ van (SPLXM) - KLM <
eric-van.l...@klm.com> wrote:
> Dear TSM-ers,
>
> I'm trying to generate a SQL statement to create a list of filespac
Dear TSM-ers,
I'm trying to generate a SQL statement to create a list of filespaces
which are not backed up for more than 30 days, sorted on their occupancy
size. This is what I've got so far:
select node_name, filespace_name, physical_mb from occupancy where
filespace_name
Hi Jeff!
Thank you VERY much for your reply! You did put me on the right track.
It resulted in the most complex SQL statement I ever created:
select a.node_name as "Nodename",count(*) as -
"Amount of backup files older than 30 days" from backups a,nodes b -
where ((days(
.
- Reply message -
From: "Loon, EJ van - SPLXM"
To:
Subject: [ADSM-L] SQL statement
Date: Thu, Dec 19, 2013 06:21
Hi guys!
I'm trying to make an SQL statement which uses the Nodes table and the
Backups table. It should do a count (*) from backups for files older
than 30
Hi guys!
I'm trying to make an SQL statement which uses the Nodes table and the
Backups table. It should do a count (*) from backups for files older
than 30 days but only when the Contact field starts with 'Airpas". Here
is what I got so far:
select nodes.node_name as "N
works. Looks like a bug to me...
Kind regards,
Eric van Loon
AF/KLM Storage Engineering
-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of
Ronald Le Large
Sent: donderdag 5 december 2013 14:17
To: ADSM-L@VM.MARIST.EDU
Subject: Re: SQL statement gener
onald Le Large
Sent: donderdag 5 december 2013 14:17
To: ADSM-L@VM.MARIST.EDU
Subject: Re: SQL statement generates an ANRD
Eric,
I can execute the sql without receiving the ANR
I run it on V 6.3.3.0
Kind regards,
Ronald Le Large
Information technology officer Storage Management
Behalf Of Loon,
EJ van - SPLXM
Sent: Thursday, December 05, 2013 2:07 PM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] SQL statement generates an ANRD
Hi TSM-ers!
I'm trying to build an SQL statement to measure expiration performance, but I'm
experiencing an ANRD error. I stripped
Hi TSM-ers!
I'm trying to build an SQL statement to measure expiration performance,
but I'm experiencing an ANRD error. I stripped it down to the
following statement:
select cast(timestampdiff(2,end_time-start_time) as decimal(4,0)) from
summary where activity='EXPIRATION&
@VM.MARIST.EDU] On Behalf Of
Richard Rhodes
Sent: 17 09 2013 2:24 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] TSM version 6.3 SQL statement is failing
I believe that the problem is in the where clause where you cast to "days". I
don't believe you can do that in db2. To fix my s
7/2013 02:42 AM
Subject: TSM version 6.3 SQL statement is failing
Sent by:"ADSM: Dist Stor Manager"
I am not very cool in DB2 SQL and I found next SQL statement failing in
TSM version 6 in spite of fact it was working in TSM version 5 for years:
select node_name , f
I am not very cool in DB2 SQL and I found next SQL statement failing in TSM
version 6 in spite of fact it was working in TSM version 5 for years:
select node_name , filespace_id , filespace_name , filespace_type ,
backup_start , backup_end ,
cast ( MINUTE ( backup_end - backup_start) as
sday, March 07, 2012 1:40 PM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] TSM 6.2 SQL statement
We run this and other SQL statements that return dates in the form of days.
This SQL query works on 5.4, but does not work on 6.2. I am hoping one of the
more SQL savvy admins can quickly help me w
t_ti
This is the sql statement I tried:
select SUBSTR(CAST(VOLUME_NAME AS char(10)),1,10) as VOLUME_NAME, \
SUBSTR(CAST(stgpool_name AS char(18)),1,18) as STG, PCT_UTILIZED, \
EST_CAPACITY_MB, \
TIMESTAMPDIFF(16,CHAR(current_timestamp-date(last_write_date))) as xdays, \
SUBSTR(CAST(status AS char(10)
r
by last_write_date
regards,
Ankur Patel
> -Original Message-
> From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of
> Huebner,Andy,FORT WORTH,IT
> Sent: Thursday, 8 March 2012 8:40 AM
> To: ADSM-L@VM.MARIST.EDU
> Subject: [ADSM-L] TSM 6.2 SQL statement
>
We run this and other SQL statements that return dates in the form of days.
This SQL query works on 5.4, but does not work on 6.2. I am hoping one of the
more SQL savvy admins can quickly help me with this so I can fix the rest of
the queries we use.
The lines that don't work and I do not kno
-Ashish Sharma wrote: -
>Could anyone provide me a sql statement which can check if any copy
>storage pool volume is mounted in tape drive at the moment? I need
>this to configure script for my DRP.
select volume_name from drives where volune_name in
(select volume_name from
Ooh, cool! Thanks!
-Original Message-
From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of
Cowen, Richard
Sent: Friday, June 04, 2010 11:31 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] SQL statement
Connecting directly to DB2:
Database Connection Information
tgpools where stgpool_name like
'%\_%'
ANR2034E SELECT: No match found using this criteria.
ANS8001I Return code 11.
-Original Message-
From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of
Richard Sims
Sent: Friday, June 04, 2010 11:02 AM
To: ADSM-L@VM.MARIST.EDU
rist.edu] On Behalf Of
Richard Sims
Sent: Friday, June 04, 2010 11:02 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] SQL statement
On Jun 4, 2010, at 10:41 AM, Prather, Wanda wrote:
> Ow.
> Richard, do you know if it works this way still in V6?
Hi, Wanda -
We remain a v5 shop, pending a l
Hello,
Could anyone provide me a sql statement which can check if any copy storage
pool volume is mounted in tape drive at the moment? I need this to configure
script for my DRP.
Thanks in advance.
--
Best Regards
Ashish Sharma
ST Microelectronics Ltd.
919717003853
On Jun 4, 2010, at 10:41 AM, Prather, Wanda wrote:
> Ow.
> Richard, do you know if it works this way still in V6?
Hi, Wanda -
We remain a v5 shop, pending a lot of infrastructure decisions to be made by a
new VP, so I haven't that experience. I would expect DB2 to be much more
conformant to
Ow.
Richard, do you know if it works this way still in V6?
-Original Message-
From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of
Richard Sims
Sent: Friday, June 04, 2010 10:36 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] SQL statement
I worked with Eric on
VERY much!
Kind regards,
Eric van Loon
KLM Royal Dutch Airlines
-Original Message-
From: Richard Sims [mailto:r...@bu.edu]
Sent: vrijdag 4 juni 2010 16:07
To: Loon, EJ van - SPLXM
Subject: Re: SQL statement
On Jun 4, 2010, at 9:23 AM, Loon, EJ van - SPLXM wrote:
> Hi Richard!
> T
I worked with Eric on this. In case anyone else runs into similar...
File system directory and file names may well contain underscore (_)
characters, which is fine. What may not be realized, however, is that in a
Select LIKE, an underscore is a wildcard for any single character.
An example of
Hi TSM-ers!
I'm trying to create a SQL query to check whether all Oracle files
(Oracle databases are backed up by the TDP client) are excluded from the
standard BA client backup.
Our database admins recommends the follow exclude statements to be added
to the BA client:
/mount/data*/ora_*/log
/moun
- Original Message -
From: "Loon, E.J. van - SPLXM" <[EMAIL PROTECTED]>
To:
Sent: Wednesday, November 23, 2005 10:44 AM
Subject: SQL statement
Hi *SM-ers!
My management would like to know how much they can save by changing our
retention periods.
Currently, we store mos
On Nov 23, 2005, at 4:44 AM, Loon, E.J. van - SPLXM wrote:
Can anybody help me with creating a SQL statement which tells me
how much inactive backup data is stored on the TSM server for a
specific node?
Eric - See "Inactive files, number and bytes" in the TSM Wiki or ADSM
g to create a SQL statement to
> retrieve this information. It seems that the backups table does
> contain information about a backup being active or inactive, but it
> does not contain the file size. Can anybody help me with creating a
> SQL statement which tells me how much inactive backu
Hi *SM-ers!
My management would like to know how much they can save by changing our
retention periods.
Currently, we store most of our backups for 14 days and I will have to find out
how much we save by changing this to 7 days.
I'm trying to create a SQL statement to retrieve this inform
Joni,
Try
order by "date"
Leigh
-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Joni Moyer
Sent: 15 September 2005 14:53
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] SQL statement
Hi Everyone!
Does anyone know what I am doing wrong
ld do the trick.
HTH
Thomas Rupp
-Ursprüngliche Nachricht-
Von: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Im Auftrag von Joni Moyer
Gesendet: Donnerstag, 15. September 2005 15:53
An: ADSM-L@VM.MARIST.EDU
Betreff: [ADSM-L] SQL statement
Hi Everyone!
Does anyone know what I am doing wro
Hi Everyone!
Does anyone know what I am doing wrong with this sql statement? I am
trying to get the file info. but it all comes down to the date. I just
want to report on the date that the data was archived before 6/3/2005, but
I can't figure out what I am doing wrong. Any suggestions? T
Andy,
Thank you very much for your help, the results are exactly what I was
looking for.
Andrew Raibeck <[EMAIL PROTECTED]>
Sent by: "ADSM: Dist Stor Manager"
02/28/2005 04:06 PM
Please respond to
"ADSM: Dist Stor Manager"
To
ADSM-L@VM.MARIST.EDU
cc
Subject
t node_name from events where -
(substr(cast(scheduled_start as char(26)),1,19) between '2005-01-31
15:39:26' and -
substr(cast(current_timestamp as char(26)),1,19) and -
LENGTH(domain_name) IS NOT NULL and -
(status='Failed' OR status='Missed')))
Any ideas on why the 2nd/3rd sql statement does not return anything?
thanks
JR
name from events where -
> (substr(cast(scheduled_start as char(26)),1,19) between '2005-01-31
> 15:39:26' and -
> substr(cast(current_timestamp as char(26)),1,19) and -
> LENGTH(domain_name) IS NOT NULL and -
> (status='Failed' OR status='Missed')))
>
> Any ideas on why the 2nd/3rd sql statement does not return anything?
>
>
> thanks
> JR
substr(cast(current_timestamp as char(26)),1,19) and -
LENGTH(domain_name) IS NOT NULL and -
(status='Failed' OR status='Missed')))
Any ideas on why the 2nd/3rd sql statement does not return anything?
thanks
JR
'MYORACLENODE'" the query takes about 5 seconds
to
finish.
So, the database is indeed indexed (like Wanda pointed out, thanks
Wanda!)
and statements like like or in causes TSM not to use these indexes.
I guess it's best to issue one SQL statement per node.
Thank you all for helpin
e node_name='MYORACLENODE'" the query takes about 5 seconds to
finish.
So, the database is indeed indexed (like Wanda pointed out, thanks Wanda!)
and statements like like or in causes TSM not to use these indexes.
I guess it's best to issue one SQL statement per node.
Thank you
" -(me)
-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf
Of
Richard Sims
Sent: Tuesday, June 29, 2004 8:03 AM
To: [EMAIL PROTECTED]
Subject: Re: Speeding up my SQL statement
I thought about that, but would that help? If TSM still has to scan
eve
ehalf Of
Richard Sims
Sent: Tuesday, June 29, 2004 8:03 AM
To: [EMAIL PROTECTED]
Subject: Re: Speeding up my SQL statement
>I thought about that, but would that help? If TSM still has to scan every
>object for a match, it wouldn't help much... That's the problem, I don't
know
y, June 29, 2004 14:03
To: [EMAIL PROTECTED]
Subject: Re: Speeding up my SQL statement
>I thought about that, but would that help? If TSM still has to scan every
>object for a match, it wouldn't help much... That's the problem, I don't
know
>how SQL works...
Eric - Your pe
>I thought about that, but would that help? If TSM still has to scan every
>object for a match, it wouldn't help much... That's the problem, I don't know
>how SQL works...
Eric - Your perception is correct: if you scan a table, it will traverse the
whole thing. Whereas the Backups table is
ene,VEVEY,GLOBE Center CSC
[mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 29, 2004 13:21
To: [EMAIL PROTECTED]
Subject: Re: Speeding up my SQL statement
hi Eric, you could add
node_name like '%ORC' to the where clause...
best regards,
René LAMBELET
NESTEC
is privileged and
confidential.
-Original Message-
From: Loon, E.J. van - SPLXM [mailto:[EMAIL PROTECTED]
Sent: Tuesday,29. June 2004 12:52
To: [EMAIL PROTECTED]
Subject: Speeding up my SQL statement
Hi *SM-ers!
I'm using the following SQL statement to retrieve obsolete Ora
Hi *SM-ers!
I'm using the following SQL statement to retrieve obsolete Oracle backup
files:
select node_name, filespace_name, ll_name, date(backup_date) from backups
where ((days(current_date) - days(backup_date) >= 100)) and hl_name='//'
This returns all Oracle backup files,
d enough" is the enemy of excellence.
Eddie Jones <[EMAIL PROTECTED]>
Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
02/23/2004 08:15
Please respond to
"ADSM: Dist Stor Manager"
To
[EMAIL PROTECTED]
cc
Subject
sql statement that shows the active file
I am trying to write a sql statement that shows the active files for a
client. I can not find the field in the list of tables to use. Can anyone
help? Thank you in advance.
Eddie Jones
770-953-1959 ext.2824
"The greatest lesson in life is to know that even fools are right
sometimes.&q
: [EMAIL PROTECTED]
Subject: Re: SQL statement
Hi Eric,
There is no such table that gives you detailed information on which files
were restored. The SUMMARY table will give you basic statistics about
restores (SELECT * FROM SUMMARY WHERE ACTIVITY='RESTORE') but that's about
it.
Regar
van - SPLXM" <[EMAIL PROTECTED]>
Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
12/31/2003 05:33
Please respond to "ADSM: Dist Stor Manager"
To: [EMAIL PROTECTED]
cc:
Subject: SQL statement
Hi *SM-ers!
I'm look
cc
Dist Stor
Manager" Subject
<[EMAIL PROTECTED] Re: SQL statement
.EDU>
12/31/2003 08:11
AM
Please respond to
&quo
'>Do you really think storing this information will have such a large impact
>on the database? Storing restore information shouldn't use more database
>space than storing backup information?
Yes...because restorals can be performed over and over again on the same data,
and because of the nature of
KLM Royal Dutch Airlines
-Original Message-
From: Richard Sims [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 31, 2003 14:27
To: [EMAIL PROTECTED]
Subject: Re: SQL statement
>I'm looking for an SQL statement which returns all restores (nodes and
>filenames) done by my cli
>I'm looking for an SQL statement which returns all restores (nodes and
>filenames) done by my clients.
>I'm not much of an SQL wizard, so maybe someone is willing to help me or
>give me a hint?
Eric - I don't believe that such capability exists. Certainly, storing
om: Kurt Beyers [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 31, 2003 13:54
To: [EMAIL PROTECTED]
Subject: Re: SQL statement
Eric,
'select node_name, filespace_name, filespec from restores'
should give the wanted information.
best regards,
Kurt
>- Oorspronkelijk bericht
Aan
: [EMAIL PROTECTED]
>Onderwerp
: SQL statement
>
>Hi *SM-ers!
>I'm looking for an SQL statement which returns all restores (nodes and
>filenames) done by my clients.
>I'm not much of an SQL wizard, so maybe someone is willing to help me or
>give me a hint?
>Thank
Hi *SM-ers!
I'm looking for an SQL statement which returns all restores (nodes and
filenames) done by my clients.
I'm not much of an SQL wizard, so maybe someone is willing to help me or
give me a hint?
Thank you very much in advance
Kindest regards,
Eric van Loon
KLM Royal Dutc
respond to "ADSM: Dist Stor Manager"
To: [EMAIL PROTECTED]
cc:
Subject:Complete a SQL statement
I have a domain admin who'd like to find obsolete filespaces. This is his
SQL script:
select
filespaces.node_name,filespaces.filespace_name,filespaces
To: [EMAIL PROTECTED]
cc:
Subject:Complete a SQL statement
I have a domain admin who'd like to find obsolete filespaces. This is his
SQL script:
select
filespaces.node_name,filespaces.filespace_name,filespaces.backup_end
from -
filespaces where (($1 < -
_name in (select nodes.node_name
from nodes where domain_name=upper('$2'))
And this is the result:
tsm: TSM>run sincelast_fs 30 csm
ANR2909E The SQL statement is incomplete; additional tokens are required.
ANR1463E RUN: Command script SINCELAST_FS completed in error.
ANS8001I Return code 4.
What is missing??
1 - 100 of 117 matches
Mail list logo