David,

I must have been doing something wrong in my previous experimentations, as it 
appears that the query I posted yesterday which seemed not to work :

select start_time, end_time, hour(end_time-start_time)||':'|| 
minute(end_time-start_time)||':'|| second(end_time-start_time)as "Time 
elapased",entity,processes,bytes,cast(bytes/1024/1024/1024 as decimal(12,4)) as 
"GB copied",(cast(bytes as decimal(18,0))/timestampdiff(2,cast((end_time 
-start_time)as decimal(18,0)))/1048576) as "MB/second" from summary where 
activity='MIGRATION' and cast((current_timestamp-end_time) minutes as decimal) 
>0 and timestampdiff(2,(end_time-start_time)) >0 and entity like upper('%$1%')

Is finally working ...


   START_TIME: 2010-06-24 08:41:37.000000
     END_TIME: 2010-06-24 08:47:06.000000
Time elapased: 0:5:29
       ENTITY: DISKPOOL_WIN
    PROCESSES: 1
        BYTES: 4766318592
    GB copied: 4.0000
    MB/second: 13.8161569148936

Something weird must have been happening in the wonderful Tivoli 
[Dis]Integrated Portal, when it ingested my script ...

Sorry for the ones in the list which may have been inconvenienced by this 
thread, but hopefully it has been a chance for  some of you to get a script for 
monitoring migration processes throughput ;-)

Cheers.

Arnaud 
 


******************************************************************************
Corporate IT Systems & Datacenter Responsible
Panalpina Management Ltd., Basle, Switzerland,
CIT Department Viadukstrasse 42, P.O. Box 4002 Basel/CH
Phone: +41 (61) 226 11 11, FAX: +41 (61) 226 17 01
Direct: +41 (61) 226 19 78
e-mail: arnaud.brion AT panalpina DOT com
******************************************************************************


-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of 
David Bronder
Sent: jeudi 1 juillet 2010 20:54
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: Re: Syntax for SQL "upper" in TSM 6.2

PAC Brion Arnaud wrote:
>
> My problem is not to only look for some value in a field, but for
> some value as PART of the field, so something like :
>
> Upper(%'$1'%)
>
> And this does not work :-(

And as-written, it shouldn't work.  Your full example used '%$1%' (with
the "%" inside the quotes), which should be correct.  But your simplified
example keeps using %'$1'% (with the "%" outside the quotes), which is
definitely incorrect.

Try your simplified example with the "%" wildcards inside the quotes,
and maybe show us the actual errors you're getting back from the full
query you're trying to write.

(Maybe someone else currently running a 6.2 server can try a quick and
simple script with a query involving the upper('%$1%') construct just to
validate that it works correctly in 6.2?)

--
Hello World.                                    David Bronder - Systems Admin
Segmentation Fault                                     ITS-SPA, Univ. of Iowa
Core dumped, disk trashed, quota filled, soda warm.   david-bronder AT uiowa 
DOT edu