Hi Richard,

The Select is tried-and-true, and works well.

On one of my TSM servers it gives me an SQL error due
to the formmating:

ANR2948E The value '381468.0' can not be assigned or converted to SQL
data type
DECIMAL(6,1).

                                 |
         ........................V......................................
         ZED as "PCT UTIL" , DEC(EST_CAPACITY_MB,6) AS "MB_CAPACITY" , C

ANS8001I Return code 26.

As the original poster mentioned LTO, maybe it would be better to
change this part to

DEC(EST_CAPACITY_MB,7)

(until the next big step in increasing type capacity :-) )

Greetings,

Andreas