Hello

Try to run a select command to get the occupancy  for each storage pool,
but get an error. The syntax I ran:

select logical_mb as "Capacity" from occupancy group by stgpool_name

What is the correct syntax !!!!!

Regards Robert


*****************************************************************
* Ouzen Robert             E-mail: robert AT research.haifa.ac DOT il  *
* Helpdesk Manager         Phone:  (972)-4-8240345              *
* Computer Center          Fax:    (972)-4-8342097              *
* University of Haifa              (972)-4-8249177              *
* Mt. Carmel, Haifa 31905 Israel                                *
*****************************************************************