This works:

select distinct stgpool_name as "Pool",     count(volume_name) as "No. 
Volumes",  cast( sum(est_capacity_mb / 1024 * pct_utilized/100) as 
decimal(9,3))            as "GB Reclaimable"  FROM   volumes   WHERE  
pct_reclaim
> $1 GROUP BY stgpool_name

I don't know why.

May be a bug:
https://www-304.ibm.com/support/docview.wss?uid=swg1IC61919



-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of 
Lee, Gary D.
Sent: Tuesday, June 07, 2011 10:24 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: [ADSM-L] Help with tsm script

I have a script which under tsm 5.5.4 server gives a report of

The storage pool name, count ov reclaimable volumes, and reclaimable space for 
the specified percentage.
You execute as follows:

Run reclaim-check 55

Under tsm 6.2.2, I get an arithmetic exception sqlstate 22003.
I don't see the problem.

Script follows:

 SELECT distinct stgpool_name as "Pool", - 
    count(volume_name) as "No. Volumes", - 
    cast(sum(cast((est_capacity_mb / 1024 *  - 
    (pct_utilized / 100)) - 
    as decimal(9,3))) as decimal(9,3)) - 
    as "GB Reclaimable" - 
 FROM   volumes - 
 WHERE  pct_reclaim>$1 - 
 GROUP BY stgpool_name 


Any ideas?
The error message gives no help as to what part of the expression gives the 
exception.
Thanks for any help you can give.


Gary Lee
Senior System Programmer
Ball State University
phone: 765-285-1310