Re: Output file

2017-03-08 Thread Meunier, Yann
ensez à l’environnement : n'imprimez que si nécessaire ! -Message d'origine- De : ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] De la part de rou...@univ.haifa.ac.il Envoyé : mercredi 8 mars 2017 10:25 À : ADSM-L@VM.MARIST.EDU Objet : [ADSM-L] Output file Hi to all Somet

Output file

2017-03-08 Thread rou...@univ.haifa.ac.il
Hi to all Something strange , try to redirect an output of the command to a file : Dsmc q ba c:\temp\* -su=yes -detail –querysummary > c:\test.txt Without any success , create the file empty Running without the redirection in dsmc shown: IBM Tivoli Storage Manager Command Line Bac

Re: How to prevent leading spaces in SQL output

2017-01-27 Thread Loon, Eric van (ITOPT3) - KLM
Storage Engineering -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Harris, Steven Sent: donderdag 26 januari 2017 22:52 To: ADSM-L@VM.MARIST.EDU Subject: Re: How to prevent leading spaces in SQL output Hi Eric There are also the STRIP and TRIM

Re: How to prevent leading spaces in SQL output

2017-01-26 Thread Harris, Steven
11:53 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] How to prevent leading spaces in SQL output Hi Martin! Again, thank you very much for your help! Kind regards, Eric van Loon Air France/KLM Storage Engineering -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L

Re: How to prevent leading spaces in SQL output

2017-01-25 Thread Loon, Eric van (ITOPT3) - KLM
Subject: Re: How to prevent leading spaces in SQL output Hi Eric, '-tab' does the magic: [~]$ dsmadmc -tab -se=TSM -id=admin -pa=admin -dataonly=yes "SELECT CAST (float(used_space_mb)*100/total_space_mb AS DECIMAL(4,2)) FROM log" 0.98 [~]$ dsmadmc -se=TSM -id=admin -pa=admin -

Re: How to prevent leading spaces in SQL output

2017-01-25 Thread Sasa Drnjevic
,2)) FROM > log" > > The result is this (without quotes): > > ' 0.49' > > I'm looking for a way to remove the leading spaces, so the output is just > '0.49'. I know I can do it in the script itself, but I'm just wondering if > there is

Re: How to prevent leading spaces in SQL output

2017-01-25 Thread Martin Janosik
mb)*100/total_space_mb AS DECIMAL(4,2)) FROM log" 0.98 Bye Martin Janosik "ADSM: Dist Stor Manager" wrote on 01/25/2017 10:01:51 AM: > From: "Loon, Eric van (ITOPT3) - KLM" > To: ADSM-L@VM.MARIST.EDU > Date: 01/25/2017 10:06 AM > Subject: [ADSM-L] How to pr

How to prevent leading spaces in SQL output

2017-01-25 Thread Loon, Eric van (ITOPT3) - KLM
I'm looking for a way to remove the leading spaces, so the output is just '0.49'. I know I can do it in the script itself, but I'm just wondering if there is a way to remove all formatting through the SQL statement itself. Thanks for any help in advance! Kind regards, Eri

Re: VM restore output

2016-09-25 Thread Robert Ouzen
Francisco Molero Sent: Sunday, September 25, 2016 12:42 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] VM restore output Hello, I think you are not choosing the right table ( summary_extended ). One example: select cast((sub_entity) as char(36)) as "VM MACHINE",  cast((entity) a

Re: VM restore output

2016-09-25 Thread Efim
Hello, try to select from the SUMMARY_EXTENDED table. Efim > 25 сент. 2016 г., в 10:26, Robert Ouzen написал(а): > > Hello all > > Try to figure how to retrieve information of restore VM from TSM for VE. > > I wrote a script to retrieve , restore information but got for entity the > name o

Re: VM restore output

2016-09-25 Thread Dmitry Dukhov
nope it’s impossible names of vm are inside filespace Dmitry > On 25 Sep 2016, at 09:26, Robert Ouzen wrote: > > Hello all > > Try to figure how to retrieve information of restore VM from TSM for VE. > > I wrote a script to retrieve , restore information but got for entity the > name of th

VM restore output

2016-09-25 Thread Robert Ouzen
Hello all Try to figure how to retrieve information of restore VM from TSM for VE. I wrote a script to retrieve , restore information but got for entity the name of the proxy and not the name of the VM machine. Here the script: SELECT cast((entity) as char(36)) as "Node Postback" , DATE(start_

VM restore output

2016-09-24 Thread Robert Ouzen
ot; , DATE(start_time) as DATE, cast((activity) as char(15)) as OPERATION, cast(float(SUM(bytes))/1024/1024/1024 as DEC(8,1)) as GB FROM summary WHERE activity='RETRIEVE' OR activity='RESTORE' GROUP BY entity,DATE(start_time),activity ORDER BY DATE DESC Output: tsm: POSTBACK&g

Re: Weird SQL output

2014-11-24 Thread Loon, EJ van (ITOPT3) - KLM
ARIST.EDU] On Behalf Of Efim Sent: vrijdag 21 november 2014 17:41 To: ADSM-L@VM.MARIST.EDU Subject: Re: Weird SQL output Erik, I can't believe that you're never checkin private tapes. After checked in last_use is NULL. It is not an issue. It just tell that nobody use this tape after it

Re: Weird SQL output

2014-11-21 Thread Efim
PT3) - KLM : > Hi Efim! > Since we don't checkout tapes it won't be an issue for us. Apart from that, > it still doesn't explain why the total of last_use='Data' and > last_use!='Data' is not equal to the output from the query with no last_used >

Fw: Weird SQL output

2014-11-21 Thread Andrew Raibeck
%20Storage%20Manager - Forwarded by Andrew Raibeck/Hartford/IBM on 2014-11-21 08:13 - Andrew Raibeck/Hartford/IBM wrote on 2014-11-21 08:12:33: > From: Andrew Raibeck/Hartford/IBM > To: "ADSM: Dist Stor Manager" > Date: 2014-11-21 08:12 > Subject: Re: Weird SQL o

Re: Weird SQL output

2014-11-21 Thread Andrew Raibeck
kis/home/wiki/Tivoli%20Storage%20Manager "ADSM: Dist Stor Manager" wrote on 2014-11-21 08:02:09: > From: "Loon, EJ van (ITOPT3) - KLM" > To: ADSM-L@VM.MARIST.EDU > Date: 2014-11-21 08:03 > Subject: Re: Weird SQL output > Sent by: "ADSM: Dist Stor Manager&q

Re: Weird SQL output

2014-11-21 Thread Loon, EJ van (ITOPT3) - KLM
Hi Efim! Since we don't checkout tapes it won't be an issue for us. Apart from that, it still doesn't explain why the total of last_use='Data' and last_use!='Data' is not equal to the output from the query with no last_used specified. As to your query: I foun

Re: Weird SQL output

2014-11-21 Thread Efim
s NULL and volume_name not in (select volume_name from volumes) Efim 2014-11-21 12:16 GMT+03:00 Loon, EJ van (ITOPT3) - KLM : > Hi guys! > I have some weird output from one of my SQL statements. Here it's is: > > select count(*) from libvolumes where status='Private' >

Weird SQL output

2014-11-21 Thread Loon, EJ van (ITOPT3) - KLM
Hi guys! I have some weird output from one of my SQL statements. Here it's is: select count(*) from libvolumes where status='Private' Unnamed[1] 3698 Ok, so 3698 private volumes on this server. Now, how many contain data: select count(*) from libvolum

Re: Writing error/output to syslog

2014-05-19 Thread Skylar Thompson
00, George Marselis wrote: > Hey guys, > > I am running the 7.1 client. I would like the scheduler to write output > and errors to syslog. > > I just finished reading the B/A guide, but I did not come around finding > anything about redirecting the scheduler output and error stre

Writing error/output to syslog

2014-05-19 Thread George Marselis
Hey guys, I am running the 7.1 client. I would like the scheduler to write output and errors to syslog. I just finished reading the B/A guide, but I did not come around finding anything about redirecting the scheduler output and error streams to syslog. I also googled around a bit, but I could

Re: 6.2 output formatting

2011-03-10 Thread deehre01
dmin client (on windows) and a 5.5 server the TSM query output looks like... NODE_NAME STATUS RESULT SCH_DATE SCH_TIME ACT_DATE ACT_TIME -- -- --- -- --

Re: 6.2 output formatting

2011-03-09 Thread Steven Harris
rds Steve. On 10/03/2011 11:40 AM, Andrew Raibeck wrote: Hi Steve, Off-hand I'm not sure what changed in the output formatting, but have you looked into use the "-tabdelimited" and "-dataonly=yes" options on the dsmadmc command line? This should overall make parsing mu

Re: 6.2 output formatting

2011-03-09 Thread Andrew Raibeck
Hi Steve, Off-hand I'm not sure what changed in the output formatting, but have you looked into use the "-tabdelimited" and "-dataonly=yes" options on the dsmadmc command line? This should overall make parsing much easier than trying to handle the default formatting. For

Re: 6.2 output formatting

2011-03-09 Thread Marcel Anthonijsz
windows) and a > 5.5 server the TSM query output looks like... > > NODE_NAME STATUS RESULT > SCH_DATE SCH_TIME ACT_DATE ACT_TIME > -- -- --- > -- --

6.2 output formatting

2011-03-09 Thread Steve Harris
A and the end result is a consolidated backup spreadsheet for each customer, for the whole month. The issue I have is that with a 6.2.0.0 admin client (on windows) and a 5.5 server the TSM query output looks like... NODE_NAME STATUS RESULT SCH_DATE SCH

Re: Output of script in TSM 6

2010-11-07 Thread Richard Sims
Further, if you are operating through dsmadmc, you can employ -DISPLaymode=LISt|TABle

Re: Output of script in TSM 6

2010-11-07 Thread Robert Ouzen
[ADSM-L] Output of script in TSM 6 The length of the fields are much wider than at version 5 Try: select substr(node_name,1,15) as NODE_NAME,substr(tcp_address,1,15) as IPADDRESS,substr(contact,1,20) as CONTACT from nodes where  node_name = upper('$1') order by 2 Now we just take the

Re: Output of script in TSM 6

2010-11-07 Thread Richard Sims
Another approach is a wider window or smaller fonts.

Re: Output of script in TSM 6

2010-11-07 Thread Maurice van 't Loo
Sent: Sunday, November 07, 2010 2:02 PM > To: ADSM-L@VM.MARIST.EDU > Subject: Re: [ADSM-L] Output of script in TSM 6 > > Check out: > set sqldisplaymode wide|narrow > > All the sql output from 5.5 scripts need to be checked and corrected in > version 6. > > Good luck,

Re: Output of script in TSM 6

2010-11-07 Thread Robert Ouzen
Hi Maurice I already check it and I am in wide option Regards Robert -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Maurice van 't Loo Sent: Sunday, November 07, 2010 2:02 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Output of s

Re: Output of script in TSM 6

2010-11-07 Thread Maurice van 't Loo
Check out: set sqldisplaymode wide|narrow All the sql output from 5.5 scripts need to be checked and corrected in version 6. Good luck, Maurice van 't Loo 2010/11/7 Robert Ouzen : > Hi to all > > I am testing a TSM version 6.2.1 in a Windows test environment and a little > que

Output of script in TSM 6

2010-11-07 Thread Robert Ouzen
digiprod (select node_name , tcp_address, contact from nodes where node_name = upper('$1') order by 2) Output: Version 6 NODE_NAME: DIGIPROD TCP_ADDRESS: 132.74.59.177 CONTACT: Library Output: Version 5 NODE_NAME TCP_ADDRESS

Re: Looking for Examples of Nmon output from TSM V6x system

2010-07-15 Thread Dave Canan
: ADSM-L@VM.MARIST.EDU > Onderwerp: Re: [ADSM-L] Looking for Examples of Nmon output from TSM V6x > system > > Hi all > > This would be great I agree. If someone could post the result to the > board, it would be greatly appreciated. > > > Regards > > Adrian Compton >

Re: Looking for Examples of Nmon output from TSM V6x system

2010-07-15 Thread Stefan Folkerts
Adrian Compton Verzonden: donderdag 15 juli 2010 16:06 Aan: ADSM-L@VM.MARIST.EDU Onderwerp: Re: [ADSM-L] Looking for Examples of Nmon output from TSM V6x system Hi all This would be great I agree. If someone could post the result to the board, it would be greatly appreciated. Regards Adrian Co

Re: Looking for Examples of Nmon output from TSM V6x system

2010-07-15 Thread Adrian Compton
output from TSM V6x system Dave, are you still looking for this info because I think I can get this info from a SLES 10 site running 6.2.1.0 and ~100 clients. -Oorspronkelijk bericht- Van: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] Namens Dave Canan Verzonden: woensdag 9 juni

Re: Looking for Examples of Nmon output from TSM V6x system

2010-07-15 Thread Stefan Folkerts
@VM.MARIST.EDU Onderwerp: [ADSM-L] Looking for Examples of Nmon output from TSM V6x system I'm looking for some examples of nmon output from customers using TSM V6.x on an AIX or Linux platform. I would prefer if the output was from an production TSM V6 system having lots of activity. Th

Looking for Examples of Nmon output from TSM V6x system

2010-06-09 Thread Dave Canan
I'm looking for some examples of nmon output from customers using TSM V6.x on an AIX or Linux platform. I would prefer if the output was from an production TSM V6 system having lots of activity. This is for a presentation I'm developing on the Sizing, Monitoring, and Performa

Re: Migration choosing output volume in the SAME POOL?!?

2010-01-06 Thread Harvey, Bruce T
u] On Behalf Of | Wanda Prather | Sent: Wednesday, January 06, 2010 2:01 PM | To: ADSM-L@VM.MARIST.EDU | Subject: Re: [ADSM-L] Migration choosing output volume in the SAME POOL?!? | | We've also had this morning pick all 4 output volumes in the same pool. | | Gretchen got it in 1 - it's do

Re: Migration choosing output volume in the SAME POOL?!?

2010-01-06 Thread Wanda Prather
We've also had this morning pick all 4 output volumes in the same pool. Gretchen got it in 1 - it's doing reclamation. I also found in the SUMMARY table that the volumes showed up as having been RECLAIMED, not migrated. We set reclaim to 100 on the source pool, killed and restarted,

Re: Migration choosing output volume in the SAME POOL?!?

2010-01-06 Thread Harvey, Bruce T
Have you tried to lower the number of processes to 3 or increase it to 5 to see how they end up picking volumes? If it goes away in 3 and you get two CDLPOOL output volumes, that could mean a silly limitation somebody left in. However, if it's always 1, whether 2, 3, or 9, there&#x

Migration choosing output volume in the SAME POOL?!?

2010-01-06 Thread Wanda Prather
4 migration processes, as one would expect. Except 3 of the processes choose a CDLPOOL volume as the input volume, and an LTO2 TAPEPOOL volume as the output volume. The 4th process chooses a CDLPOOL volume as the input volume, AND chooses a CDLPOOL volume as the OUTPUT volume. WHAT circumstance cause

Re: Colorful console mode output

2009-08-24 Thread lindsay morris
ibm.com/software/sysmgmt/products/support/IBMTivoliStorageManager.html The only dumb question is the one that goes unasked. The command line is your friend. "Good enough" is the enemy of excellence. "ADSM: Dist Stor Manager" wrote on 08/22/2009 01:44:22 AM: [image removed] Re

Re: Colorful console mode output

2009-08-24 Thread Andrew Raibeck
s.ibm.com IBM Tivoli Storage Manager support web page: http://www.ibm.com/software/sysmgmt/products/support/IBMTivoliStorageManager.html The only dumb question is the one that goes unasked. The command line is your friend. "Good enough" is the enemy of excellence. "ADSM: Dist

Re: Colorful console mode output

2009-08-24 Thread Tchuise, Bertaut
gust 22, 2009 4:54 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Colorful console mode output On Sat, Aug 22, 2009 at 8:44 AM, Yudi Darmadi wrote: > What about windows console? What modification should i do in order to > make that script runs? > > Don't know :) I know very li

Re: Colorful console mode output

2009-08-22 Thread Michael Green
On Sat, Aug 22, 2009 at 8:44 AM, Yudi Darmadi wrote: > What about windows console? What modification should i do in order to make > that script runs? > > Don't know :) I know very little about windows. I'm not even sure how Windows console looks like. Is that the black window that one can get via

Re: Colorful console mode output

2009-08-22 Thread Michael Green
On Sat, Aug 22, 2009 at 7:59 AM, Stef Coene wrote: > Nice scripts (I have something similar), but I had to replace ^[ with \033 for > the colors to work on my linux box. What actually happened is that after you copied and pasted the script into a new file the special meaning of the escape code t

Re: Colorful console mode output

2009-08-22 Thread Yudi Darmadi
://www.niagaprima.com - Original Message - From: "Stef Coene" To: Sent: Saturday, August 22, 2009 11:59 AM Subject: Re: [ADSM-L] Colorful console mode output On Saturday 22 August 2009, Michael Green wrote: If you are like me and find it helpful to have administrative client running in co

Re: Colorful console mode output

2009-08-21 Thread Stef Coene
On Saturday 22 August 2009, Michael Green wrote: > If you are like me and find it helpful to have administrative client > running in console mode (dsmadmc -console) while performing > administrative work on your server, you might find this little script > (below) handy. I also have a habit of leavi

Colorful console mode output

2009-08-21 Thread Michael Green
If you are like me and find it helpful to have administrative client running in console mode (dsmadmc -console) while performing administrative work on your server, you might find this little script (below) handy. I also have a habit of leaving dsmadmc -console running for prolonged periods of time

Re: query vol output format

2009-06-02 Thread Keith Arbogast
Roger, I didn't realize this problem had a moral component,-- but your suggestion worked, and I am grateful. Thank you and best wishes, Keith Arbogast Indiana University

Re: query vol output format

2009-06-01 Thread Roger Deschner
Basically, you should not be trapping the output of any QUERY commands. These are designed to be human-readable, not machine-readable. Instead you should be doing SQL-style SELECT commands to retrieve exactly the information you want, in a format that is much less likely to change with new

query vol output format

2009-06-01 Thread Keith Arbogast
The 'query volume' output from a Linux TSM 5.4.0.3 server is formatted with expanded numbers in the 'Estimated Capacity' field. The 'query volume' output from a linux TSM 5.5.2.1 server is formatted with 'G' or 'T' in the 'Estimated Capaci

TSM v6 How to SELECT output sequence of actlog (summary) in true date time sequence?

2009-05-06 Thread Cowen, Richard
I don't see an exposed unique key on actlog/summary/events. I would like to get it in the same order TSM v3,4,5 did by default- in the sequence the rows were posted. In particular, I would like to see the start session at the top and the end session at the bottom. I realize the "events" can be p

Re: Output manipulation on selects

2009-03-26 Thread Andrew Raibeck
dsmadmc -id=adminid -pa=x -commadelimited -dataonly=yes macro tsm.macro Note: using -commadelimited forces the output to one line per record without having to us the AS "SQL STATEMENT" part. And -dataonly=yes suppresses all the header information so you get only your output records

Antwort: Re: [ADSM-L] Output manipulation on selects

2009-03-26 Thread Ullrich Mänz
Gesendet von: "ADSM: Dist Stor Manager" 26.03.2009 08:42 Bitte antworten an "ADSM: Dist Stor Manager" An ADSM-L@VM.MARIST.EDU Kopie Thema Re: [ADSM-L] Output manipulation on selects Ullrich, When you have an sql statement that either contains single or double quo

Re: Output manipulation on selects

2009-03-26 Thread BEYERS Kurt
ADSM-L@VM.MARIST.EDU Onderwerp: [ADSM-L] Output manipulation on selects Hi SQL specialists, we have found a completely different behaviour when executing TSM SQL statements on different platforms. The basic idea is to produce SQL statements as an input for our analysing tool with its own (Orcale) da

Output manipulation on selects

2009-03-25 Thread Ullrich Mänz
Hi SQL specialists, we have found a completely different behaviour when executing TSM SQL statements on different platforms. The basic idea is to produce SQL statements as an input for our analysing tool with its own (Orcale) database. Our select statement (simplyfied example) and output

Output summary of data backed up per management class

2009-02-03 Thread Joni Moyer
Hi Everyone, I am trying to find out how much data I have backed up/archived per node per management class. Is there a way to get this data? I know of q auditocc, but that doesn't break it down as far as I would like to go. Any help/suggestions are greatly appreciated!

Re: Select statement to output backup & archive summary per domain

2008-12-30 Thread Joni Moyer
hodes" Sent by: "ADSM: Dist Stor Manager" 12/30/2008 07:20 AM Please respond to "ADSM: Dist Stor Manager" To ADSM-L@VM.MARIST.EDU cc Subject Re: Select statement to output backup & archive summary per domain Here is what I use for this info . . . from our morn

Re: Select statement to output backup & archive summary per domain

2008-12-30 Thread Richard Rhodes
Sent by: "ADSM: ADSM-L@VM.MARIST.EDU Dist Stor cc Manager" Select statement to output backup & archive summary per dom

SV: Select statement to output backup & archive summary per domain

2008-12-29 Thread Christian Svensson
...@highmark.com] Skickat: den 29 december 2008 21:13 Till: ADSM-L@VM.MARIST.EDU Ämne: Select statement to output backup & archive summary per domain Hi Everyone, I am trying to figure out how to configure a script that will output the total GB backed up and total GB archived per domain within a 24

Select statement to output backup & archive summary per domain

2008-12-29 Thread Joni Moyer
Hi Everyone, I am trying to figure out how to configure a script that will output the total GB backed up and total GB archived per domain within a 24 hour time period. I already have something similar, but it totals all of the data together and I would like to break it down more by the domain

Re: select output help

2008-12-19 Thread Mark Stapleton
eer, CDW. From: ADSM: Dist Stor Manager on behalf of goc Sent: Tue 12/16/2008 6:06 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] select output help oh, yea .. .thanks (going to see diff) // g On Tue, Dec 16, 2008 at 1:51 PM, Dwight Cook wrote: > You l

Re: select output help

2008-12-16 Thread goc
10.11 > > -Original Message- > From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of goc > Sent: Tuesday, December 16, 2008 6:17 AM > To: ADSM-L@VM.MARIST.EDU > Subject: [ADSM-L] select output help > > hi all, > i ha

Re: select output help

2008-12-16 Thread Dwight Cook
- - 21206 ZDEC23 Run 0 00:09:15.00 5.42 10.11 -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of goc Sent: Tuesday, December 16, 2008 6:17 AM To: ADSM-L@VM.

select output help

2008-12-16 Thread goc
35 cast((current_timestamp-start_time)seconds as decimal(18,0))) - 40 as "Bajtova primljeno/sekunda" - 45 from sessions tsm: TSM01> which gives me this output for example > sm: TSM01>ru active Sesija NodeSta

Re: Wrong devc in q pro output

2007-10-30 Thread Thomas Denier
-Richard Sims wrote: - >Misidentification of the shortfall device class in the "Waiting for >mount point" line of Query PRocess output is a defect which persists >into at least TSM 5.2, from my experience. We still have this problem in our 5.3.4.0 server.

Re: Wrong devc in q pro output

2007-10-25 Thread Richard Sims
processes say they are waiting on mount points. There are mount points available in the devclass for the primary storage pool but not in the devclass for the copy pool. But the output of the Q PRO says it is waiting on mount points in the primary devc, not the copy devc leading to some confusion

Wrong devc in q pro output

2007-10-25 Thread David E Ehresman
. There are mount points available in the devclass for the primary storage pool but not in the devclass for the copy pool. But the output of the Q PRO says it is waiting on mount points in the primary devc, not the copy devc leading to some confusion until I figured out what was going on. Has

show config output prettify

2007-06-18 Thread Matthew Warren
Hi TSM'ers Before I reinvent the wheel, I was wondering if anyone had done any work on processing the output of a 'show config' and reformatting it into something a little more friendly, and usable? Cheers, Matt. -- Matthew Warren. TSM Technical Specialist. AIX & SAN Admin

Re: How do I stop dsmadmc reformatting output when doing selects on the command line?

2007-02-09 Thread PAC Brion Arnaud
sage- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Davis, Adrian Sent: Friday, 09 February, 2007 14:12 To: ADSM-L@VM.MARIST.EDU Subject: How do I stop dsmadmc reformatting output when doing selects on the command line? How do I stop "dsmadmc" reformatting outp

Re: How do I stop dsmadmc reformatting output when doing selects on the command line?

2007-02-09 Thread Richard Sims
On Feb 9, 2007, at 8:12 AM, Davis, Adrian wrote: How do I stop "dsmadmc" reformatting output when doing "selects" on the command line or script? Have you tried its -DISPLaymode option? All the options are documented in the Administrator's Reference manual. Richard Sims

How do I stop dsmadmc reformatting output when doing selects on the command line?

2007-02-09 Thread Davis, Adrian
How do I stop "dsmadmc" reformatting output when doing "selects" on the command line or script? For example:- If I try... dsmadmc -id=script -pass=mypassword 'select * from db' ...I get... AVAIL_SPACE_MB: 17340 CAPACITY_MB: 17200 MAX_EXTENSION_

Re: direct output to a file in the directory

2006-12-04 Thread Kelly Lipp
vy Wong Sent: Monday, December 04, 2006 3:07 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] direct output to a file in the directory Hello, Can you tell me how to output the information from a query into a file in a directory? Example: q filespace NODENAME f=d I would like the output goes to

direct output to a file in the directory

2006-12-04 Thread Avy Wong
Hello, Can you tell me how to output the information from a query into a file in a directory? Example: q filespace NODENAME f=d I would like the output goes to a file rather than displaying it on the screen. Thank you. Avy Wong Business Continuity Administrator Mohegan Sun 1 Mohegan Sun

Re: Dsmc output on AIX sometimes contains a crlf

2006-10-16 Thread Matthew Warren
Hi, Oddly, the two lines of output you showed look exactly the same in my email client. But, I would approach the problem with a workaround, and pre-process the log output to remove spurious crlf's before processing it further. If you repost an example of the broken lines, I could most l

Dsmc output on AIX sometimes contains a crlf

2006-10-12 Thread Loon, E.J. van - SPLXM
Hi *SM-ers! On our AIX clients, the output from the dsmc i command is send to a logfile for further processing. Every now and then, the output from the backup of a file contains a crlf. Instead of: Normal File--> 87,042 /mount/appl00399/lido_apps/lido/etc/0008704600 [Sent] The output looks l

Re: how to determine if bulk loader / input output slots are full in 3584 library

2006-10-09 Thread Sung Y Lee
> Is there a way to determine if all the input/output slots in the > bulk loader are full ? On AIX/Unix, command called tapeutil can be used to query the i/o door from OS. or on Window there is a similar command called NTUTIL. example, tapeutil -f /dev/smc0 inventory | grep -p Import/

Re: how to determine if bulk loader / input output slots are full in 3584 library

2006-10-09 Thread PAC Brion Arnaud
--Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Richard Hammersley Sent: Monday, 09 October, 2006 16:01 To: ADSM-L@VM.MARIST.EDU Subject: how to determine if bulk loader / input output slots are full in 3584 library I have an IBM 3584 tape library with a

how to determine if bulk loader / input output slots are full in 3584 library

2006-10-09 Thread Richard Hammersley
I have an IBM 3584 tape library with a 10 slot bulk loader. Is there a way to determine if all the input/output slots in the bulk loader are full ? Presently I'm running TSM version 5.3.2.4. Under 5.1.x.x when one tried to checkout a volume and the bulk loader's input/output slots

Re: AW: [ADSM-L] TSM Client file input/output error error

2006-08-24 Thread Farren Minns
24/08/2006 10:48 |Subject| | | [ADSM-L] AW: [ADSM-L] TSM| | Please respond to | Client file input/output | | "ADSM: Dist Stor| error error |

AW: [ADSM-L] TSM Client file input/output error error

2006-08-24 Thread Thomas Rupp
or Manager [mailto:[EMAIL PROTECTED] Im Auftrag von Farren Minns Gesendet: Donnerstag, 24. August 2006 11:36 An: ADSM-L@VM.MARIST.EDU Betreff: [ADSM-L] TSM Client file input/output error error Hi All Running TSM Client 5.1.6.0 on Solaris against a 5.2.7.2 server on Solaris 2.9. We have been

Re: TSM Client file input/output error error

2006-08-24 Thread Richard Sims
Farren - Do a TSM Support Page search on the ANS4023E message, which turns up Technote 1239156, with a few other hits. Richard Simshttp://people.bu.edu/rbs

TSM Client file input/output error error

2006-08-24 Thread Farren Minns
. dsmsched.log 23/08/06   22:21:05 ANS4023E Error processing '/usr/local/webservers': file input/output error 23/08/06   22:21:05 --- SCHEDULEREC OBJECT END COI-DAILY-INC 23/08/06 21:30:00 23/08/06   22:21:05 ANS1512E Scheduled event 'COI-DAILY-INC' failed.  Return code = 12. dsmerror.l

Re: Output question

2006-08-07 Thread Alexander Verkooijen
Hi, Maybe you could use the -tab (or the -comma) option of dsmadmc to get what you want. It gives you the output on one line although it may require some formatting to make it readable. dsmadmc -id=MyAdmin -pa=MyPassword -tab "q ev * *" > bla.txt Regards, Alexander > -

Output question

2006-08-07 Thread Robert Ouzen Ouzen
Hi to all Running a query event to pick exception status as: q event * * ex=yes begind=-1 begint=17:00 endd=today endt=08:00 > c:\tsm\exception.txt Sometimes I got for a long nodename two lines: 08/03/2006 22:45:00 SCHED3

Fw: redirecting output question ...

2006-07-11 Thread Nicholas Cassimatis
blished with server TSM01: AIX-RS/6000 > Server Version 5, Release 3, Level 3.1 > Server date/time: 07/11/06 16:35:06 Last access: 07/11/06 16:34:14 > > > in output files ? stripheaders ? sumtin' like that ? > > thanks in advance > > goran

redirecting output question ...

2006-07-11 Thread goc
, Release 3, Level 3.1 Server date/time: 07/11/06 16:35:06 Last access: 07/11/06 16:34:14 in output files ? stripheaders ? sumtin' like that ? thanks in advance goran

Re: Redirecting Output of NetWare Console dsmc to a File ?

2006-05-12 Thread Rainer Wolf
Hi, thanks a lot ! it worked with dsmc q backup sys:system/tsm/ -sub=yes -ina (CLIB_OPT)/>sys:test.out best regards Rainer Matt Zufelt schrieb: is there a way to put the output of, for example, "dsmc q backup" on the NetWare 6 console into a file? Or, if not, can I use ano

Re: Redirecting output in batch files on WIN

2006-05-10 Thread Sung Y Lee
Try putting quotations "" around select statement. Like this -commadel "select 'upd node', node_name as "node_name ",'clo=""' from nodes where lastacc_time <=current_timestamp - 32 days" > house.txt I believe what's happening is that from command line still sees >redirectional1.txt as a part of

Redirecting output in batch files on WIN

2006-05-10 Thread Large, M (Matthew)
Hi TSM world, I may be missing the obvious here, but TSM is complaining about the format of my select statement before it reaches the redirect, but the statement works absolutely fine from the command line. Here's the statement: select 'upd node', node_name as "node_name ",

Re: Redirecting Output of NetWare Console dsmc to a File ?

2006-05-09 Thread Matt Zufelt
>>> On 5/9/2006 at 12:57 AM, [EMAIL PROTECTED] wrote: > Hello TSM+NetWare Experts, > > is there a way to put the output of, for example, > "dsmc q backup" on the NetWare 6 console into a file? > > Or, if not, can I use another OS's TSM client? > I

Re: Redirecting Output of NetWare Console dsmc to a File ?

2006-05-09 Thread Troy Frank
The only method I can think of off the top of my head is to put the command in a schedule, and associate that server to it. The output will show up in sys:\tivoli\tsm\client\ba\dsmsched.log >>> [EMAIL PROTECTED] 5/9/2006 1:57 AM >>> Hello TSM+NetWare Experts, is there a way

Redirecting Output of NetWare Console dsmc to a File ?

2006-05-08 Thread Rainer Wolf
Hello TSM+NetWare Experts, is there a way to put the output of, for example, "dsmc q backup" on the NetWare 6 console into a file? Or, if not, can I use another OS's TSM client? I didn't succeed with Linux and MS Windows TSM clients. T

Re: redirect output in readable format(SOLVED)

2006-01-31 Thread Dave Zarnoch
Subject: Re: [ADSM-L] redirect output in readable format Dist Stor Manager" <[EMAIL PROTECTED] .EDU> 01/31/2006 10:32 AM

Re: redirect output in readable format

2006-01-31 Thread Maria Ilieva
t;q vol 302302 f=d" > result from a UNIX command line. > I get the file "result" in unformatted output. > > How do I redirect the command from TSM to a file in "readable" format from > a UNIX command line? > > Yes.i have read the manual and have

Re: redirect output in readable format

2006-01-31 Thread Andrew Raibeck
TED] > > > > > Richard Sims > <[EMAIL PROTECTED]> To: ADSM-L@VM.MARIST.EDU > Sent by: "ADSM: cc: > Dist StorSubject: Re: [ADSM- > L] redirect ou

Re: redirect output in readable format

2006-01-31 Thread Dave Zarnoch
ent [EMAIL PROTECTED] Richard Sims <[EMAIL PROTECTED]> To: ADSM-L@VM.MARIST.EDU Sent by: "ADSM: cc: Dist StorSubject: Re: [ADSM-L] redirect output in readable forma

  1   2   3   4   >