Re: How to prevent leading spaces in SQL output

[Harris, Steven]

Hi Eric

There are also the STRIP and TRIM sql functions - same function for these but 
slightly different syntax.

SELECT strip(cast(float(used_space_mb)*100/total_space_mb AS DECIMAL(4,2))) 
FROM log

However, when I tested this on a number less than 1, the implicit cast of the 
number to a string lost the leading zero.  That may or may not suit your use 
case.

Regards

Steve

Steven Harris
TSM Consultant
Canberra, Australia


-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Loon, 
Eric van (ITOPT3) - KLM
Sent: Wednesday, 25 January 2017 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@VM.MARIST.EDU] On Behalf Of Martin 
Janosik
Sent: woensdag 25 januari 2017 11:04
To: ADSM-L@VM.MARIST.EDU
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 -dataonly=yes "SELECT CAST(float 
(used_space_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 prevent leading spaces in SQL output Sent by: 
> "ADSM: Dist Stor Manager" 
>
> Hi TSM-ers!
> I'm executing the following command in a script:
>
> /usr/bin/dsmadmc -se=$INSTANCE -id=$ID -password=$PASSWORD - 
> dataonly=yes "SELECT CAST(float(used_space_mb)*100/total_space_mb AS
> DECIMAL(4,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 a way to remove all formatting through the SQL 
> statement itself.
> Thanks for any help in advance!
> Kind regards,
> Eric van Loon
> Air France/KLM Storage Engineering
>
> 
> For information, services and offers, please visit our web site:
> http://www.klm.com. This e-mail and any attachment may contain 
> confidential and privileged material intended for the addressee only.
> If you are not the addressee, you are notified that no part of the 
> e-mail or any attachment may be disclosed, copied or distributed, and 
> that any other action related to this e-mail or attachment is strictly 
> prohibited, and may be unlawful. If you have received this e-mail by 
> error, please notify the sender immediately by return e-mail, and 
> delete this message.
>
> Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/ or 
> its employees shall not be liable for the incorrect or incomplete 
> transmission of this e-mail or any attachments, nor responsible for 
> any delay in receipt.
> Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal 
> Dutch Airlines) is registered in Amstelveen, The Netherlands, with 
> registered number 33014286
> 
>

For information, services and offers, please visit our web site: 
http://www.klm.com. This e-mail and any attachment may contain confidential and 
privileged material intended for the addressee only. If you are not the 
addressee, you are notified that no part of the e-mail or any attachment may be 
disclosed, copied or distributed, and that any other action related to this 
e-mail or attachment is strictly prohibited, and may be unlawful. If you have 
received this e-mail by error, please notify the sender immediately by return 
e-mail, and delete this message. 

Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its 
employees shall not be liable for the incorrect or incomplete transmission of 
this e-mail or any attachments, nor responsible for any delay in receipt. 
Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch 
Airlines) is registered in Amstelveen, The Netherlands, with registered number 
33014286



This message and any attachment is confidential and may be privileged or 
otherwise protected from disclosure. You should immediately delete the message 
if you are not the intended recipient. If you have received this email by 
mistake please delete it from your system; you should not copy the message or 
disclose its content to anyone. 

This electronic communication may contain general financial product advice but 

Re: 8.1 Linux client and IT13701 causing heartburn

[Zoltan Forray]

Heinz

Have you heard anything back from IBM on your PMR? I just had another
user call with the same problem, except that they ran traces to figure out
where it was failing and the directory it stops on does not have but a few
sub/nested directories.  Fortunately, the TESTFLAGS workaround seems to
have worked for them.

If you Google the error message, someone with a Windows 2016 server is also
experiencing the "1400" problem.

On Tue, Jan 10, 2017 at 5:31 AM, Heinz Flemming 
wrote:

> According to Zoltan Forray
> > Thanks you for confirming this and opening the PMR.
> >
> > I have passed the "workaround" to the user who first discovered the
> "issue"
> > to see if it fixes his problem.  I hope a patch comes out soon that
> allows
> > us to choose this upper-limit.
> >
> > Can you post the PMR number so we can follow it?
>
> PMR 63214,073,724
>
> IBM will open an APAR.
>
>
> Greetings, Heinz
>
> --
> Karlsruher Institut fuer Technologie (KIT)
> Steinbuch Centre for Computing (SCC)
>
> Heinz Flemming
> Scientific Data Management (SDM)
>
> 76131 Karlsruhe
> E-Mail: heinz.flemm...@kit.edu
> www.scc.kit.edu
> --
>



--
*Zoltan Forray*
Spectrum Protect (p.k.a. TSM) Software & Hardware Administrator
Xymon Monitor Administrator
VMware Administrator (in training)
Virginia Commonwealth University
UCC/Office of Technology Services
www.ucc.vcu.edu
zfor...@vcu.edu - 804-828-4807
Don't be a phishing victim - VCU and other reputable organizations will
never use email to request that you reply with your password, social
security number or confidential personal information. For more details
visit http://infosecurity.vcu.edu/phishing.html

Re: Advice for archiving 80 billion of small files.

[Bo Nielsen]

Hi All,

Thanks you for all the replies. It was  very helpful for me, but not for the 
management. 
I think they want anything else. Because many of the files have Japanese or 
Chinese characters,
So it's difficult to index the Tar files.

Regards

Bo  

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Skylar 
Thompson
Sent: 20. januar 2017 15:43
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] Advice for archiving 80 billion of small files.

Do you need to recover files individually? If so, then image backup (at least 
on its own) won't be a good option. One thing you could do is tar up chunks 
(maybe a million files) and archive/backup those chunks. Keep a catalog 
(hopefully a database with indexes) of which files are in which tar balls, and 
then when you go to restore you only have to recover 1/8 of your data to 
get one file.

On Fri, Jan 20, 2017 at 02:18:04PM +, Bo Nielsen wrote:
> Hi all,
>
> I need advice.
> I must archive 80 billion small files, but that is not possible, as I see it.
> since it will fill in the TSM's Database about 73 Tb.
> The filespace is mounted on a Linux server.
> Is there a way to pack/zip the files, so it's a smaller number of files.
> anybody who has tried this ??
>
> Regards,
>
> Bo Nielsen
>
>
> IT Service
>
>
>
> Technical University of Denmark
>
> IT Service
>
> Frederiksborgvej 399
>
> Building 109
>
> DK - 4000 Roskilde
>
> Denmark
>
> Mobil +45 2337 0271
>
> boa...@dtu.dk

--
-- Skylar Thompson (skyl...@u.washington.edu)
-- Genome Sciences Department, System Administrator
-- Foege Building S046, (206)-685-7354
-- University of Washington School of Medicine