ion. At all.
-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of
Prather, Wanda
Sent: Thursday, April 18, 2013 12:25 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] SELECT statements and column widths
Well that is odd -
I don't know why 2n+1
/sapmnt
-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Neil
Schofield
Sent: Wednesday, April 17, 2013 6:25 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] SELECT statements and column widths
Wanda
> You can also do:
> select substr(files
Wanda
> You can also do:
> select substr(filespace_name,1,20) from filespaces
>
> and get only 20 chars back.
Well that's interesting because it makes the problem worse! Using either
CAST or SUBSTR truncate my data to N characters, but CAST gives me a
column width of (N+1) for NODE_NAME and (2N+
-L] SELECT statements and column widths
Allen
Thanks for the suggestion. The problem I've got is that the reports are the
sort of ad-hoc SQL scripts that are run by administrators and operators from
the admin client. While using '-comma' does reduce the column width, it is not
-Neil Schofield wrote: -
>The fact that only the FILESPACE_NAME column is twice as wide as it
>should be makes me wonder if it's a bug?
It probably has something to do with the possible occurrence of
Unicode characters outside the ASCII character set in filespace
names.
Thomas Denier
Tho
t that only the FILESPACE_NAME column is twice as wide as it should
be makes me wonder if it's a bug?
Regards
Neil
From:
"Allen S. Rout"
To:
ADSM: Dist Stor Manager
Cc:
Neil Schofield
Date:
17/04/2013 14:59
Subject:
Re: [ADSM-L] SELECT statements and column widths
On 04/16/2013
On 04/16/2013 04:25 PM, Neil Schofield wrote:
> I'm in the throes of an upgrade from TSM Server 5.5 to 6.3 and have had a
> bit of a problem re-writing some of our custom SQL scripts. I was wondering
> if anyone can point out what I'm doing wrong.
>
I don't know from "do wrong"; but the way I appr
some of our custom SQL scripts. I was wondering
> if anyone can point out what I'm doing wrong.
>
> I understand that to get the select statements to return a table format
> instead of a list format I need to use the cast function to restrict the
> column width - this article expla
I'm in the throes of an upgrade from TSM Server 5.5 to 6.3 and have had a
bit of a problem re-writing some of our custom SQL scripts. I was wondering
if anyone can point out what I'm doing wrong.
I understand that to get the select statements to return a table format
instead of a lis
-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
LeBlanc, Patricia
Sent: Thursday, September 28, 2006 9:43 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] Select statements
But it wont give you the schedule time.
-Original Message-
From: ADSM
'Completed') -
or (status = 'Pending') or (status = 'Failed') or (status = 'Missed')) -
order by scheduled_start,status,result
i find this one useful :-)
- Original Message -
From: "LeBlanc, Patricia" <[EMAIL PROTECTED]>
To:
Sent: T
But it wont give you the schedule time.
-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Lee, Gary D.
Sent: Thursday, September 28, 2006 9:41 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: Select statements
Why not just do a
Q assoc * *
That will give
:25 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Select statements
I need a select that will give me all of my client schedules and tell
me who is associated with them and what time they run.
Client_schedules and associations are the tables I need. Just can't get
my select to work.
Any ideas? Not
I need a select that will give me all of my client schedules and tell
me who is associated with them and what time they run.
Client_schedules and associations are the tables I need. Just can't get
my select to work.
Any ideas? Not sure of the syntax on joining them.
thanks
large number of very useful select statements. They are mostly
for monitoring/reporting purposes, but I found them useful in coming to
terms with the constructs and syntax. Also good for getting to
understand substr and cast.
The actual raw text files with all the select commands are macro files
On May 25, 2006, at 4:08 PM, Laura Mastandrea wrote:
Where do you get the syntax information for the select statement?
i.e.
substr , etc.
I have a selection of SQL references near the bottom of
http://people.bu.edu/rbs/ADSM.QuickFacts
(seek "SQL:")
where the following URL is most appropriate
tor Manager"
Subject
Re: [ADSM-L] Select Statements
Please respond to
"ADSM: Dist Stor Manager"
Roger
I recently had to query the summary table for info regarding the
database backups. My requirement was to report how long the da
essage-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf
Of
Roger Silva
Sent: 25 May 2006 17:24
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] Select Statements
Thank You Sandeep,
I made changes since some of the fields didn't work for me, but this is
what I have:
SELECT DATE_
ent: 25 May 2006 17:24
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] Select Statements
Thank You Sandeep,
I made changes since some of the fields didn't work for me, but this is
what I have:
SELECT DATE_TIME AS DATE,TYPE,VOLUME_NAME,LOCATION FROM VOLHISTORY
WHERE TYPE='BACKUPFULL'
On May 25, 2006, at 12:24 PM, Roger Silva wrote:
Thank You Sandeep,
I made changes since some of the fields didn't work for me, but
this is
what I have:
SELECT DATE_TIME AS DATE,TYPE,VOLUME_NAME,LOCATION FROM VOLHISTORY
WHERE TYPE='BACKUPFULL'
But, what I would like to do is pull just the las
f
Roger Silva
Sent: Thursday, May 25, 2006 1:54 AM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] Select Statements
Hi,
I am new to the this list and need some advice.
I am trying to create a select statement I can run to monitor the
Database
Backups of our TSM Servers. I know there are fields in the S
-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Roger Silva
Sent: Thursday, May 25, 2006 1:54 AM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] Select Statements
Hi,
I am new to the this list and need some advice.
I am trying to create a select statement I can run to m
om summary where activity='FULL_DBBACKUP'
HTH
Leigh
-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Roger Silva
Sent: 24 May 2006 21:24
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] Select Statements
Hi,
I am new to the this list and nee
Hi,
I am new to the this list and need some advice.
I am trying to create a select statement I can run to monitor the
Database Backups of our TSM Servers. I know there are fields in the
SUMMARY portion of the table that has Start Time, End Time, Activity,
Entity, Volume Name and Successful fiel
.
David
>>> [EMAIL PROTECTED] 6/30/2004 7:33:20 AM >>>
Hi everyone I need some help.
Was told by a colleague that you can run queries using SQL
select
statements to obtain information regarding a TSM server.
I am trying to compose a select statement to display filespaces on
778 39 15
Telefax: +49 211 778 16 02
Handy: +49 170 576 44 15
mailto:[EMAIL PROTECTED]
"ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> schrieb am 30.06.2004
13:33:20:
> Hi everyone I need some help.
> Was told by a colleague that you can run queries using SQL sele
Hi,
First, try to avoid select statements against backup table since it take
some time to run... (and nobody mentioned it...)
Second, look at http://people.bu.edu/rbs/ADSM.QuickFacts, there are alot of
SQL links at the end.
Third, try select node_name, filespace_name, substr(cast(backup_end as
"Karin Dambacher" <[EMAIL PROTECTED]>
>you can use the sample script FSNOBACKUP. Start it with "run
>fsnobackup 3"
>(3 = 3 days since they have not been completed).
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On
Behalf Of Moses Show
>Where can I locate this sample script
Read your
|
| Kopie:(Blindkopie: Karin Dambacher/Emprise)
|
Where can I locate this sample script
"Karin Dambacher" <[EMAIL PROTECTED]>
Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
30/06/2004 13:21
Please respond to
"ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
To
[EMAIL PROTECTED]
cc
Subje
|
| Kopie:(Blindkopie: Karin Dambacher/Emprise)
Hi,
I forgot to include the select statement that I have written. It takes the
following form.
"select node_name, filespace_name, date(backup_date) from backups where
((days(backup_date) - days(current_date))) >=-3"
==
Thi
Hi everyone I need some help.
Was told by a colleague that you can run queries using SQL select
statements to obtain information regarding a TSM server.
I am trying to compose a select statement to display filespaces on the
server which have not been backed up in the last three days
Bernd Schemmer <[EMAIL PROTECTED]> wrote:
>I'm writing some scripts using dsmadmc with the select command to
>retrieve data from the TSM database. At this time I've to use various
>grep commands to remove the headers and footers from the dsmadmc output.
>
>Is it possible to suppress those headers
r 2003 1:12
> To: [EMAIL PROTECTED]
> Subject: Suppress header and footer lines of select statements
>
>
> Hi,
>
> thanks to all that replied to my question regarding compression - the
> cause of the problem was the double-compression by TSM and the drive.
>
> No
Hi,
thanks to all that replied to my question regarding compression - the
cause of the problem was the double-compression by TSM and the drive.
Now I've another question:
I'm writing some scripts using dsmadmc with the select command to
retrieve data from the TSM database. At this time I've to us
nt: Tuesday, January 07, 2003 10:36 AM
> To: [EMAIL PROTECTED]
> Subject: Re: Format of output file using select statements
>
>
> Is there an ODBC driver for Unix and Mysql?
>
>
> Andy Carlson|\ _,,,---,,_
> Se
If using perl, please consider using the TSM for PERL module from Jörg
Nouvertné at:
http://home.wtal.de/the_swordsman/
It returns your data in hashes, i.e.
my $arrayref = $tsm->select("* from volumes");
foreach my $element (@$arrayref)
{
print "$element->{VOLUME_NAME}:\t $element->
bject: Re: Format of output file using select statements
Is there an ODBC driver for Unix and Mysql?
Andy Carlson|\ _,,,---,,_
Senior Technical Specialist ZZZzz /,`.-'`'-. ;-;;,_
BJC Health Care
anager"
To: [EMAIL PROTECTED]
cc:
Subject:Re: Format of output file using select statements
Is there an ODBC driver for Unix and Mysql?
Andy Carlson|\ _,,,---,,_
Senior Technical Specialist
ce.
Matt Simpson <[EMAIL PROTECTED]>
Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
01/07/2003 06:27
Please respond to "ADSM: Dist Stor Manager"
To: [EMAIL PROTECTED]
cc:
Subject:Re: Format of output file using select stateme
up status\" $people \<
/tmp/file2
.out" );
unlink $filename;
unlink $tmpfilename;
Matt Simpson <[EMAIL PROTECTED]>
Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
01/07/2003 08:27 AM
Please respond to "ADSM: Dist Stor Manager"
To: [
Is there an ODBC driver for Unix and Mysql?
Andy Carlson|\ _,,,---,,_
Senior Technical Specialist ZZZzz /,`.-'`'-. ;-;;,_
BJC Health Care|,4- ) )-,_. ,\ ( `'-'
St. Louis, Missouri
>People here have suggested various ingenious combinations of
>tail/awk/grep to strip out the garbage, and they work fairly well.
>But that seems a little Rube Goldbergish, and I'm a little worried
>that it might break if something in the output changes. I think I
>already know the answer (No), bu
At 23:33 -0600 1/6/03, Roger Deschner wrote:
Neither of these formats, which were designed to be human-readable, are
particularly easy for re-digestion by a computer program of any kind -
especially when a field is split across lines.
One of the challenges to machine-readable output from dsmadmc
>When I run this on a terminal, it returns a format like:
>
> DATE_TIME: 2003-01-01 16:30:00.00
> MSGNO: 402
> SEVERITY: I
Select *wants* to produce the results in columnar format, and will
be able to if the number of columns and their combined width fits into
the window width. You can u
he command line is your friend.
>"Good enough" is the enemy of excellence.
>
>
>
>
>Andy Carlson <[EMAIL PROTECTED]>
>Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
>01/02/2003 15:21
>Please respond to "ADSM: Dist Stor Mana
enemy of excellence.
Andy Carlson <[EMAIL PROTECTED]>
Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
01/02/2003 15:21
Please respond to "ADSM: Dist Stor Manager"
To: [EMAIL PROTECTED]
cc:
Subject: Format of output file using
I figure this has something to do with running in a terminal or not. I
run the following command:
/usr/local/bin/tsmua -outfile=xx run qact.rep
When I run this on a terminal, it returns a format like:
DATE_TIME: 2003-01-01 16:30:00.00
MSGNO: 402
SEVERITY: I
MESSAGE: ANR0402I Sess
'.' || trim(cast(client_sublevel as char(2)))
as "Level" from nodes order by 2,4,1
Paul D. Seay, Jr.
Technical Specialist
Naptheon Inc.
757-688-8180
-Original Message-
From: Jolliff, Dale [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 18, 2002 1:13 PM
To: [EM
Thanks to you all, perfect answer!
-Original Message-
From: Cook, Dwight E [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 18, 2002 12:52 PM
To: [EMAIL PROTECTED]
Subject: Re: Select statements syntax
Way to go Paul !
example run against the occupancy table...
tsm: TSMSRV01
0.03
0.000.00
6.146.12
0.240.24
294.77290.99
<... and on ...>
Dwight
-Original Message-
From: Paul van Dongen [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 18, 2002 12:33 PM
To: [EMAIL PROTECTED]
Subject: RES: Select statements syntax
Try something like this:
Select cast(clien
-0353
-Mensagem original-
De: Jolliff, Dale [mailto:[EMAIL PROTECTED]]
Enviada em: Wednesday, December 18, 2002 15:13
Para: [EMAIL PROTECTED]
Assunto: Select statements syntax
I need to create a select statement that concatenates numeric fields as text
-- I need to create a single text
I need to create a select statement that concatenates numeric fields as text
-- I need to create a single text field from the four numeric fields in the
NODES table into a single text field.
Once I get the fields CAST as CHAR type, how do I concatenate them?
I tried SUBSTR but it pukes on too man
t: Re: Select statements
It's an SQL thing.
SQL operations occur in a certain order.
When you do a SELECT to query a table, the results you get back are actually
another (temporary) table.
"where" clauses are applied to columns in the original table
"order" clauses are applie
55 matches
Mail list logo
