Do a "q script fsnobackup'. I think that might be a TSM supplied script
that does what you want. Matter of fact, do a "q script" and get
familar with the supplied scripts. Some of them are quite useful and
others serve as a good starting point for writing your own queries.
David
>>> [EMAIL PRO
Hallo,
I use
select node_name,filespace_name,backup_end from filespaces where cast
((current_timestamp-backup_end)days as decimal(3,0))>3
mit freundlichen Grüßen
Ralf Behrendt
WGZ-Bank
Organisation und Betrieb
- IT-Systeme -
Ludwig-Erhard-Alle 20
D - 40227 Düsseldorf
Telefon: +49 211 778 39
cc: (bcc: Henrik Wahlstedt)
Sent by: Subject: Re: Using select statements
"ADSM: Dist
Stor Manager"
<[EMAIL PROTECTED]
RIST.EDU>
"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. Howeve
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
22 matches
Mail list logo
