Thanks for this. Interesting way of attacking it :)
Matt.
-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Johnson, Milton
Sent: Tuesday, August 31, 2004 10:19 PM
To: [EMAIL PROTECTED]
Subject: Re: SQL Select statement help
You can create a script
-- ---
COPYPOOL >=50
TAPEPOOL >=50
H. Milton Johnson
Voice: (210) 677-6728
-Original Message-----
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Beha
EMAIL PROTECTED] Behalf Of
Prather, Wanda
Sent: Tuesday, August 31, 2004 1:52 PM
To: [EMAIL PROTECTED]
Subject: Re: SQL Select statement help
I hope I'm wrong, but I don't think it's possible to do that.
-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL
[mailto:[EMAIL PROTECTED] Behalf Of
Prather, Wanda
Sent: Tuesday, August 31, 2004 1:52 PM
To: [EMAIL PROTECTED]
Subject: Re: SQL Select statement help
I hope I'm wrong, but I don't think it's possible to do that.
-Original Message-
From: ADSM: Dist Stor Manager [mailto:
I hope I'm wrong, but I don't think it's possible to do that.
-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Warren, Matthew (Retail)
Sent: Tuesday, August 31, 2004 10:51 AM
To: [EMAIL PROTECTED]
Subject: SQL Select statement help
Hallo ([I]T/AD)SM'ers
Can any wise and clever SQL types help with the following?;
I am trying to get TSM to show the number of tapes that went pending by
date.
I can get this;
ANS8000I Server command: 'select cast(pending_date as char(10)),count(*)
from volumes where status='PENDING' group by p
Hi Calvin,
Yes, it doesn't surprise me that activity log rows numbering in the
millions will take several minutes to process (though 20 minutes does seem
like a long time, but that can also depend on other server activity).
Without knowing more about your intentions and time constraints, I'm not
c
nal Message-
From: Andrew Raibeck [mailto:[EMAIL PROTECTED]
Sent: Sunday, July 11, 2004 8:55 PM
To: [EMAIL PROTECTED]
Subject: Re: SQL Select Statement Question Please HELP!
If you are getting actual results (and better yet, correct results) then
there is nothing "wrong" per se wit
If you are getting actual results (and better yet, correct results) then
there is nothing "wrong" per se with your syntax.
The tables presented by the SELECT statement do not really exist as such
in the TSM server database. Rather, these tables are constructed "on the
fly" during SELECT processing
Hello Everyone,
I have a quick question in reference to using select statements to query the activity
log. For some reason the regular select statement would take forever to run a simple
query? How does TSM query the activity log? I'm still quite a novice at selects
statements so maybe I'm issu
node_name=upper('$1') order
by node_name,stgpool_name,volume_name
-Original Message-
From: John Stephens [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 22, 2004 12:30 AM
To: [EMAIL PROTECTED]
Subject: SQL Select statement
I have a select statement th
I have a select statement that will display part of what I want but I cant
seem to make it completely work.
Here is the statement and the output,
select node_name as Node,count(distinct volume_name) as "Tape Pool
Media",count(distinct volume_name) as "Copy Pool Media" from volumeusage
where stgpoo
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of
Ilja G. Coolen
> As a happy 3590 user i am wondering why you would want to convert
> from 3590 to a different type.
Me too. The 3590 technology is pretty much the Cadillac of sequential
storage. What is prompting your move?
> I
message header before closing the quote.
Regards,
Andy
Andy Raibeck
IBM/Tivoli
Tivoli Storage Manager Client Development
e-mail: [EMAIL PROTECTED]
"The only dumb question is the one that goes unasked."
Formatting SQL select statement output
How do I change the output of the c
Hope this helps.
Bart
Dave wrote:
---
Formatting SQL select statement output
How do I change the output of the column width in a select statement?
Below is a select statement I am currently working on and would like to
expand the mess
Formatting SQL select statement output
How do I change the output of the column width in a select statement?
Below is a select statement I am currently working on and would like to
expand the message column to something wider than the default 18 chr.
Dave T
ADSM Version 3
Release 1
16 matches
Mail list logo