zOs/SQL/SYSTSSPA

select  left(dbname, 8),
        sum(space), sum(nActive * pgSize),
        count(*),
        sum(partitions)
    from sysibm.sysTablespace
    where dbName like 'WL%'
    group by dbname
    with ur